D330 Data Systems Administration - Set 5 - Part 3

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

Question 41: Which SQL statement is used to lock a table in Oracle?

LOCK TABLE table_name;

ALTER TABLE LOCK table_name;

LOCK table_name;

LOCK TABLE table_name IN EXCLUSIVE MODE;

Question 42: Which of the following options provides the ability to rollback a transaction in Oracle?

UNDO

ROLLBACK TO SAVEPOINT

RESTORE

REVERT

Question 43: Which Oracle process is responsible for generating redo entries?

DBWn

SMON

LGWR

PMON

Question 44: Which of the following views in Oracle provides information about current system performance metrics?

V$SESSION

V$SYSSTAT

DBA_DATA_FILES

DBA_USERS

Question 45: Which Oracle utility is used for block-level recovery of database files?

RMAN

Data Pump

LogMiner

Export/Import

Question 46: Which of the following Oracle background processes frees unused memory from the SGA?

DBWn

PMON

CKPT

SMON

Question 47: Which of the following SQL statements enables flashback mode in Oracle?

ALTER SYSTEM ENABLE FLASHBACK;

ALTER DATABASE FLASHBACK ON;

ENABLE FLASHBACK MODE;

ALTER SYSTEM START FLASHBACK;

Question 48: Which of the following is used to enforce referential integrity between tables in Oracle?

Indexes

Foreign Keys

Sequences

Views

Question 49: Which of the following statements is true about Oracle's Automatic Storage Management (ASM)?

It is used to manage table spaces.

It simplifies database storage management by automating the storage of database files.

It optimizes SQL query performance.

It provides automatic backups for the database.

Question 50: Which of the following SQL statements modifies a table to add a new column?

MODIFY TABLE ADD COLUMN column_name;

ALTER TABLE table_name ADD column_name;

INSERT COLUMN column_name INTO table_name;

UPDATE TABLE table_name ADD COLUMN column_name;

Congratulations! You have completed all 5 question sets. Good job!

Go Back to Home

Struggling With Exams?

Less Time Studying, More Time Living – Finish Your Degree Faster! Pay-After-you-Pass!

Get Exam Support