Which two statements are true about variable extent size support for large ASM files?

• A.The metadata used to track extents in SGA is reduced.
• B.Rebalance operations are completed faster than with a fixed extent size
• C.An ASM Instance automatically allocates an appropriate extent size.
• D.Resync operations are completed faster when a disk comes online after being taken offline.
• E.Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

Comment: *

Name: *

Email: *

Verification: *

An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?

• A.Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
• B.Increase the database buffer cache size.
• C.Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
• D.Configure Automata Shared Memory Management.
• E.Configure Automatic Memory Management-

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about adaptive SQL plan management? (Choose three.)

• A.It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
• B.The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
• C.It adds new, better plans automatically as fixed plans to the baseline.
• D.The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
• E.The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

Comment: *

Name: *

Email: *

Verification: *

Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

• A.Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
• B.Run the Automatic Workload Repository (AWR) report.
• C.Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
• D.Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
• E.Run the Automatic Database Diagnostic Monitor (ADDM).

Comment: *

Name: *

Email: *

Verification: *

Which three activities are supported by the Data Recovery Advisor? (Choose three.)

• A.Advising on block checksum failures
• B.Advising on inaccessible control files
• C.Advising on inaccessible block change tracking files
• D.Advising on empty password files
• E.Advising on invalid block header field values

Comment: *

Name: *

Email: *

Verification: *