← Back to exam page

1z0-063 – Oracle Database 12c: Advanced Administration

Loading demo links...

Showing 1–3 of 15 questions

Question 1

Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    RMAN preauthorization on the host
  • ○

    OSB encryption for data in transport and on tape
  • ○

    matching the OS user identity of the Oracle instance associated with the database username
  • ○

    assigned to a class with rights to back up or restore Oracle database
  • ○

    scheduling of the RMAN backup to occur automatically at user-defined intervals
  • ○

    assigned to a class with rights to browse all directories and catalogs
Question 2

Which two statements are true regarding Oracle Data Pump? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    EXPDP and IMPDP are the client components of Oracle Data Pump.
  • ○

    DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
  • ○

    Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
  • ○

    Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
  • ○

    EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
Question 3

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:

S>sqlldrhr/hr@pdb table=employees

Which two statements are true about the command? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    It succeeds with default settings if the employees table exists in the hr schema.
  • ○

    It fails because no SQL*Loader data file location is specified.
  • ○

    It fails if the hr user does not have the create any directory privilege.
  • ○

    It fails because no SQL*Loader control file location is specified.
  • ○

    It succeeds and creates the employees table in the HR schema.