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

LogMiner (DBMS_LOGMNR) reads online and archived redo logs to provide a SQL-based view of all database changes for auditing and point-in-time recovery analysis.

Question 2

What is a Materialized View Log used for in Oracle?

Accepted Answer

Supporting fast refresh of materialized views

Answer

A Materialized View Log records row-level changes on the master table so that an associated materialized view can be refreshed incrementally (fast refresh) rather than fully rebuilt.

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

Oracle's default Read Committed isolation prevents dirty reads by only seeing committed data, but a new query within the same transaction can see newly committed rows (phantoms).

Question 4

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

Accepted Answer

Segment Advisor with Shrink

Answer

The Segment Advisor with the ALTER TABLE … SHRINK SPACE command reclaims free space below the high-water mark by compacting rows and resetting the HWM.

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

V$SQL stores execution statistics, execution plans (via V$SQL_PLAN), and the SQL text for each parsed cursor currently in the shared pool.

OCM - Oracle Certified Master Practice Test

OCM - Oracle Certified Master Practice Test

OCM OCM Database Administration & SQL 2