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 1
WGU D330 · Data Systems Administration

WGU D330 Practice Questions – Set 1

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 statements regarding Oracle Database control files is true?

Question 2 of 50

Which component is configured at database startup and cannot be dynamically managed?

Question 3 of 50

Which component is not part of an Oracle instance?

Question 4 of 50

Which background process guarantees that committed data is saved even when the changes have not been recorded in data files?

Question 5 of 50

User John has updated several rows in a table and issued a commit. What does the DBWn (database writer) process do at this time in response to the commit event?

Question 6 of 50

Which of the following best describes a RAC configuration?

Question 7 of 50

Which component of the SGA contains the parsed SQL code?

Question 8 of 50

Which tasks are accomplished by the SMON process? (Choose all that apply.)

Question 9 of 50

Choose the best statement from the options related to segments.

Question 10 of 50

From the following list, choose two processes that are optional in an Oracle Database 12c database.

Question 11 of 50

Which SGA component will you increase or configure so that RMAN tape backups do not use memory from the shared pool?

Question 12 of 50

When a user session is terminated, which processes are responsible for cleaning up and releasing locks? (Choose all that apply.)

Question 13 of 50

The LRU algorithm is used to manage what part of the Oracle architecture

Question 14 of 50

Two structures make up an Oracle server: an instance and a database. Which of the following best describes the difference between an Oracle instance and a database?

Question 15 of 50

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

Question 16 of 50

The DBA unknowingly terminated the process ID belonging to the PMON process of Oracle Database 12c database using the kill -9 command on Unix. Choose the best answer.

Question 17 of 50

When an incremental checkpoint happens in a database, which file(s) are updated with the checkpoint position? Choose all options that are correct.

Question 18 of 50

User Isabella updates a table and commits the change after a few seconds. Which of the following actions are happening in the database? Order them in the correct sequence and ignore the actions that are not relevant.

Question 19 of 50

Querying the V$LOG file shows the following information. Which redo group files are required for instance crash recovery?

1 NO CURRENT

2 NO INACTIVE

3 NO INACTIVE

4 NO ACTIVE

Question 20 of 50

You noticed that the current value of the UNDO_RETENTION parameter is 900 and is too low for some of your transactions. The database was created using DBCA. You issue the following statement: ALTER SYSTEM SET UNDO_RETENTION=4800; Which option is true?

Question 21 of 50

You need to find the directory where the Oracle alert log is being written. Which initialization parameter can be best used to list the full directory path of the alert log location?

Question 22 of 50

Which data dictionary view is used to view the current values of parameters?

Question 23 of 50

Which startup options must be used to start the instance when you create a new database?

Question 24 of 50

The DIAGNOSTIC_DEST parameter is not set up in the initialization parameter file. The value of the ORACLE_HOME environment variable is /u01/app/oracle/product/12.1.0 , and the value of ORACLE_BASE is /u01/app/oracle . The database and instance name is xyz. What is the location of the text-alert log file for the xyz database?

Question 25 of 50

You want to create a database using the DBCA with DB_BLOCK_SIZE as 32KB. Which statement is true?

Question 26 of 50

All of the following are database-management options within the Database Configuration Assistant except which one?

Question 27 of 50

The Oracle Universal Installer is started by executing which program?

Question 28 of 50

You’ve been asked to install Oracle Database 12c on a new Linux server. You’re likely to ask the Unix system administrator to do all but which one of the following for you in order to get the new server ready for Oracle?

Question 29 of 50

Your database name is OCA12C. The options show the files that are available in the $ORACLE_HOME/dbs directory. Which file is used to start up the database instance when you issue the STARTUP command?

Question 30 of 50

Which initialization parameter cannot be changed after the database is created?

Question 31 of 50

Which script creates the database dictionary?

Question 32 of 50

If your database name is PROD and your instance name is PROD1, what would be the name of the text-alert log file?

Question 33 of 50

Your database is not responding and is in a hung state. You want to shut down and start the database to release all resources. Which statements would you use?

Question 34 of 50

Which of the following startup options does not perform a database recovery?

Question 35 of 50

Which of the following shutdown statements does not perform a clean shutdown?

Question 36 of 50

You would like to perform maintenance on the system and limit access to only the DBA staff during the maintenance window. Which of the following startup options should you use?

Question 37 of 50

You want to start up the database using a binary initialization file. What is another name for this file?

Question 38 of 50

Under normal circumstances, which of the following actions or events is not found in the Oracle alert log?

Question 39 of 50

Which of the following is true about EM Database Express? (Choose all that apply.)

Question 40 of 50

Which of the following statements about tablespaces is true?

Question 41 of 50

Automatic segment space management on the tablespace causes which of the following table attributes in that tablespace to be ignored?

Question 42 of 50

Which is not a type of segment that is stored in a tablespace?

Question 43 of 50

Which allocation unit is the smallest?

Question 44 of 50

You performed the following statement in the database. What actions can you perform on the CUST_INFO table in the CUST_DATA tablespace? (Choose all that apply.)

ALTER TABLESPACE CUST_DATA READ ONLY;

Question 45 of 50

If the tablespace is offline, which statements should be executed to make the USERS tablespace read-only? (Choose all that apply.)

Question 46 of 50

How would you add more space to a tablespace? (Choose all that apply.)

Question 47 of 50

The database is using automatic memory management. The standard block size for the database is 8KB. You need to create a tablespace with a block size of 16KB. Which initialization parameter should be set?

Question 48 of 50

Which data dictionary view can be queried to obtain information about the files that belong to locally managed temporary tablespaces?

Question 49 of 50

How would you drop a tablespace if the tablespace were not empty?

Question 50 of 50

Which command is used to enable the autoextensible feature for a file if the file is already part of a tablespace?

Set 1 complete

You scored 0%

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

Next: Set 2

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