试题详情
- 单项选择题 Evaluate the following SQL statement used to create the PRODUCTS table： CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（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.
- D
关注下方微信公众号，在线模考后查看
热门试题
- Which two̳
- Which best describes
- You work a
- The Database&#
- 写出索引的作用与建立索引时应注意的问题。
- Given: Whatistheres
- Which Oracle Databas
- Which two̳
- There was̳
- Which two̳
- Given： Which t
- You recently&#
- 在Oracle中，约束可以在DML语句执
- Examine the structu
- Which two̳
- Examine the followi
- Consider the&#
- In your d
- Evaluatethefollowing
- You have enabled bac