Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

• A.By default, the transported database will use Oracle Managed Files (OMF)
• B.Data files can be converted on the destination system.
• C.Data files can be converted on the source system.
• D.A new DBID is automatically created for the transported database.
• E.Databases can be transported between systems with different endian formats.
• F.The password file is automatically converted by RMAN.

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands: SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICY sales_pol; Which statement is true about SALES_POL?

• A.Audit records are always stored in an external audit file.
• B.It is only enabled for user SH.
• C.Only successful queries of SH.SALES are written to the audit trail.
• D.It is enabled for all users having SELECT privilege on SH.SALES.

Comment: *

Name: *

Email: *

Verification: *

Examine this output:

Which two are true? (Choose two.)

• A.Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
• B.PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
• C.PDB1 is always limited to 40% of the available system resources regardless of demand.
• D.PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
• E.PDB3 can use all available parallel execution processes at times.
• F.Any PDB not specified in the plan will be unable to execute statements in parallel.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Database Configuration Assistant (DBCA) templates?

• A.New templates can only be created by modifying an existing user-created template.
• B.The Data Warehouse template is most suitable when transaction response time is the key criterion.
• C.Oracle DBCA templates can store only logical structure and not database files.
• D.Oracle DBCA templates can be used to create new databases and duplicate existing databases.
• E.The General Purpose or Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *