Database Administration & Security Flashcards

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

Answer: SMON

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

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

Answer: To rewind the entire database to a previous point in time

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

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

Answer: SELECT ANY TABLE system privilege

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.

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

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

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

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

Answer: V$LOCKED_OBJECT

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

What is the function of the Oracle CHECKPOINT process (CKPT)?

Answer: Updates file headers and triggers DBWR to write dirty buffers

CKPT updates the control file and data file headers with checkpoint information and signals DBWR to write dirty blocks to disk.

A user has been granted the INSERT privilege on a table WITH GRANT OPTION. What does this allow the user to do?

Answer: Grant the INSERT privilege on that table to other users

WITH GRANT OPTION allows the recipient of a privilege to pass that same privilege on to other users.