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

• A.by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
• B.by running ADDM in diagnostic mode
• C.by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
• D.by using Active Session History (ASH) data and performing hang analysis

Comment: *

Name: *

Email: *

Verification: *

Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

• A.general operating system health
• B.SQL statements
• C.database instance memory management and sizes
• D.log writer performance
• E.database writer performance

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases?

• A.It can be used for both Oracle Database and Oracle Grid Infrastructure installation.
• B.It uses a single RPM that automatically extracts and installs the Oracle Database software.
• C.It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.
• D.It does not require the setup wizard.
• E.It can only install and configure Oracle Database software. The database has to be created separately.

Comment: *

Name: *

Email: *

Verification: *

Examine the command for creating pluggable database PDB2 in container database CDB2. Select three options, any one of which is required for it to execute successfully. (Choose three.)

• A.Enable only OMF.
• B.Set only the PDB_FILE_NAME_CONVERT parameter.
• C.Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
• D.Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
• E.Add only the CREATE_FILE_DEST clause to the statement.
• F.Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

Comment: *

Name: *

Email: *

Verification: *

Your SALES_ROOTapplication container has two application PDBs.
The SALES_APPapplication has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true? (Choose two.)

• A.The MAPTABLE table is a metadata-linked table.
• B.The REVENUEtable must be a list-partitioned table.
• C.The REVENUEtable partitions are not pruned across the PDBs automatically.
• D.The CONTAINERSclause cannot be used in queries on the REVENUEtable.
• E.The MAPTABLEtables defines a logical partition key on a commonly used column for the REVENUEtable.
• F.A container map exists for the REVENUEtable, but is not enabled.

Comment: *

Name: *

Email: *

Verification: *