D330 Data Systems Administration - Set 1 - 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 regarding Oracle Database control files is true?

A database can have only one control file.

A database must have at least two control files.

A database may have zero or more control files.

A database must have at least one control file.

Question 2: Which component is configured at database startup and cannot be dynamically managed?

Redo log buffer

Streams pool

Java pool

Shared pool

Question 3: Which component is not part of an Oracle instance?

System global area

Process monitor

Control file

Shared pool

Question 4: Which background process guarantees that committed data is saved even when the changes have not been recorded in data files?

DBWn

PMON

LGWR

CKPT

Question 5: User John has updated several rows in a table and issued a commit. What does the DBWn (database writer) process do at this time in response to the commit event?

Writes the changed blocks to data files.

Writes the changed blocks to redo log files.

Triggers checkpoint and thus LGWR writes the changes to redo log files.

Does nothing.

Question 6: Which of the following best describes a RAC configuration?

One database, multiple instances

One instance, multiple databases

Multiple databases plugged in from multiple servers

Multiple databases, multiple instances

Question 7: Which component of the SGA contains the parsed SQL code?

Database buffer cache

Dictionary cache

Library cache

Parse cache

Question 8: Which tasks are accomplished by the SMON process? (Choose all that apply.)

Performs recovery at instance startup

Performs cleanup after a user session is terminated

Starts any server process that stopped running

Coalesces contiguous free space in dictionary-managed tablespaces

Question 9: Choose the best statement from the options related to segments.

A contiguous set of blocks constitutes a segment.

A nonpartitioned table can have only one segment.

A segment can belong to more than one tablespace.

All of the above are true.

Question 10: From the following list, choose two processes that are optional in an Oracle Database 12c database.

MMON

MMNL

ARCn

MMAN

Question 11: Which SGA component will you increase or configure so that RMAN tape backups do not use memory from the shared pool?

Java pool

Streams pool

Recovery pool

Large pool

Question 12: When a user session is terminated, which processes are responsible for cleaning up and releasing locks? (Choose all that apply.)

DBWn

LGWR

MMON

PMON

Question 13: The LRU algorithm is used to manage what part of the Oracle architecture?

Users who log on to the database infrequently and may be candidates for being dropped

The data file that stores the least amount of information and will need the least frequent backup

The tables that users rarely access so that they can be moved to a less active tablespace

The shared pool and database buffer cache portions of the SGA

Question 14: Two structures make up an Oracle server: an instance and a database. Which of the following best describes the difference between an Oracle instance and a database?

An instance consists of memory structures and processes, whereas a database is composed of physical files.

An instance is used only during database creation; after that, the database is all that is needed.

An instance is started whenever the demands on the database are high, but the database is used all the time.

An instance is configured using a pfile, whereas a database is configured using a spfile.

Question 15: Which of the following is the proper order of Oracle's storage hierarchy, from smallest to largest?

Operating-system block, database block, segment, extent

Operating-system block, database block, extent, segment

Segment, extent, database block, operating-system block

Segment, database block, extent, operating-system block

Question 16: The DBA unknowingly terminated the process ID belonging to the PMON process of Oracle Database 12c database using the kill -9 command on Unix. Choose the best answer.

Oracle spawns another PMON process automatically.

The database hangs, and the DBA must manually start a PMON process.

If the database is in ARCHIVELOG mode, Oracle automatically starts another PMON process and recovers from the database hang.

The instance crashes and needs to be restarted.

Question 17: When an incremental checkpoint happens in a database, which file(s) are updated with the checkpoint position? Choose all options that are correct.

Data files

Control files

Initialization Parameter Files

Redo log files

Question 18: User Isabella updates a table and commits the change after a few seconds. Which of the following actions are happening in the database? Order them in the correct sequence and ignore the actions that are not relevant.

Oracle reads the blocks from data file to buffer cache and updates the blocks.

Changed blocks from the buffer cache are written to data files.

The user commits the change.

LGWR writes the changed blocks to the redo log buffer.

Question 19: Querying the V$LOG file shows the following information. Which redo group files are required for instance crash recovery?

Question 20:

Groups 1 through 4

Group 1

Group 1 and 4

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