You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?

• A.Use emergency monitoring to fetch data directly from SGA for analysis.
• B.Enable Memory Access Mode, which reads performance data from SGA.
• C.Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D.Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
• E.Run ADDM in diagnostic mode.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about an application seed pluggable database (PDB)?

• A.It Is automatically synchronized with its application root PDB when an application is upgraded.
• B.It cannot be added to an application container after the application container has already been created.
• C.A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
• D.A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.
• E.It cannot be dropped from its application container.
• F.It is automatically synchronized with its application root PDB when an application is installed.
• G.It is not required in an application container.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2.ORCL uses disk group +FRA for the Fast Recovery Area.
3.LISTENER is the listener for ORCL.
4.The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5.All components are currently shut down.
You execute this command:

What is the outcome?

• A.Only the ORCL database instance and the +DATA and +FRA disk groups are started.
• B.Only the ORCL database and the ASM instances are started.
• C.Only the ORCL database instance is started.
• D.The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.
• E.Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

Comment: *

Name: *

Email: *

Verification: *

RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database: RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE; Which two statements are true about the execution of the duplicate command?

• A.The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.
• B.he duplicate command.
• C.All archive redo log files are automatically copied to the duplicate database.
• D.The duplicate database is created without using RMAN backups and prod1 is allowed to remain open during duplication.
• E.The duplicate database has the same directory structure as the source database.
• F.The duplicate database is created by using the backups created during the execution of

Comment: *

Name: *

Email: *

Verification: *