1Z0-006 Database Administration & Security 3 — Questions and Answers
Question 1: What is the default tablespace for a new Oracle user if none is specified at creation?
- TEMP
- USERS
- SYSTEM (Correct answer)
- SYSAUX
Correct answer: SYSTEM
If no default tablespace is specified when creating a user, Oracle assigns the SYSTEM tablespace as the default, which is generally undesirable.
Question 2: Which type of Oracle backup captures only the data blocks changed since the last backup?
- Full backup
- Incremental backup (Correct answer)
- Logical backup
- Cold backup
Correct answer: Incremental backup
An incremental backup copies only the data blocks that have changed since the previous backup, reducing backup time and storage.
Question 3: What is the role of the Oracle Listener process?
- Writes redo log entries to disk
- Accepts incoming client connection requests to the database (Correct answer)
- Manages memory allocation for sessions
- Performs automatic backup operations
Correct answer: Accepts incoming client connection requests to the database
The Oracle Listener is a network process that listens on a port and routes incoming client connection requests to the appropriate database instance.
Question 4: Which Oracle feature allows you to limit the amount of disk space a user can consume in a tablespace?
- Resource plans
- Quotas (Correct answer)
- Profiles
- Space limits
Correct answer: Quotas
Tablespace quotas restrict how much space a user's objects can consume within a specific tablespace.
Question 5: What does the Oracle REVOKE statement do?
- Creates a new privilege
- Removes a previously granted privilege from a user or role (Correct answer)
- Disables a user account temporarily
- Transfers privileges between users
Correct answer: Removes a previously granted privilege from a user or role
REVOKE removes system or object privileges that were previously granted to a user, role, or PUBLIC.
Question 6: Which initialization parameter controls the maximum number of user sessions that can connect to an Oracle instance simultaneously?
- MAX_USERS
- SESSIONS (Correct answer)
- MAX_CONNECTIONS
- DB_CONNECTIONS
Correct answer: SESSIONS
The SESSIONS initialization parameter sets the maximum number of concurrent sessions allowed in an Oracle instance.
Question 7: In Oracle, what is a 'profile' used for?
- Defining a user's color theme in OEM
- Enforcing password and resource usage policies on user accounts (Correct answer)
- Storing user preferences for SQL Developer
- Configuring network connectivity settings
Correct answer: Enforcing password and resource usage policies on user accounts
A profile is a named set of password and resource limit parameters that can be assigned to user accounts to enforce security and usage policies.
1Z0-006 Database Administration & Security 3
What is the default tablespace for a new Oracle user if none is specified at creation?