Oracle DBA Quiz 01

Oracle consists of 3 types of physical files. Which files are the correct answer?

• Data files

• Control files

• Redo files

• Redo Log files

System Global Area (SGA) is a shared memory area.

• True

• False

The database buffer cache is the area of memory that...

• caches user data, holding blocks from files that have been read recently.

• caches database data, holding blocks from redo log files that have been read recently.

• caches database data, holding blocks from control files that have been read recently.

• caches database data, holding blocks from data files that have been read recently.

Before a user can look at a piece of information in Oracle Database, it must first reside in database buffer cache.

• True

• False

There are 3 types of buffers, which are...

• Dark

• Dirty

• Free

• Pinned

What is the mechanism that Oracle used to remove data from DB cache?

• First Come First Serve (FCFS)

• Least Recently Used (LRU)

• Short Process Next (SPN)

Redo log buffer is a circular buffer in SGA that holds information about changes made to data.

• True

• False

Data dictionary cache is a...

• collection of tables and views containing data about the data, its structure, its privilege and its users.

• collection of database and containing metadata about the data, its data structure, its privilege and its users.

• collection of database tables and views containing metadata about the database, its structure, its privilege and its users.

Library cache is used for maintaining recently executed SQL commands.

• Yes

• No

What algorithm that Oracle used to insert data to database buffer cache?

• First Come First Serve (FCFS)

• Least Recently Used (LRU)

• Short Process Next (SPN)

• Most Recently Used (MRU)