D330 Data Systems Administration - Set 5 - Part 2

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

Question 21: Which SQL statement creates a sequence in Oracle?

CREATE SEQUENCE sequence_name;

CREATE NEXTVAL sequence_name;

CREATE NEW SEQUENCE sequence_name;

CREATE ORDERED sequence_name;

Question 22: Which Oracle background process ensures that data blocks in the buffer cache are written to disk?

SMON

DBWn

CKPT

PMON

Question 23: Which of the following is used to control the automatic extension of a data file in Oracle?

MAXSIZE

AUTOEXTEND

RESIZE

Question 24: Which Oracle tool is used to generate and analyze AWR reports?

SQL*Loader

RMAN

Enterprise Manager

Oracle Net Manager

Question 25: What is the purpose of Oracle's SQL*Loader utility?

To load data from external files into Oracle tables

To execute SQL scripts automatically

To monitor database performance

To generate reports on database activity

Question 26: Which SQL statement is used to alter the size of a data file in Oracle?

RESIZE FILE filename;

ALTER DATABASE DATAFILE filename RESIZE;

ALTER DATAFILE filename CHANGE SIZE;

MODIFY DATAFILE filename SIZE;

Question 27: Which of the following is a valid index type in Oracle?

Primary Index

Function-based Index

Unique Index

Secondary Index

Question 28: What is Oracle's Real Application Clusters (RAc) used for?

Data warehousing

High availability and scalability

Data replication between databases

Memory management

Question 29: Which of the following is a dynamic performance view in Oracle?

DBA_USERS

V$SESSION

ALL_TABLES

DBA_DATA_FILES

Question 30: What does the Oracle listener process do?

Monitors user sessions and terminates idle ones

Manages memory allocation for user sessions

Listens for incoming database connection requests

Writes the redo log buffer to disk

Question 31: Which of the following components is part of Oracle's System Global Area (SGA)?

PGA

Data Dictionary Cache

Background Processes

Redo Log Files

Question 32: Which SQL statement disables a constraint in Oracle?

ALTER TABLE table_name REMOVE CONSTRAINT constraint_name;

ALTER TABLE table_name DROP CONSTRAINT constraint_name;

ALTER TABLE table_name DISABLE CONSTRAINT constraint_name;

ALTER TABLE table_name CANCEL CONSTRAINT constraint_name;

Question 33: What is the primary function of Oracle's LogMiner utility?

To generate data recovery reports

To analyze redo logs for changes to the database

To monitor user sessions

To manage data dictionary views

Question 34: Which SQL statement is used to change the default tablespace of a user?

ALTER USER username SET DEFAULT TABLESPACE tablespace_name;

ALTER TABLESPACE tablespace_name SET DEFAULT;

ALTER USER username SET TABLESPACE tablespace_name;

ALTER USER username DEFAULT TABLESPACE tablespace_name;

Question 35: Which Oracle utility is used to create logical backups of tables?

RMAN

SQL*Loader

Data Pump

Export/Import

Question 36: Which Oracle background process is responsible for checkpointing?

DBWn

CKPT

SMON

LGWR

Question 37: What is Oracle's Materialized View used for?

To provide a logical backup of the table

To store the result of a query for faster retrieval

To manage user sessions

To analyze redo logs for changes

Question 38: Which of the following is true about Oracle's redo log files?

They are written to disk only during checkpoints.

They are used to recover changes made to the database after a failure.

They store a backup of the data files.

They store a copy of archived data.

Question 39: Which of the following options allows a table to automatically generate sequential numbers in Oracle?

AUTO_INCREMENT

DEFAULT NEXT VALUE

CREATE SEQUENCE

NEXTVAL

Question 40: What is the purpose of Oracle's SCN (System Change Number)?

It represents the timestamp of a specific change made in the database.

It stores the sequence number of the last transaction.

It is a unique identifier for each transaction in the redo logs.

It provides a unique identifier for recovery operations.

Don't Want to Study?

Save Time on Studies, Spend More with Family & Friends! Pay-After-you-Pass!

Get Exam Support