1Z0-006 Database Administration and Security 3 — Questions and Answers
Question 1: Which Oracle feature allows you to limit the amount of CPU and I/O resources a user or group can consume?
- Database Resource Manager (Correct answer)
- Automatic Workload Repository
- Oracle Scheduler
- Automatic Memory Management
Correct answer: Database Resource Manager
Oracle Database Resource Manager allows DBAs to define resource plans that control CPU, I/O, and session limits for different user groups.
Question 2: What is the function of Oracle's AUDIT statement?
- It compresses database objects to save space
- It tracks and records user actions and database events for security monitoring (Correct answer)
- It rebuilds indexes to improve query performance
- It validates the integrity of database backups
Correct answer: It tracks and records user actions and database events for security monitoring
The AUDIT statement in Oracle enables tracking of specified user actions, SQL statements, or system events and writes records to the audit trail.
Question 3: In Oracle, what does the REVOKE statement do?
- Grants additional privileges to a user
- Removes previously granted privileges from a user or role (Correct answer)
- Creates a new role with specified permissions
- Temporarily suspends a user account
Correct answer: Removes previously granted privileges from a user or role
REVOKE removes specific privileges or roles that were previously granted to a user or another role.
Question 4: Which tablespace type is used to store temporary data such as sort operations?
- SYSTEM tablespace
- SYSAUX tablespace
- TEMP tablespace (Correct answer)
- UNDO tablespace
Correct answer: TEMP tablespace
The TEMP (temporary) tablespace stores temporary data used during sort, hash join, and other operations that require disk space beyond available memory.
Question 5: What is the minimum number of redo log file groups required for an Oracle database to function?
- 1
- 2 (Correct answer)
- 3
- 4
Correct answer: 2
Oracle requires at least 2 redo log groups so that while one group is being archived or checkpointed, the other can be written to.
Question 6: Which Oracle background process writes dirty buffers from the buffer cache to data files?
- LGWR (Log Writer)
- DBWR (Database Writer) (Correct answer)
- SMON (System Monitor)
- PMON (Process Monitor)
Correct answer: DBWR (Database Writer)
DBWR (Database Writer) is responsible for writing modified (dirty) data blocks from the buffer cache to the corresponding data files on disk.
Question 7: What does the Oracle FLASHBACK TABLE feature enable?
- Restoring a table to a previous point in time without restoring the entire database (Correct answer)
- Creating a read-only snapshot of a table for reporting
- Encrypting a table's data at rest
- Compressing a table to reduce storage usage
Correct answer: Restoring a table to a previous point in time without restoring the entire database
FLASHBACK TABLE allows you to restore a table to a prior point in time by leveraging undo data, without requiring a full database restore.
1Z0-006 Database Administration and Security 3
Which Oracle feature allows you to limit the amount of CPU and I/O resources a user or group can consume?