<rt id="2skke"></rt>

<input id="2skke"></input>

<code id="2skke"></code>

單項(xiàng)選擇題

You discover that your Recycle Bin contains two tables with the same name， MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement：
FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2；
What will be the result of executing this statement？（）

A. One of the tables is recovered from the Recycle Bin using a First In First Out （FIFO） approach.
B. One of the tables is recovered from the Recycle Bin using a Last In First Out （LIFO） approach.
C. Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
D. None of the tables are recovered from the Recycle Bin， and the statement returns an error.

你可能感興趣的試題

單項(xiàng)選擇題

Following is the list of locations in random order where oranfstab can be placed.
1./etc/mtab
2.$ORACLE_HOME/dbs/oranfstab
3./etc/oranfstab
What is the sequence in which Direct NFS will search the locations？（）

A. 1，2，3
B. 3，2，1
C. 2，3，1
D. 1，3，2

單項(xiàng)選擇題

Evaluate the following function code：
CREATE FUNCTION get_dept_avg（dept_id NUMBER） RETURN NUMBER RESULT_CACHE RELIES_ON （EMPLOYEES） IS avgsal NUMBER（6）； BEGIN
SELECT AVG（SALARY）INTO avgsal FROM EMPLOYEES
WHERE DEPARTMENT_ID = dept_id； RETURN avgsal； END get_dept_avg；
Which statement is true regarding the above function？（）

A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
B. If the function execution results in an unhandled exception，the exception result is also stored in the cache.
C. Each time the function is invoked in a different session，the current result in the result cache gets overwritten.
D. If the function is invoked with a different parameter value，the existing result in the result cache gets overwritten by the latest value.

你可能感興趣的試題

Following is the list of locations in random order where oranfstab can be placed. 1./etc/mtab 2.$ORACLE_HOME/dbs/oranfstab 3./etc/oranfstab What is the sequence in which Direct NFS will search the locations？（）

Following is the list of locations in random order where oranfstab can be placed.
1./etc/mtab
2.$ORACLE_HOME/dbs/oranfstab
3./etc/oranfstab
What is the sequence in which Direct NFS will search the locations？（）