D330 Data Systems Administration - Set 2 - Part 1

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 1: Which statement is true regarding the SYSTEM tablespace?

ALTER TABLESPACE

ALTER DATA FILE

You cannot change the autoextensible feature once the data file is created.

ALTER DATABASE

It can be made read-only.

It can be offline.

Data files can be renamed.

Data files cannot be resized.

Question 2: 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?

Use Oracle Enterprise Manager Database Express.

Use Oracle Enterprise Manager Cloud Control.

Use DBMS_SERVER_ALERT package.

Use DBMS_SPACE package.

Question 3: Choose the statements that are resumable. (Choose three.)

ALTER TABLE ... SPLIT PARTITION

SELECT

INSERT INTO ... SELECT

CREATE TABLESPACE

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

You'll be notified by email at the address registered in database properties.

Write a custom script to look for "statement in resumable session was suspended" in the alert log and notify the DBA.

Create an AFTER SUSPEND trigger and a code notification.

A suspended session displays a message on the screen.

Question 5: Which statement regarding reclaiming wasted space is true?

Segment shrink is accomplished using the ALTER TABLE ... MOVE and ALTER INDEX ... REBUILD statements.

Segment shrink and reorganize are similar operations.

When a table segment shrink operation is completed, the dependent indexes are in an invalid state and need to be rebuilt.

A segment shrink operation is applicable only on tablespaces with automatic segment space management.

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

COMPRESS

NOCOMPRESS

COMPRESS FOR OLTP

COMPRESS FOR ONLINE DML

Question 7: Choose the best option regarding extents.

An extent is a grouping of Oracle blocks.

An extent is a grouping of OS blocks.

An extent is a grouping of segments.

An extent is allocated when a table is created.

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

The statement fails because mandatory properties are not defined.

The 100MB tablespace is created.

The mandatory DATAFILE clause is missing.

The tablespace name should be at least three characters long.

Question 9: Choose the information that is not part of a ROWID.

Data object number

Relative file number

Segment ID where the block belongs

Block number in the file

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

listener.ora

lsnrctl.ora

sqlnet.ora

tnsnames.ora

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

lsnrctl startup listener

lsnrctl start

netca start

netmgr start listener

Question 12: 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?

sqlnet.ora

tnsnames.ora

listener.ora

None of the above

Question 13: Connection Manager provides which of the following?

Multiplexing

Cross-protocol connectivity

Network access control

All of the above

Question 14: Which is a requirement for using host naming?

You must use tnsnames.ora on the client.

You must be using TCP/IP.

You must have an OID present.

You must have a sqlnet.ora file present on the client.

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

When a DRCP pooled server connection is made by an application, it is equivalent to a dedicated server connection.

When a database has DRCP enabled, all connections default to a pooled connection unless DEDICATED server is explicitly specified in the connect string.

When an application using the DRCP connection disconnects, the server connection (process) is handed off to the broker.

When using the Oracle Net Easy Connect method, it is not possible to utilize DRCP.

Question 16: A client receives the following error message: "ORA-12154 TNS

The listener is not running on the Oracle server.

The user entered an invalid net service name.

The user supplied the correct net service name, but the net service name is misspelled in the tnsnames.ora file on the client file.

Question 17:

CONNECT_DATA

SERVER

SERVICE_NAME

Question 18:

using Oracle Easy Connect. Which of the following connect strings are the choices for the client to use? (Choose two.)

CONNECT scott/tiger@dbprod.com:1522

CONNECT scott/tiger@1522

Question 19:

Overall memory utilization is reduced.

The system is predominantly used for decision support with large result sets returned.

Question 20: It is not ideal for decision support systems that involve large result sets.

Dedicated connections cannot be made when Shared Server is configured.

It is recommended that DSS type batch jobs be performed when connected via Shared Server.

Need Guaranteed Results?

Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support