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: 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 9: 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 10: 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 11: 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 12: 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 13: 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 14: 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 15: 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 16: What is a relational database?

A database organizing data into related tables of rows and columns

A single flat text file

A collection of unstructured images

A spreadsheet with one sheet only

Question 17: What is a primary key?

A password for the database

A column or set of columns uniquely identifying each row in a table

The first column created in a table

An index on any column

Question 18: What is a foreign key?

A key stored outside the database

An encrypted password

A column referencing the primary key of another table

A duplicate primary key

Question 19: Which SQL statement retrieves data from a database?

INSERT

DELETE

UPDATE

SELECT

Question 20: Which SQL clause filters rows based on a condition?

WHERE

ORDER BY

GROUP BY

JOIN

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