Question 256
Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file? (Choose three.)

Which three statements are true regarding the SQL* Loader operation performed using the control file? (Choose three.)
Question 257
The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADEoption that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column.
A transaction deletes a primary key in the DEPARTMENTStable, which has child rows in the EMPLOYEEStable.
Which statement is true?
A transaction deletes a primary key in the DEPARTMENTStable, which has child rows in the EMPLOYEEStable.
Which statement is true?
Question 258
You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario? (Choose two.)
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario? (Choose two.)
Question 259
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?
Question 260
Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)