可学答题网 > 问答 > 1Z0-053题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Evaluate the following&ensp


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?()

  • A Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
  • B Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each. 
  • C Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
  • D The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
  • E Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
参考答案
参考解析:
分类:1Z0-053题库
相关推荐

1、Evaluate the following&ensp

Evaluate the following statement:  Which statement is true regarding the evaluation of rows re...

2、Examine the following 

Examine the following command:  ALTER DISKGROUP data MOUNT FORCE;  In which scenario can&ensp...

3、Evaluate the following&ensp

Evaluate the following SQL statements that are issued in the given order:What would be the&ens...

4、Evaluate the following&ensp

Evaluate the following block of code:  BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl => ’mycompan...

5、Evaluate the following&ensp

Evaluate the following function code:  CREATE FUNCTION get_dept_avg(dept_id NUMBER) RETURN NUMBER RESU...

6、The following are the&

The following are the details of your database:Instance name:test Host name : tech1.us.oracle.com&ensp...