1Z0-006 Database Administration & Security 4

Question 1

Which Oracle background process performs instance recovery automatically when the database is restarted after a crash?

Accepted Answer

SMON

Answer

SMON (System Monitor) performs instance recovery at startup by applying redo logs and cleaning up temporary segments.

Question 2

What is the purpose of Oracle's FLASHBACK DATABASE feature?

Accepted Answer

To rewind the entire database to a previous point in time

Answer

Flashback Database allows DBAs to rewind the entire database to a past SCN or timestamp without restoring from backup.

Question 3

Which privilege is required to query data from another user's table in Oracle without any additional grants?

Accepted Answer

SELECT ANY TABLE system privilege

Answer

The SELECT ANY TABLE system privilege allows a user to query any table in the database without needing an explicit object grant from the owner.

Question 4

What does enabling ARCHIVELOG mode in Oracle allow you to do?

Accepted Answer

Perform online backups and recover the database to any point in time

Answer

ARCHIVELOG mode archives filled redo log files, enabling online backups and point-in-time recovery of the database.

Question 5

Which Oracle view would a DBA query to see currently locked objects in the database?

Accepted Answer

V$LOCKED_OBJECT

Answer

V$LOCKED_OBJECT provides information about all objects currently locked by transactions in the database.

(1Z0-006) Oracle Database Foundations Associate Practice Test