D330 Data Systems Administration - Set 5 - 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 of the following statements is true about Oracle database redo logs?

Redo logs store only committed transactions.

Redo logs store both committed and uncommitted transactions.

Redo logs are only written when a checkpoint occurs.

Redo logs store a backup of the data files.

Question 2: What is the purpose of Oracle's flashback technology?

To recover from user errors by restoring an entire database to a previous point in time.

To roll forward changes from redo logs.

To generate reports of past data changes.

To provide automated backups.

Question 3: Which SQL command is used to create a temporary tablespace in Oracle?

CREATE TEMPORARY TABLESPACE;

CREATE TEMP TABLESPACE;

CREATE TEMPORARY SPACE;

CREATE TEMPORARY STORAGE;

Question 4: Which of the following statements is true about Oracle Automatic Workload Repository (AWR)?

AWR snapshots are automatically generated by Oracle every 10 minutes.

AWR stores performance-related statistics.

AWR reports are stored in the redo logs.

AWR reports can be generated only manually.

Question 5: Which Oracle process is responsible for recovering the database after a failure?

LGWR

CKPT

SMON

DBWn

Question 6: What happens when a database is opened in read-only mode?

Users cannot connect to the database.

Users can view data, but no DML or DDL operations can be performed.

The database prevents all access to the data.

Users can update data but cannot modify the schema.

Question 7: Which SQL statement is used to drop a user in Oracle?

REMOVE USER username;

DROP USER username;

DELETE USER username;

REVOKE USER username;

Question 8: What does the Oracle background process PMON do?

Performs instance recovery

Monitors user sessions and cleans up after terminated sessions

Writes data to data files

Checks data block integrity

Question 9: What is the primary purpose of Oracle's Data Guard?

To provide a backup solution

To enable disaster recovery and high availability

To automate database tuning

To facilitate data replication between databases

Question 10: Which SQL statement is used to remove a column from a table in Oracle?

DELETE COLUMN column_name;

ALTER TABLE DROP column_name;

DROP COLUMN column_name;

ALTER TABLE REMOVE column_name;

Question 11: Which of the following best describes Oracle's undo tablespace?

It stores backup copies of data files.

It stores information required to roll back transactions.

It logs changes made to the data for recovery purposes.

It stores archived redo logs.

Question 12: What is the default port used by Oracle listeners?

1521

8080

1433

1522

Question 13: Which of the following views is used to find information about active sessions in an Oracle database?

V$SESSION

DBA_USERS

V$LOG

V$DATAFILE

Question 14: Which of the following Oracle features allows a database to be recovered up to a specific point in time?

Flashback Query

Point-in-Time Recovery (PITR)

Redo Log Archiving

Data Pump

Question 15: Which Oracle background process is responsible for archiving redo logs?

DBWn

SMON

CKPT

ARCn

Question 16: Which SQL statement is used to revoke a privilege from a user in Oracle?

REVOKE privilege FROM user;

REMOVE privilege FROM user;

DELETE privilege FROM user;

DROP privilege FROM user;

Question 17: Which of the following is true about Oracle Database Resource Manager?

It is used to monitor database memory usage.

It is used to manage system resources such as CPU and I/O.

It is used to optimize SQL query performance.

It is used to manage undo space.

Question 18: Which of the following components is responsible for parsing SQL statements in Oracle?

Buffer Cache

Redo Log Buffer

Library Cache

Data Dictionary

Question 19: Which of the following statements is true about Oracle's Enterprise Manager?

It is used to schedule backups only.

It is an integrated management tool for monitoring and maintaining Oracle databases.

It is used only for monitoring memory usage.

It is primarily used for SQL query optimization.

Question 20: What is the purpose of Oracle's Data Pump?

To recover a database to a previous point in time

To perform high-speed data export and import

To archive redo logs

To manage memory allocation

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