1z0-063 Exam Question 26

You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2. Rebuild indexes on the SALES table after completion of the bulk load.
How would you create these jobs?
  • 1z0-063 Exam Question 27

    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?
  • 1z0-063 Exam Question 28

    You use RMAN to take regular backups for your database.
    Examine the RMAN commands:
    RMAN> CROSSCHECK BACKUP;
    RMAN>DELETE EXPITED BACKUP;
    Which statement is true?
  • 1z0-063 Exam Question 29

    Your multitenant container database (CDB) CDB1that is running in ARCHIVELOGmode contains two
    pluggable databases (PDBs), PDB2_1and PDB2_2, both of which are open. RMAN is connected to the
    target pluggable database PDB2_1.
    RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
    Which statement is true about the execution of this command to back up the database?
  • 1z0-063 Exam Question 30

    Your database has a table CUSTOMERSthat contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.
    Examine the commands executed and their output:

    Why is it that only one update is listed by the Flashback Version Query?