【单选题】You have two tables with referential integrity enforced between them. You need to insert data to the child tablefirst because it is going to be a long transaction and data for the parent table will be...
A.
Set the constraint to deferred before starting the transaction.
B.
Alter the constraint to NOVALIDATE state before starting the transaction.
C.
Enable the resumable mode for the session before starting the transaction.
D.
Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction
【单选题】You have two switches connected together with two crossover cables for redundancy, and STP is disabled. Which of the following will happen between the switches?
A.
The routing tables on the switches will not update.
B.
The MAC forward/filter table will not update on the switch.
C.
Broadcast storms will occur on the switched network.
D.
The switches will automatically load-balance between the two links.
【单选题】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 ...
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.