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?
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?
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?
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?
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?
Examine the commands executed and their output:

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