You want to insert rows into the ORDERS_HISTORY table from the ORDERS table on the last working day of every month. To accomplish this task, you execute the following command:

INSERT /* +APPEND */ INTO orders_history SELECT * FROM orders; Which blocks of the ORDERS_HISTORY table segment would be used to accommodate the data from the ORDER table?

Question

You want to insert rows into the ORDERS_HISTORY table from the ORDERS table on the last working day of every month. To accomplish this task, you execute the following command:

INSERT /* +APPEND */ INTO orders_history SELECT * FROM orders; Which blocks of the ORDERS_HISTORY table segment would be used to accommodate the data from the ORDER table?

Accepted Answer

B. only the blocks that are above the high water mark

Answer

A. only the block that is below the high water mark

Answer

C. only the blocks where PCTFREE is never used

Answer

D. any blocks that are listed in the free list of the segment

Answer

E. only the blocks where the used space is less than PCTUSED

You want to insert rows into the ORDERS_HISTORY table from the ORDERS table on the last working day of every month. To accomplish this task, you execute the following command: INSERT / +APPEND /…

Question

Options

How the community answered

Community Discussion