WGU D330 PA
WGU D330 PA
Study online at https://quizlet.com/_dpudb6
1. Which parameter can an administrator enable without C. SGA_TARGET
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
, WGU D330 PA
WGU D330 PA
Study online at https://quizlet.com/_dpudb6
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?
, WGU D330 PA
WGU D330 PA
Study online at https://quizlet.com/_dpudb6
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 included A. User name
in the configuration of a database link?
A. User name
B. Data files
C. Tables
D. Views
13. B. table data
WGU D330 PA
Study online at https://quizlet.com/_dpudb6
1. Which parameter can an administrator enable without C. SGA_TARGET
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
, WGU D330 PA
WGU D330 PA
Study online at https://quizlet.com/_dpudb6
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?
, WGU D330 PA
WGU D330 PA
Study online at https://quizlet.com/_dpudb6
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 included A. User name
in the configuration of a database link?
A. User name
B. Data files
C. Tables
D. Views
13. B. table data
