Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose three.)

• A.Reduced logical I/O
• B.Reduced virtual memory utilization
• C.Improved parallel Execution performance
• D.Improved Serial Execution performance
• E.Reduced physical I/O
• F.Reduced CPU utilization

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

• A.The ADDM calls other advisors if required, but does not provide recommendations about the advisors
• B.The ADDM runs after each AWR snapshot is collected automatically by MMON
• C.The ADDM analysis provides only diagnostics information but does not provide recommendations
• D.The ADDM requires at least four AWR snapshots for analysis
• E.The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)

Comment: *

Name: *

Email: *

Verification: *

Examine the parameters for a database instance:

Your database has three undo tablespaces and the default undo tablespace is not autoextensible.
Resumable space allocation is not enabled for any sessions in the database instance.
What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

• A.Transactions write their undo in the SYSTEM undo segment.
• B.Transactions fail.
• C.Transactions wait until space becomes available in UNDOTBS1.
• D.Transactions write their undo in a temporary tablespace.

Comment: *

Name: *

Email: *

Verification: *

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.
Which two files are removed automatically if space is required in the FRA as per the retention policy?
(Choose two.)

• A.flashback logs
• B.Archived redo log files that have multiple copies in a different archive location
• C.user-managed backups of data files and control files
• D.RMAN backups that are obsolete

Comment: *

Name: *

Email: *

Verification: *

You install Oracle Grid Infrastructure standalone server and issue the following command:
crsctl start has
Which two existing components get automatically added to the Oracle Restart configuration? (Choose two.)

• A.the database whose instance is running
• B.Oracle Healthcheck services
• C.Oracle CSSD services
• D.Oracle Notification services
• E.Oracle Net Listener

Comment: *

Name: *

Email: *

Verification: *