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.)
  • 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?
  • 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.)
  • 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.)