Which two are true about the SQL Tuning Advisor?

• A.It prevents performance regressions for SQL statements when changes are made.
• B.It can recommend semantic changes to SQL statements.
• C.It considers all SQL statements being analyzed by the advisor task as a group.
• D.It only recommends syntactic changes to SQL statements.
• E.It checks each query being analyzed for missing or stale statistics.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?

• A.By default, AWR snapshots are automatically purged after eight days.
• B.By default, MMON creates an AWR snapshot every 30 minutes.
• C.ADDM can recommend shrinking the buffer cache.
• D.AWR snapshots must be deleted when no longer required by ADDM.
• E.ADDM performs its analysis only when a DBA requests it.
• F.ADDM can recommend extending the buffer cache.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about common objects? (Choose two.)

• A.They can exist in CDB$ROOT and an application root.
• B.They can exist in user-defined schemas only in application containers.
• C.They can be only metadata-linked in an application container.
• D.They can be created only in an application root.
• E.They can be extended data-linked in CDB$ROOT.
• F.They can be created only in CDB$ROOT.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1 is a container database.
2. COMMON_USER_PREFIX is set to an empty string.
3. PDB1 is a pluggable database in CDB1.
4. APP1_ROOT is an application container in CDB1.
5. APP1_PDB1 is an application PDB in APP1_ROOT.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> CREATE ROLE role1 CONTAINER=CURRENT;
What is true?

• A.It will return an error because creation of a local role is not allowed in CDB$ROOT.
• B.ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
• C.ROLE1 will be created only in CDB$ROOT and APP1_ROOT.
• D.ROLE1 will be created only in CDB$ROOT.
• E.It will return an error because common roles must start with C##.

Comment: *

Name: *

Email: *

Verification: *

Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command: RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE; What is a prerequisite for the successful execution of this command

• A.The target database must be in MOUNT state.
• B.RMAN must be connected to the target database instance and the auxiliary instance.
• C.A most recent backup set of the PROD database must exist.
• D.Flashback must be enabled for the PROD database.

Comment: *

Name: *

Email: *

Verification: *