1Z0-006 Database Administration & Security 4 — Questions and Answers
Question 1: Which Oracle background process performs instance recovery automatically when the database is restarted after a crash?
- PMON
- SMON (Correct answer)
- CKPT
- DBWR
Correct answer: SMON
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?
- To take an instant snapshot of current database performance
- To rewind the entire database to a previous point in time (Correct answer)
- To quickly export a subset of table data
- To recover a dropped table from the recycle bin
Correct 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.
Question 3: Which privilege is required to query data from another user's table in Oracle without any additional grants?
- SELECT ANY TABLE system privilege (Correct answer)
- CREATE TABLE
- PUBLIC SELECT
- DBA role only
Correct 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.
Question 4: What does enabling ARCHIVELOG mode in Oracle allow you to do?
- Automatically compress all table data
- Perform online backups and recover the database to any point in time (Correct answer)
- Encrypt all redo log entries
- Replicate data to a standby database automatically
Correct 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.
Question 5: Which Oracle view would a DBA query to see currently locked objects in the database?
- V$SESSION
- V$LOCK
- DBA_LOCKS
- V$LOCKED_OBJECT (Correct answer)
Correct answer: V$LOCKED_OBJECT
V$LOCKED_OBJECT provides information about all objects currently locked by transactions in the database.
Question 6: What is the function of the Oracle CHECKPOINT process (CKPT)?
- Flushes the shared pool to free memory
- Updates file headers and triggers DBWR to write dirty buffers (Correct answer)
- Reads data blocks into the buffer cache
- Monitors and terminates failed user processes
Correct 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.
Question 7: A user has been granted the INSERT privilege on a table WITH GRANT OPTION. What does this allow the user to do?
- Insert rows and modify the table structure
- Grant the INSERT privilege on that table to other users (Correct answer)
- Insert into all tables in the schema
- Create new tables with the same structure
Correct 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.
1Z0-006 Database Administration & Security 4
Which Oracle background process performs instance recovery automatically when the database is restarted after a crash?