OCM OCM Database Administration & SQL 2

Question 1

Which Oracle tool is used to analyze and report on the contents of redo log files for auditing and recovery purposes?

Accepted Answer

LogMiner

Answer

RMAN

Answer

AWR

Answer

Data Pump

Question 2

What is a Materialized View Log used for in Oracle?

Accepted Answer

Supporting fast refresh of materialized views

Answer

Auditing DML on the base table

Answer

Capturing DDL changes for replication

Answer

Storing execution plans for complex views

Question 3

In Oracle Database, which isolation level prevents dirty reads and non-repeatable reads but still allows phantom reads by default?

Accepted Answer

Read Committed

Answer

Read Uncommitted

Answer

Repeatable Read

Answer

Serializable

Question 4

Which Oracle feature automatically reclaims unused space from high-water mark in a segment?

Accepted Answer

Segment Advisor with Shrink

Answer

Automatic Segment Space Management (ASSM)

Answer

DBMS_SPACE.FREE_BLOCKS

Answer

Locally Managed Tablespaces

Question 5

What does the V$SQL view primarily contain in Oracle?

Accepted Answer

Cursor statistics and SQL text for statements in the shared pool

Answer

Session wait events

Answer

Historical AWR snapshots

Answer

Active transaction undo information

Question 6

Which privilege is required to execute the DBMS_STATS.GATHER_DATABASE_STATS procedure?

Accepted Answer

DBA role

Answer

SYSDBA

Answer

ANALYZE ANY

Answer

ANALYZE ANY and SELECT ANY TABLE