Skip to content
Pass Any WGU OA Exam Now & Pay After You Pass. Contact Us!
  1. Home
  2. WGU Exams
  3. WGU D330
  4. Set 3
WGU D330 · Data Systems Administration

WGU D330 Practice Questions – Set 3

50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.

Question 1 of 50

Which of the following is the correct order of Oracle’s storage hierarchy from smallest to largest?

Question 2 of 50

What happens when the PMON process is terminated in Oracle Database?

Question 3 of 50

When a user commits a transaction, which background process is responsible for writing the transaction details to the redo log files?

Question 4 of 50

Which of the following startup modes is used when creating a new database?

Question 5 of 50

Which process is responsible for performing instance recovery after a database crash?

Question 6 of 50

In Oracle RAC, which statement best describes a RAC configuration?

Question 7 of 50

Which component of the SGA stores parsed SQL statements?

Question 8 of 50

Which of the following processes cleans up after a user session is terminated?

Question 9 of 50

Which background process writes the dirty blocks from the database buffer cache to the data files?

Question 10 of 50

Which of the following SGA components would you increase to ensure that RMAN tape backups do not use memory from the shared pool?

Question 11 of 50

Which startup mode would be used to allow only DBA users to connect to the database?

Question 12 of 50

Which of the following components is part of the Oracle database, not the Oracle instance?

Question 13 of 50

Which data dictionary view would you query to find the current status of redo log groups?

Question 14 of 50

Which Oracle file is updated with the checkpoint position during an incremental checkpoint?

Question 15 of 50

Which background process is responsible for writing the checkpoint information to the control files?

Question 16 of 50

Which component of the Oracle database architecture includes the system global area (SGA) and background processes?

Question 17 of 50

In which file can you find information on Oracle database errors such as ORA-00600?

Question 18 of 50

Which background process is responsible for archiving redo logs in ARCHIVELOG mode?

Question 19 of 50

Which of the following SQL statements will show the redo log groups required for instance crash recovery?

Question 20 of 50

What is the primary purpose of the data dictionary in an Oracle database?

Question 21 of 50

Which SQL statement is used to view the current values of initialization parameters?

Question 22 of 50

When using a binary initialization parameter file (spfile), which clause would ensure that changes to parameters are persisted across restarts?

Question 23 of 50

Which of the following statements is true regarding the SYSTEM tablespace in an Oracle database

Question 24 of 50

Which of the following components is stored in a tablespace in an Oracle database?

Question 25 of 50

What SQL statement would you issue to make a tablespace read-only?

Question 26 of 50

Which of the following views can be used to monitor tablespace utilization?

Question 27 of 50

Which background process ensures that committed transactions are written to disk even if they have not yet been written to the data files?

Question 28 of 50

What happens when the ALTER SYSTEM command is used to change the value of an initialization parameter in a pfile?

Question 29 of 50

What is the purpose of the DBMS_FGA package in Oracle?

Question 30 of 50

Which view can be queried to monitor session activity and resource usage in an Oracle database?

Question 31 of 50

Which statement is true regarding the ALTER TABLESPACE command in Oracle?

Question 32 of 50

Which background process coalesces free space in dictionary-managed tablespaces?

Question 33 of 50

Which SQL statement is used to add more space to an existing tablespace by increasing the size of a data file?

Question 34 of 50

What is the minimum number of redo log groups required in an Oracle database?

Question 35 of 50

Which of the following SQL statements is used to bring a tablespace online?

Question 36 of 50

What privilege is required to create a private database link?

Question 37 of 50

What does the ALTER SYSTEM FLUSH SHARED_POOL command do in Oracle?

Question 38 of 50

Which of the following is true about Oracle’s automatic segment space management (ASSM)?

Question 39 of 50

Which view would you query to find out which data files are part of a tablespace?

Question 40 of 50

Which SQL statement disables automatic archiving in Oracle?

Question 41 of 50

What is the purpose of the Oracle Scheduler?

Question 42 of 50

Which of the following statements is true about Oracle Managed Files (OMF)?

Question 43 of 50

Which of the following SQL statements creates an undo tablespace?

Question 44 of 50

Which of the following actions is performed by the Oracle listener process?

Question 45 of 50

Which SQL statement disables a role for the current session?

Question 46 of 50

Which view provides information about the files that belong to locally managed temporary tablespaces?

Question 47 of 50

What is the smallest allocation unit in Oracle’s storage hierarchy?

Question 48 of 50

Which process is responsible for updating the control files and data file headers with the latest checkpoint information?

Question 49 of 50

Which of the following components are stored in a tablespace?

Question 50 of 50

Which SQL statement changes the default temporary tablespace for a user?

Set 3 complete

You scored 0%

0 correct out of 0 answered (50 questions in this set).

Next: Set 4

Struggling with WGU D330?

If this exam is giving you a hard time, let us be your helping hand. Contact us, and we'll provide the assistance you need to pass and move forward.

Chat Now