Evaluate the following statements: CREATE TABLE purchase_orders (po_id NUMBER(4), po_date TIMESTAMP, supplier_id NUMBER(6), po_total NUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTITION BY RANGE(po_date) (PARTITION Q1 VALUES LESS THAN (TO_DATE(?1-apr-2007?d-mon-yyyy?), PARTITION Q2 VALUES LESS THAN (TO_DATE(?1-jul-2007?d-mon-yyyy?), PARTITION Q3 VALUES LESS THAN(TO_DATE(?1-oct - 2007?d-mon-yyyy?), PARTITION Q4 VALUES LESS THAN (TO_DATE(?1-jan-2008?d-mon-yyyy?)); CREATE TABLE purchase_order_items (po_id NUMBER(4) NOT NULL, product_id NUMBER(6) NOT NULL, unit_price NUMBER(8,2), quantity NUMBER(8), CONSTRAINT po_items_fk FOREIGN KEY (po_id) REFERENCES purchase_orders(po_id)) PARTITION BY REFERENCE(po_items_fk); What are the two consequences of the above statements?()
APartitions of PURCHASE_ORDER_ITEMS have system-generated names.
BBoth PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
CPartitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
DThe PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
EPartition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
相关问题推荐
-
抗惊厥首选的药物是()
A、苯巴比妥钠
B、苯妥英钠
C、地西泮
D、水合氯醛
E、复方氯丙嗪
-
在powerpoint2010插入图表,选择图表对象时,可以使用鼠标或键盘两种方法。
A、对
B、错
-
Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?()
A、SELECT last_name, 12*salary* commission_pct FROM emp;
B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
-
在PowerPoint2010中,幻灯片的放映类型有()。
A、演讲者放映
B、观众自行浏览
C、在展台浏览
D、循环放映
-
PowerPoint2010可以直接打开PowerPoint2010制作的演示文稿。
A、对
B、错