WGU D330 - DATA SYSTEMS ADMINISTRATION
NEWEST EXAM QUESTIONS AND 100% CORRECT
ANSWERS
Which command performs a clean shutdown without waiting for clients to
disconnect?
A. SHUTDOWN ABORT
B. SHUTDOWN NORMAL
C. SHUTDOWN TRANSACTIONAL
D. SHUTDOWN IMMEDIATE
D. SHUTDOWN IMMEDIATE
Which data dictionary view can be queried to obtain information about the
files that belong to locally managed temporary tablespaces?
A. DBA_DATA_FILES
B. DBA_TABLESPACES
C. DBA_TEMP_FILES
D. DBA_LOCAL_FILES
C. DBA_TEMP_FILES
Place the following events or actions leading up to and during instance
recovery in the correct order.
1. The database is opened and available.
2. Oracle uses undo segments in the undo tablespace to roll back
uncommitted transactions.
3. The DBA issues the STARTUP command at the SQL*Plus prompt.
4. Oracle applies the information in the online redo log files to the data files.
A. 4, 3, 2, 1
B. 3, 4, 1, 2
C. 2, 1, 3, 4
D. 2, 1, 4, 3
E. 3, 2, 4, 1
F. 3, 4, 2, 1
F. 3, 4, 2, 1
,When you are upgrading a database to Oracle Database 12c, which of the
following options are true?
A. Any version of an Oracle 10g or Oracle 11g database can be upgraded
to Oracle Database 12c using DBUA.
B. Only the versions 10.2.0.5, 11.1.0.7, 11.2.0.2, 11.2.0.3, and 11.2.0.4 can
be upgraded to 12.1.0.
C. Once upgraded to Oracle Database 12c, the upgraded database can
only be downgraded to Oracle 11g.
D. When a 10.2.0.5 database is upgraded to Oracle Database 12c, it
cannot be downgraded.
B. Only the versions 10.2.0.5, 11.1.0.7, 11.2.0.2, 11.2.0.3, and 11.2.0.4 can
be upgraded to 12.1.0.
Which parameter can an administrator enable without restarting a
database?
A. COMPATIBLE
B. DB_DOMAIN
C. SGA_TARGET
D. UNDO_MANAGEMENT
C. SGA_TARGET
Which view displays database parameters and values modified using the
SCOPE=SPFILE clause?
A. V$SPPARAMETER
B. V$NLS_PARAMETER
C. V$HS_PARAMETER
D. V$PARAMETER
A. V$SPPARAMETER
Which command performs a clean shutdown without waiting for clients to
disconnect?
, A. SHUTDOWN ABORT
B. SHUTDOWN NORMAL
C. SHUTDOWN TRANSACTIONAL
D. SHUTDOWN IMMEDIATE
D. SHUTDOWN IMMEDIATE
Which area is a member of the System Global Area (SGA)?
A. Java pool
B. Log writer
C. Database writer
D. Process monitor
A. Java Pool
Which types of events are recorded in an alert log?
A. Package creation
B. User creation
C. Role creation
D. Tablespace creation
D. Tablespace creation
Which initialization parameter sets the location of the alert log?
A. AUDIT_FILE_DEST
B. LOG_ARCHIVE_DEST
C. DIAGNOSTIC_DEST
D. CORE_DUMP_DEST
C. DIAGNOSTIC_DEST
Where is the listener.ora file located by default?
A. $ORACLE_HOME/RDBMS
B. $ORACLE_HOME/NETWORK/ADMIN
NEWEST EXAM QUESTIONS AND 100% CORRECT
ANSWERS
Which command performs a clean shutdown without waiting for clients to
disconnect?
A. SHUTDOWN ABORT
B. SHUTDOWN NORMAL
C. SHUTDOWN TRANSACTIONAL
D. SHUTDOWN IMMEDIATE
D. SHUTDOWN IMMEDIATE
Which data dictionary view can be queried to obtain information about the
files that belong to locally managed temporary tablespaces?
A. DBA_DATA_FILES
B. DBA_TABLESPACES
C. DBA_TEMP_FILES
D. DBA_LOCAL_FILES
C. DBA_TEMP_FILES
Place the following events or actions leading up to and during instance
recovery in the correct order.
1. The database is opened and available.
2. Oracle uses undo segments in the undo tablespace to roll back
uncommitted transactions.
3. The DBA issues the STARTUP command at the SQL*Plus prompt.
4. Oracle applies the information in the online redo log files to the data files.
A. 4, 3, 2, 1
B. 3, 4, 1, 2
C. 2, 1, 3, 4
D. 2, 1, 4, 3
E. 3, 2, 4, 1
F. 3, 4, 2, 1
F. 3, 4, 2, 1
,When you are upgrading a database to Oracle Database 12c, which of the
following options are true?
A. Any version of an Oracle 10g or Oracle 11g database can be upgraded
to Oracle Database 12c using DBUA.
B. Only the versions 10.2.0.5, 11.1.0.7, 11.2.0.2, 11.2.0.3, and 11.2.0.4 can
be upgraded to 12.1.0.
C. Once upgraded to Oracle Database 12c, the upgraded database can
only be downgraded to Oracle 11g.
D. When a 10.2.0.5 database is upgraded to Oracle Database 12c, it
cannot be downgraded.
B. Only the versions 10.2.0.5, 11.1.0.7, 11.2.0.2, 11.2.0.3, and 11.2.0.4 can
be upgraded to 12.1.0.
Which parameter can an administrator enable without restarting a
database?
A. COMPATIBLE
B. DB_DOMAIN
C. SGA_TARGET
D. UNDO_MANAGEMENT
C. SGA_TARGET
Which view displays database parameters and values modified using the
SCOPE=SPFILE clause?
A. V$SPPARAMETER
B. V$NLS_PARAMETER
C. V$HS_PARAMETER
D. V$PARAMETER
A. V$SPPARAMETER
Which command performs a clean shutdown without waiting for clients to
disconnect?
, A. SHUTDOWN ABORT
B. SHUTDOWN NORMAL
C. SHUTDOWN TRANSACTIONAL
D. SHUTDOWN IMMEDIATE
D. SHUTDOWN IMMEDIATE
Which area is a member of the System Global Area (SGA)?
A. Java pool
B. Log writer
C. Database writer
D. Process monitor
A. Java Pool
Which types of events are recorded in an alert log?
A. Package creation
B. User creation
C. Role creation
D. Tablespace creation
D. Tablespace creation
Which initialization parameter sets the location of the alert log?
A. AUDIT_FILE_DEST
B. LOG_ARCHIVE_DEST
C. DIAGNOSTIC_DEST
D. CORE_DUMP_DEST
C. DIAGNOSTIC_DEST
Where is the listener.ora file located by default?
A. $ORACLE_HOME/RDBMS
B. $ORACLE_HOME/NETWORK/ADMIN
