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

WGU D330 Practice Questions – Set 2

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

Question 1 of 50

Which statement is true regarding the SYSTEM tablespace?

Question 2 of 50

The default critical threshold for a tablespace is set at 97 percent, and you think that is too low. Which two options can you use to change the threshold value to 90 percent for tablespace APPS_DATA?

Question 3 of 50

Choose the statements that are resumable. (Choose three.)

Question 4 of 50

How do you ensure you are notified when a resumable session is suspended? (Choose two.)

Question 5 of 50

Which statement regarding reclaiming wasted space is true

Question 6 of 50

Which compression option should be specified to compress blocks of tables that are used by the OLTP application?

Question 7 of 50

Choose the best option regarding extents.

Question 8 of 50

You issue the statement CREATE TABLESPACE X. Which of the following is the best option?

Question 9 of 50

Choose the information that is not part of a ROWID.

Question 10 of 50

Which of the following files must be present on the Oracle server to start a nondefault Oracle listener?

Question 11 of 50

Which of the following is the correct way to start a listener called LISTENER?

Question 12 of 50

When dynamic service registration is used, you will not see the service listed in which of the following files where it would normally be located?

Question 13 of 50

Connection Manager provides which of the following?

Question 14 of 50

Which is a requirement for using host naming?

Question 15 of 50

Which statements regarding Database Resident Connection Pooling (DRCP) are true? (Choose two.)

Question 16 of 50

A client receives the following error message: “ORA-12154 TNS

not resolve the connect identifier specified.” Which of the following could be possible causes of the error? (Choose all that apply.)

Question 17 of 50

What portion of the tnsnames.ora file specifies the name or IP address of the server where the listener process is listening?

Question 18 of 50

A client wants to connect to the database service dbprod.com located on the dbprod.com server through a nondefault port (1522) using Oracle Easy Connect. Which of the following connect strings are the choices for the client to use? (Choose two.)

Question 19 of 50

All of the following are reasons to configure the server using Shared Server except which one?

Question 20 of 50

Which of the following is true about Shared Server?

Question 21 of 50

The administrator wants to allow a user to connect via a dedicated connection into a database configured in Shared Server mode. Which of the following options accomplishes this?

Question 22 of 50

In which of the following files would you find the Shared Server configuration parameters?

Question 23 of 50

What is the first step that the dispatcher performs after it receives a request from the user?

Question 24 of 50

When configured in Shared Server mode, which of the following is contained in the PGA?

Question 25 of 50

Which of the following is false about request queues?

Question 26 of 50

What is the process that notifies the listener after a database connection is established?

Question 27 of 50

Which network architecture connection uses session memory from the SGA?

Question 28 of 50

Communication between two Oracle databases is configured using:

Question 29 of 50

DBA user MIKE ran the SQL statement CREATE DATABASE LINK SCOTT.SALES_LINK.BJS.COM CONNECT TO SALES_INT IDENTIFIED BY SALESPWD1 USING ‘ocasvr:1522/ocadb’. Choose the option that is true.

Question 30 of 50

Which of the following statements create an Oracle account but let the operating system authenticate logons? (Choose two.)

Question 31 of 50

If you want to capture the SQL statement and bind variables when performing a standard statement audit, which value should the AUDIT_TRAIL parameter have?

Question 32 of 50

Which of the following statements give user desmond the ability to alter table gl.accounts?

Question 33 of 50

Which of the following statements has the correct syntax and gives the ability to grant the privilege to other users?

Question 34 of 50

Examine the CREATE USER statement and choose which of the following options best applies.

Question 35 of 50

User system granted the SELECT privilege on sh.products to user ian using WITH GRANT OPTION. Ian then granted SELECT on sh.products to user stuart. Ian has left the company, and his account has been dropped. What happens to Stuart’s privileges on sh.products?

Question 36 of 50

User system granted the SELECT ANY TABLE privilege to user ian using WITH ADMIN OPTION. Ian then granted SELECT ANY TABLE to user stuart. Ian has left the company, and his account has been dropped. What happens to Stuart’s privileges?

Question 37 of 50

Which of the following system privileges should be granted judiciously because they can allow the grantee to masquerade as another user?

Question 38 of 50

Which of the following statements enables the role user_admin in the current session?

Question 39 of 50

Which of the following SQL statements allows user augustin to use the privileges associated with the password-protected role info_czar that has been granted to him?

Question 40 of 50

By default, how much space can any account use for a new table?

Question 41 of 50

Which of the following SQL statements disconnects a session after it has been idle for 30 minutes?

Question 42 of 50

Which of the following options prevents a user from reusing a password when they change their password?

Question 43 of 50

Which of the following components of a ROWID uniquely identifies the location of a row in a database?

Question 44 of 50

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

Question 45 of 50

Which SQL statement will prevent any new rows from being added to the JOBS table in the USERS tablespace, assuming the table currently exists?

Question 46 of 50

Which SQL statement creates a private database link?

Question 47 of 50

Which of the following initialization parameters is required to use Automatic Storage Management (ASM)?

Question 48 of 50

Which of the following SQL statements disables a role in the current session?

Question 49 of 50

What happens when an ALTER SYSTEM statement is issued to change the value of the UNDO_RETENTION parameter?

Question 50 of 50

Which of the following privileges is required to create a public synonym in an Oracle database?

Set 2 complete

You scored 0%

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

Next: Set 3

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