多项选择题
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.
相关考题
-
单项选择题
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?()
A. The database will open, and the tablespace automatically comes out of the backup mode
B. The database will be mounted, and recovery must be performed on the USERS tablespace.
C. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
D. The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery. -
单项选择题
View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you recommend?()
A. 90 MB
B. 272 MB
C. 362 MB
D. 1,440 MB -
单项选择题
You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?()
A. Set metric threshold
B. Implement Database Resource Manager
C. Enable resumable timeout for user sessions
D. Add directives to Automatic Database Diagnostic Monitor (ADDM)
