D330 - Data Systems Administration
1. Which parameter can an administrator enable with- C. SGA_TARGET
out restarting a database?
A. COMPATIBLE
B. DB_DOMAIN
C. SGA_TARGET
D. UNDO_MANAGEMENT
2. Which view displays database parameters and values A. V$SPPARAMETER
modified using the SCOPE=SPFILE clause?
A. V$SPPARAMETER
B. V$NLS_PARAMETER
C. V$HS_PARAMETER
D. V$PARAMETER
3. Which command performs a clean shutdown without D. SHUTDOWN IMMEDI-
waiting for clients to disconnect? ATE
A. SHUTDOWN ABORT
B. SHUTDOWN NORMAL
C. SHUTDOWN TRANSACTIONAL
D. SHUTDOWN IMMEDIATE
4. Which area is a member of the System Global Area A. Java Pool
(SGA)?
A. Java pool
B. Log writer
C. Database writer
D. Process monitor
5. D. Tablespace creation
, D330 - Data Systems Administration
Which types of events are recorded in an alert log?
A. Package creation
B. User creation
C. Role creation
D. Tablespace creation
6. Which initialization parameter sets the location of the C. DIAGNOSTIC_DEST
alert log?
A. AUDIT_FILE_DEST
B. LOG_ARCHIVE_DEST
C. DIAGNOSTIC_DEST
D. CORE_DUMP_DEST
7. Where is the listener.ora file located by default? B. $ORACLE_HOME/NET-
WORK/ADMIN
A. $ORACLE_HOME/RDBMS
B. $ORACLE_HOME/NETWORK/ADMIN
C. $ORACLE_HOME/DATABASE/ADMIN
D. $ORACLE_HOME/DBS/ADMIN
8. Which type of connection uses the Oracle Listener to A. Client with database
communicate? server
A. Client with database server
B. Browser with application server
C. Two application servers
D. Client with backup tool
9. What does the SERVER=DEDICATED element in a A. A committed server
tnsnames.ora file associate with each client connec- process
tion?
, D330 - Data Systems Administration
A. A committed server process
B. A shared server process
C. A pooled server process
D. A dispatched server process
10. Which net service naming method requires the client C. Host
to use a fixed port number?
A. Local
B. External
C. Host
D. Directory
11. A database link named wgu2021 has been created to A. scott.employ-
link to a remote object in the test database. The object ee@wgu2021
is named employee and is owned by Scott.
Which reference resolves to the remote object?
A. scott.employee@wgu2021
B. scott.employee
C. employee
D. scott.employee@test
12. Which information from a remote database is includ- A. User name
ed in the configuration of a database link?
A. User name
B. Data files
C. Tables
D. Views
13. B. table data
, D330 - Data Systems Administration
Which object can be added to an existing bigfile table-
space?
A. datafiletemp table
B. table data
C. tablespacedictionary table
D. undo data
14. What is the purpose of the undo tablespace? B. To facilitate the rollback
of transactions
A. To manage space for sort operations
B. To facilitate the rollback of transactions
C. To allocate space for SQL cursors
D. To maintain the Automatic Workload Repository
15. Which dictionary view is available in the database to C. DBA_ADVISOR_OB-
view segment advisor results? JECTS
A. DBA_ADVISOR_TASKS
B. DBA_ADVISOR_TEMPLATES
C. DBA_ADVISOR_OBJECTS
D. DBA_ADVISOR_USAGE
16. A database administrator needs to recover unused A. the SHRINK option
space from a tablespace while preventing data loss.
What should the administrator use?
A. The SHRINK option
B. The DROP command
C. The FLASHBACK command
D. The OFFLINE clause
1. Which parameter can an administrator enable with- C. SGA_TARGET
out restarting a database?
A. COMPATIBLE
B. DB_DOMAIN
C. SGA_TARGET
D. UNDO_MANAGEMENT
2. Which view displays database parameters and values A. V$SPPARAMETER
modified using the SCOPE=SPFILE clause?
A. V$SPPARAMETER
B. V$NLS_PARAMETER
C. V$HS_PARAMETER
D. V$PARAMETER
3. Which command performs a clean shutdown without D. SHUTDOWN IMMEDI-
waiting for clients to disconnect? ATE
A. SHUTDOWN ABORT
B. SHUTDOWN NORMAL
C. SHUTDOWN TRANSACTIONAL
D. SHUTDOWN IMMEDIATE
4. Which area is a member of the System Global Area A. Java Pool
(SGA)?
A. Java pool
B. Log writer
C. Database writer
D. Process monitor
5. D. Tablespace creation
, D330 - Data Systems Administration
Which types of events are recorded in an alert log?
A. Package creation
B. User creation
C. Role creation
D. Tablespace creation
6. Which initialization parameter sets the location of the C. DIAGNOSTIC_DEST
alert log?
A. AUDIT_FILE_DEST
B. LOG_ARCHIVE_DEST
C. DIAGNOSTIC_DEST
D. CORE_DUMP_DEST
7. Where is the listener.ora file located by default? B. $ORACLE_HOME/NET-
WORK/ADMIN
A. $ORACLE_HOME/RDBMS
B. $ORACLE_HOME/NETWORK/ADMIN
C. $ORACLE_HOME/DATABASE/ADMIN
D. $ORACLE_HOME/DBS/ADMIN
8. Which type of connection uses the Oracle Listener to A. Client with database
communicate? server
A. Client with database server
B. Browser with application server
C. Two application servers
D. Client with backup tool
9. What does the SERVER=DEDICATED element in a A. A committed server
tnsnames.ora file associate with each client connec- process
tion?
, D330 - Data Systems Administration
A. A committed server process
B. A shared server process
C. A pooled server process
D. A dispatched server process
10. Which net service naming method requires the client C. Host
to use a fixed port number?
A. Local
B. External
C. Host
D. Directory
11. A database link named wgu2021 has been created to A. scott.employ-
link to a remote object in the test database. The object ee@wgu2021
is named employee and is owned by Scott.
Which reference resolves to the remote object?
A. scott.employee@wgu2021
B. scott.employee
C. employee
D. scott.employee@test
12. Which information from a remote database is includ- A. User name
ed in the configuration of a database link?
A. User name
B. Data files
C. Tables
D. Views
13. B. table data
, D330 - Data Systems Administration
Which object can be added to an existing bigfile table-
space?
A. datafiletemp table
B. table data
C. tablespacedictionary table
D. undo data
14. What is the purpose of the undo tablespace? B. To facilitate the rollback
of transactions
A. To manage space for sort operations
B. To facilitate the rollback of transactions
C. To allocate space for SQL cursors
D. To maintain the Automatic Workload Repository
15. Which dictionary view is available in the database to C. DBA_ADVISOR_OB-
view segment advisor results? JECTS
A. DBA_ADVISOR_TASKS
B. DBA_ADVISOR_TEMPLATES
C. DBA_ADVISOR_OBJECTS
D. DBA_ADVISOR_USAGE
16. A database administrator needs to recover unused A. the SHRINK option
space from a tablespace while preventing data loss.
What should the administrator use?
A. The SHRINK option
B. The DROP command
C. The FLASHBACK command
D. The OFFLINE clause
