D330 Data Systems Administration - Set 4 - 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 creates a database link in Oracle?

CREATE DATABASE LINK link_name;

CREATE DB LINK link_name;

CREATE SYSTEM LINK link_name;

CREATE DATABASE CONNECTION link_name;

Question 42: Which view provides information about the data files in an Oracle database?

V$CONTROLFILE

V$DATAFILE

V$TABLESPACE

V$FILESTAT

Question 43: Which Oracle background process monitors the state of the database and handles recovery tasks after a failure?

SMON

CKPT

PMON

DBWn

Question 44: Which of the following commands is used to modify the size of an Oracle data file?

ALTER SYSTEM RESIZE DATAFILE;

ALTER DATABASE RESIZE DATAFILE;

ALTER TABLESPACE RESIZE DATAFILE;

ALTER DATAFILE RESIZE;

Question 45: Which SQL statement is used to enable restricted session mode in Oracle?

ALTER DATABASE ENABLE RESTRICTED SESSION;

ALTER SYSTEM SET RESTRICTED SESSION=TRUE;

ALTER SYSTEM ENABLE RESTRICTED SESSION;

ALTER SYSTEM SET SESSION_RESTRICTED=TRUE;

Question 46: Which of the following is used to configure memory allocation for the shared pool in Oracle?

DB_CACHE_SIZE

SHARED_POOL_SIZE

SGA_TARGET

PGA_AGGREGATE_TARGET

Question 47: Which SQL statement sets the default undo tablespace for an Oracle database?

ALTER SYSTEM SET UNDO_TABLESPACE=undo_tablespace_name;

ALTER DATABASE SET DEFAULT UNDO TABLESPACE undo_tablespace_name;

ALTER SYSTEM SET DEFAULT UNDO_TABLESPACE=undo_tablespace_name;

ALTER SYSTEM SET UNDO_TABLESPACE=undo_tablespace_name DEFAULT;

Question 48: Which SQL statement enables force logging mode in an Oracle database?

ALTER SYSTEM ENABLE FORCE LOGGING;

ALTER DATABASE ENABLE FORCE LOGGING;

ALTER SYSTEM SET FORCE_LOGGING=TRUE;

ALTER DATABASE SET FORCE_LOGGING=TRUE;

Question 49: What happens if the Oracle SYSTEM tablespace runs out of space?

New tables cannot be created.

The database continues running with warnings.

The database crashes.

Users cannot log in.

Question 50: Which Oracle background process writes the log buffer to the redo log files?

DBWn

CKPT

LGWR

SMON

Struggling With Exams?

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

Get Exam Support