Oracle Database 12c: Installation and Administration : 1z0-062

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?

• A. Alt existing PDBs must be closed.
• B. The CDB must be open.
• C. The CDB must be in the nomount stage.
• D. The CDB must be in the mount stage.

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:
$ crsctl config has
CRS-4622: Oracle High Availability Services auto start is enabled.
What does this imply?

• A. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
• B. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
• C. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
• D. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.

One of your databases supports an OLTP workload.
The default UNDO tablespace is fixed size with:
1. RETENTION NOGUARANTEE
2. UNDO_RETENTION is 12 minutes
User SCOTT gets this error after a query on the SALES table has run for more than 15 minutes:
ORA-01555: snapshot too old
Which three factors taken separately or in some combination might be the cause? (Choose three.)

• A. A committed update to the SALES table was made more than 12 minutes before the query began
• B. An uncommitted update to the SALES table was made more than 12 minutes before the query began
• C. An update was made to the SALES table after the query began
• D. An update was made to the SALES table before the query began
• E. A committed delete to the SALES table was made more than 12 minutes before the query began
• F. An uncommitted delete to the SALES table was made more than 12 minutes before the query began
• G. An update to the SALES table was committed after the query began

Examine these statements:

Which three are true about the effects of executing these statements? (Choose three.)

• A. The password complexity will not enforce on the HR account.
• B. User HR is permitted to create more than three concurrent sessions.
• C. Password complexity checking is enforced for user HR.
• D. The HR account will be locked after three consecutive failed login attempts.
• E. User HR sessions will terminate after ten minutes of continuous inactivity.
• F. The HR account will get locked by Oracle after ten consecutive failed login attempts.

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

• A. The database must be opened with the RESETLOGS option after the flashback is complete.
• B. The database must have multiplexed redo logs for the flashback to succeed.
• C. The database must be opened in restricted mode for the flashback to succeed.
• D. The database must be MOUNTED for the flashback to succeed.
• E. The database must use block change tracking for the flashback to succeed.
• F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.