QUESTION NO: 485
Evaluate the following SQL statement used to create the PRODUCTS table:
CREATE TABLE products
(product_id NUMBER(3) PRIMARY KEY,
product_desc VARCHAR2(25),
qty NUMBER(8,2), rate NUMBER(10,2), total_value AS ( qty * rate))
PARTITION BY RANGE (total_value) (PARTITION p1 VALUES LESS THAN (100000), PARTITION p2
VALUES LESS THAN (150000), PARTITION p3 VALUES LESS THAN (MAXVALUE)) COMPRESS FOR
ALL OPERATIONS;
Which statement is true regarding this command?
A. It executes successfully but partition pruning cannot happen for this partition key.
B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the
partitions.
Answer: D
评估用来创建产品表的下面的SQL语句:
D.它成功执行,但总价值列中的值不会被物理地存储在分区里。