Online Access Free 1z1-062 Exam Questions

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

• A.The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.
• B.The job is terminated and the gathered statistics are not saved.
• C.The job is terminated but the gathered statistics are not published.
• D.The job continues to run until all statistics are gathered.

Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose three.)

• A.CPU
• B.Maximum Undo per consumer group
• C.Maximum Idle time
• D.Parallel server limit
• E.Exadata I/O
• F.Local file system I/O

Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup.
Which two statements are true in this scenario? (Choose two.)

• A.The user-managed backup consists of only formatted data blocks.
• B.The database must be shut down to take a user-managed backup.
• C.The database must be in MOUNT state to take RMAN backup.
• D.The RMAN backup contains only data files.
• E.The RMAN backup can be performed while the database is open.

Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

• A.It calls SQL advisors automatically if required.
• B.It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.
• C.It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.
• D.It provides recommendations only for poorly performing SQL statements.
• E.Its results are stored in AWR.

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command? (Choose two.)

• A.It fails because no SQL *Loader control file location is specified.
• B.It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
• C.It fails because no SQL *Loader data file location is specified.
• D.It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.