Evaluate the following statements:CREATE TABLE purchase_orders -(pojd NUMBER(4),po_date TIMESTAMP,supplie_id NUMBER(6),p

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Evaluate the following statements:CREATE TABLE purchase_orders -(pojd NUMBER(4),po_date TIMESTAMP,supplie_id NUMBER(6),p

Post by answerhappygod »

Evaluate the following statements:CREATE TABLE purchase_orders -(pojd NUMBER(4),po_date TIMESTAMP,supplie_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? (Choose two.)

A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
B. Both PURCHASEjDRDERS and PURCHASEJDRDERJTEMS tables are created with four partitions each.
C. Partitions of the PURCHASEJDRDERJTEMS table exist in the same tablespaces as the partitions of the PURCHASEJDRDERS table.
D. The PURCHASEJDRDERJTEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns. E. Partition maintenance operations performed on the PURCHASEJDRDERJTEMS table are automatically reflected in the PURCHASEjDRDERS table.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply