Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
1. Mount the CDB.
2. Close all the PDBs.
3. Open the database.
4. Apply the archive redo logs.
5. Restore the data file.
6. Take the SYSAUX tablespace offline.
7. Place the SYSAUX tablespace online.
8. Open all the PDBs with RESETLOGS.
9. Open the database with RESETLOGS.
10. Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?

• A.6, 5, 4, 7
• B.10, 1, 2, 5, 8
• C.10, 1, 2, 5, 4, 9, 8
• D.10, 1, 5, 8, 10

Comment: *

Name: *

Email: *

Verification: *

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.The CDB must be open.
• B.The CDB must be in the mount stage.
• C.The CDB must be in the nomount stage.
• D.Alt existing PDBs must be closed.

Comment: *

Name: *

Email: *

Verification: *

Your database is configured in ARCHIVELOG mode.
Examine the RMAN configuration parameters:

Examine the command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
What is the outcome?

• A.It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command.
• B.It executes successfully and creates a backup set of the database along with archived log files and then deletes the
  original archived log files.
• C.It executed successfully and creates a copy of the database along with archive log files and then deletes the original
  archived log files.
• D.It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command.

Comment: *

Name: *

Email: *

Verification: *

Examine the parameter settings in your local ORCL database:

Examine the parameter settings for the remote SALES database:

As the SYS user, you issue the following command on ORCL:
CREATE PUBLIC DATABASE LINK sales.us.example.com USING 'sales1';
The sales1 tnsnames entry points to the sales database instance.
Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.)

• A.The GLOBAL_NAMES initialization parameter should be set to FALSE in the ORCL database.
• B.The REMOTE_OS_AUTHENT initialization parameter should be set to FALSE in the remote database.
• C.The SALES1 net service name should be known to both the local and remote databases.
• D.Only the user creating the database link must have an account and the required privileges in the remote database.
• E.Local database users who use this database link should have accounts and the required privileges in the remote database.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Oracle Restart?

• A.It can be configured to automatically restart a database in case of normal shutdown of the database instance.
• B.While starting any components, it automatically attempts to start all dependencies first and in proper order.
• C.It runs periodic check operations to monitor the health of Oracle components.
• D.It can be configured toautomatically attempt to restart various components after a hardware or software failure.
• E.It can be used to only start Oracle components.

Comment: *

Name: *

Email: *

Verification: *