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

Question 2: 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 3: 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 4: 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 5: 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 6: 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 7: 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 8: 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 9: 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 10: Connection Manager provides which of the following?

Multiplexing

Cross-protocol connectivity

Network access control

All of the above

Question 11: 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 12: What is the primary responsibility of a database administrator (DBA)?

Writing all application user interfaces

Designing marketing campaigns

Ensuring database availability, performance, security, and integrity

Managing office facilities

Question 13: What is a full database backup?

A copy of only changed data since the last backup

A copy of the transaction log only

A copy of the table structures only

A complete copy of the entire database at a point in time

Question 14: What does an incremental backup capture?

Only the data changed since the last backup of any type

The entire database every time

Only the database schema

Only user account information

Question 15: What does a differential backup capture?

Only changes since the previous differential

All changes made since the last full backup

The entire database

Only the transaction log

Question 16: Why are transaction log backups important?

They compress the database files

They create new indexes automatically

They enable point-in-time recovery to a specific moment

They encrypt the stored data

Question 17: What is the purpose of testing database restores regularly?

To increase backup file size

To reduce the number of backups needed

To delete old data automatically

To verify backups are valid and recovery procedures actually work

Question 18: What is database replication?

Copying and maintaining data across multiple database servers

Deleting duplicate rows

Compressing the database

Renaming database tables

Question 19: What distinguishes synchronous from asynchronous replication?

Synchronous is always slower to configure

Synchronous confirms writes on the replica before acknowledging the transaction

Asynchronous guarantees zero data loss

They are functionally identical

Question 20: What is database failover?

Deleting the primary database

Reducing the number of servers

Switching operations to a standby server when the primary fails

Disabling all user access

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