D330 Data Systems Administration - Set 3 - 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 is used to view the current values of initialization parameters?

SELECT * FROM V$DATABASE;

SELECT * FROM V$PARAMETER;

SELECT * FROM V$SESSION;

SELECT * FROM V$INSTANCE;

Question 22: When using a binary initialization parameter file (spfile), which clause would ensure that changes to parameters are persisted across restarts?

ALTER SYSTEM SET parameter=value SCOPE=MEMORY;

ALTER SYSTEM SET parameter=value SCOPE=BOTH;

ALTER SYSTEM SET parameter=value SCOPE=SPFILE;

ALTER SYSTEM SET parameter=value SCOPE=ALL;

Question 23: Which of the following statements is true regarding the SYSTEM tablespace in an Oracle database?

It can be made read-only.

It can be taken offline.

Its data files can be renamed.

Its data files cannot be resized.

Question 24: Which of the following components is stored in a tablespace in an Oracle database?

Data file

Redo log file

Temporary segment

Control file

Question 25: What SQL statement would you issue to make a tablespace read-only?

ALTER DATABASE READ ONLY;

ALTER SYSTEM READ ONLY;

ALTER TABLESPACE READ ONLY;

ALTER FILESPACE READ ONLY;

Question 26: Which of the following views can be used to monitor tablespace utilization?

DBA_SEGMENTS

DBA_TABLESPACES

DBA_DATA_FILES

DBA_FREE_SPACE

Question 27: Which background process ensures that committed transactions are written to disk even if they have not yet been written to the data files?

DBWn

LGWR

ARCn

CKPT

Question 28: What happens when the ALTER SYSTEM command is used to change the value of an initialization parameter in a pfile?

The change is applied immediately and persists across restarts.

The change is applied in memory only and does not persist across restarts.

The change is not applied until the database is restarted.

The change is applied immediately and requires a database restart to take effect.

Question 29: What is the purpose of the DBMS_FGA package in Oracle?

To manage fine-grained auditing policies

To manage memory allocation

To perform database backup and recovery

To monitor tablespace usage

Question 30: Which view can be queried to monitor session activity and resource usage in an Oracle database?

V$SESSION

V$DATABASE

V$LOG

V$INSTANCE

Question 31: Which statement is true regarding the ALTER TABLESPACE command in Oracle?

It can be used to increase the size of the control file.

It can be used to resize data files.

It can be used to change the default block size.

It can be used to take the system tablespace offline.

Question 32: Which background process coalesces free space in dictionary-managed tablespaces?

DBWn

CKPT

SMON

PMON

Question 33: Which SQL statement is used to add more space to an existing tablespace by increasing the size of a data file?

ALTER SYSTEM ADD DATAFILE SIZE 500M;

ALTER TABLESPACE ADD DATAFILE SIZE 500M;

ALTER DATABASE DATAFILE 'filename' RESIZE 500M;

ALTER DATAFILE RESIZE 'filename' 500M;

Question 34: What is the minimum number of redo log groups required in an Oracle database?

One

Two

Three

Four

Question 35: Which of the following SQL statements is used to bring a tablespace online?

ALTER SYSTEM ONLINE;

ALTER DATABASE ONLINE;

ALTER TABLESPACE ONLINE;

ALTER DATAFILE ONLINE;

Question 36: What privilege is required to create a private database link?

CREATE SYNONYM

CREATE PUBLIC DATABASE LINK

CREATE DATABASE LINK

DBA

Question 37: What does the ALTER SYSTEM FLUSH SHARED_POOL command do in Oracle?

Clears all data from the database buffer cache

Flushes the shared pool and removes all cached SQL statements

Writes all dirty blocks to the data files

Forces a checkpoint

Question 38: Which of the following is true about Oracle's automatic segment space management (ASSM)?

ASSM uses bitmaps to manage free space.

ASSM is only available in temporary tablespaces.

ASSM requires manual intervention to coalesce free space.

ASSM is deprecated in Oracle 12c.

Question 39: Which view would you query to find out which data files are part of a tablespace?

DBA_SEGMENTS

DBA_TABLESPACES

DBA_DATA_FILES

DBA_TAB_COLUMNS

Question 40: Which SQL statement disables automatic archiving in Oracle?

ALTER SYSTEM ARCHIVELOG OFF;

ALTER SYSTEM SET LOG_ARCHIVE_DEST='';

ALTER DATABASE NOARCHIVELOG;

ALTER SYSTEM SET ARCHIVE_MODE=OFF;

Don't Want to Study?

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

Get Exam Support