1Z0-006 Database Administration and Security 2 — Questions and Answers
Question 1: Which Oracle tool is used to create and manage a database interactively with a graphical interface?
- SQL*Plus
- Database Configuration Assistant (DBCA) (Correct answer)
- Recovery Manager (RMAN)
- Data Pump
Correct answer: Database Configuration Assistant (DBCA)
DBCA (Database Configuration Assistant) provides a GUI for creating, configuring, and deleting Oracle databases.
Question 2: What does the Oracle Data Dictionary store?
- Application source code and compiled PL/SQL units
- Metadata about database objects, users, and privileges (Correct answer)
- Raw table data in compressed format
- Undo segments for transaction rollback
Correct answer: Metadata about database objects, users, and privileges
The Oracle Data Dictionary stores metadata such as definitions of tables, views, indexes, users, and privileges.
Question 3: Which privilege allows a user to connect to an Oracle database?
- RESOURCE
- DBA
- CREATE SESSION (Correct answer)
- CONNECT ROLE
Correct answer: CREATE SESSION
The CREATE SESSION system privilege is required for a user to establish a connection to the Oracle database.
Question 4: What is the purpose of the Oracle Listener process?
- It manages memory allocation for the SGA
- It handles incoming client network connection requests (Correct answer)
- It writes redo log entries to disk
- It performs automatic statistics gathering
Correct answer: It handles incoming client network connection requests
The Oracle Listener is a network process that listens for incoming client connection requests and hands them off to the database server.
Question 5: Which view would a DBA query to see all current active sessions in an Oracle database?
- DBA_SESSIONS
- V$SESSION (Correct answer)
- ALL_SESSIONS
- USER_SESSIONS
Correct answer: V$SESSION
V$SESSION is a dynamic performance view that shows information about all current sessions connected to the Oracle database.
Question 6: What happens to uncommitted transactions when an Oracle database instance crashes?
- They are permanently lost
- They are automatically committed upon restart
- They are rolled back during instance recovery using undo data (Correct answer)
- They are stored in a temporary tablespace until the DBA reviews them
Correct answer: They are rolled back during instance recovery using undo data
During instance recovery, Oracle uses undo data to roll back any uncommitted transactions that were in progress at the time of the crash.
Question 7: Which statement best describes a database schema in Oracle?
- A physical storage location on disk for database files
- A collection of database objects owned by a specific user (Correct answer)
- A backup copy of the entire database
- A set of configuration parameters for the instance
Correct answer: A collection of database objects owned by a specific user
In Oracle, a schema is a logical collection of database objects (tables, views, sequences, etc.) owned by a particular database user.
1Z0-006 Database Administration and Security 2
Which Oracle tool is used to create and manage a database interactively with a graphical interface?