WGU D330 (7) questions and answers graded A+
2025 updated
1. Using EM Database Control, you've
A. Run the SQL Tuning Advisor.
iden- tified the following SQL
statement as the source of a lot of Running the SQL Tuning Advisor
disk I/O: provides the most information about
how the per- formance of this SQL
SELECT NAME, LOCATION, CREDIT_LIMIT
statement might be improved. The
FROM CUSTOMERS
SQL Access Advisor is run only after
the output from the SQL Tuning Advisor
What should you do first to try to
indicates that it will be useful. EM
improve performance?
Database Control does not store
A. Run the SQL Tuning Advisor. detailed information about I/O activity
in its alerts nor in the alert log.
B. Run the SQL Access Advisor.
C. Check the EM Database Control
main screen for alerts.
D. Click the Alert Log Content link in
the EM Database Control main
screen.
2. Among the failure events, which is the most A. The loss of an entire redo
log-file group
serious and may cause data loss? C. The failure of the
ARCn background
A. The loss of an entire redo log-file process
group but no loss in any other
group D. The failure of the
LGWR background
B. The loss of one member of each process
redo log-file group
1/
17
,WGU D330 (7) questions and answers graded A+
2025 updated
but no loss in any other group
Losing an entire redo log-file group can result in losing
committed transactions that may not yet have been written to
the data- base files. Losing all members of a redo logfile
group except for one does not af- fect database operation
and does not re- sult in data loss. A message is placed in
the alert log file. The failure of LGWR causes an instance
failure, but you do not lose any committed transaction data.
When an ARCn
2/
17
, WGU D330 (7) questions and answers graded A+
2025 updated
in its own backup file,
but an image copy
places all data files
3. When the database is in into a single output
ARCHIVELOG mode, database file.
recovery is possible up to which
event or time? 5. Which of the
following is not a
A. The last redo log file switch step in con- figuring
B. The last checkpoint position your database to
C. The last commit archive redo log
D.The last incremental backup using
RMAN
4. Which is a true statement regarding
image copies and backup sets.
A. An image copy stores one data
file per image copy, and a backup
set can store many data files in a
single file.
B. An image copy stores one data
file per image copy, and a backup
set consists of one file per data file
backed up.
C. Both image copies and backup sets
use a single file to store all objects to
be backed up.
D. A backup set stores each data file
3/
17
2025 updated
1. Using EM Database Control, you've
A. Run the SQL Tuning Advisor.
iden- tified the following SQL
statement as the source of a lot of Running the SQL Tuning Advisor
disk I/O: provides the most information about
how the per- formance of this SQL
SELECT NAME, LOCATION, CREDIT_LIMIT
statement might be improved. The
FROM CUSTOMERS
SQL Access Advisor is run only after
the output from the SQL Tuning Advisor
What should you do first to try to
indicates that it will be useful. EM
improve performance?
Database Control does not store
A. Run the SQL Tuning Advisor. detailed information about I/O activity
in its alerts nor in the alert log.
B. Run the SQL Access Advisor.
C. Check the EM Database Control
main screen for alerts.
D. Click the Alert Log Content link in
the EM Database Control main
screen.
2. Among the failure events, which is the most A. The loss of an entire redo
log-file group
serious and may cause data loss? C. The failure of the
ARCn background
A. The loss of an entire redo log-file process
group but no loss in any other
group D. The failure of the
LGWR background
B. The loss of one member of each process
redo log-file group
1/
17
,WGU D330 (7) questions and answers graded A+
2025 updated
but no loss in any other group
Losing an entire redo log-file group can result in losing
committed transactions that may not yet have been written to
the data- base files. Losing all members of a redo logfile
group except for one does not af- fect database operation
and does not re- sult in data loss. A message is placed in
the alert log file. The failure of LGWR causes an instance
failure, but you do not lose any committed transaction data.
When an ARCn
2/
17
, WGU D330 (7) questions and answers graded A+
2025 updated
in its own backup file,
but an image copy
places all data files
3. When the database is in into a single output
ARCHIVELOG mode, database file.
recovery is possible up to which
event or time? 5. Which of the
following is not a
A. The last redo log file switch step in con- figuring
B. The last checkpoint position your database to
C. The last commit archive redo log
D.The last incremental backup using
RMAN
4. Which is a true statement regarding
image copies and backup sets.
A. An image copy stores one data
file per image copy, and a backup
set can store many data files in a
single file.
B. An image copy stores one data
file per image copy, and a backup
set consists of one file per data file
backed up.
C. Both image copies and backup sets
use a single file to store all objects to
be backed up.
D. A backup set stores each data file
3/
17
