Which setting enables the baselines by default in Oracle Database 11g?
A. setting the STATISTICS_LEVEL parameter to TYPICAL
B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)
C. enabling Automated Maintenance Task using Oracle Enterprise Manager
D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
Evaluate the following command and its output:
SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE ————— ————— ————– ————- LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)
A. FREE_SPACE indicates only the space that is currently unallocated.
B. ALLOCATED_SPACE indicates only the space currently allocated and in use.
C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.
E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario? (Choose all that apply.)
A. The disk automatically goes offline.
B. The disk is immediately dropped from the disk group.
C. The ASM tracks the extents that are modified during the outage.
D. The ASM migrates the extents from the unavailable disk to the remaining disks.
What can you achieve by implementing reverse key index?
A. Remove repeated key values from the index to fit more index entries in a given amount of disk space
B. Prevent contention on the highest leaf block when using sequences to generate keys
C. Reverse the bytes of each column indexed including the row ID
D. Store a bitmap for each key value instead of a list of row IDs in the leaf node