Exam 4: Oracle Physical Architecture and Data Dictionary Views

____ handles the names and locations of files created in association with the database.

Partitioning allows individual tables and their associated indexes to be split into separate physical chunks.

Used memory buffers are called ____________________ buffers.

____ contain historical copies of recycled redo logs,maintaining a complete history of all database change activity.

Tablespaces can be transported across different platforms and operating systems.

____ contain transaction records of all database changes.

What is the purpose of redo log files?

You must multiplex the control file to ensure against total loss of the file.

____________________ occur during database shutdown,during a redo log switch (occurs when one redo log file is filled,and the next in the sequence is switched to),and when one is forced by an ALTER SYSTEM CHECKPOINT command.

The control file contains up-to-date information on the database structure,log files,and checkpoints.

The ____ clause of the CREATE CONTROLFILE command tells Oracle 10g to read the log files and save their settings from the last time they were used.

____ means making redundant copies of files to guarantee that if the original file is damaged,another can take its place immediately.

The status of a redo log group can be CLEARING_CURRENT if it is in the process of being re-created after the ALTER DATABASE CLEAR LOGFILE command has been used.

Checkpoints can be made to recover up to a specific time or ____.

A database should have at least five redo log groups containing at least one file each.

You cannot recreate a control file from scratch.

The users SYS and SYSTEM are the default DBA users.

The prefix ____ is used for dynamic performance views.

Data dictionary views can be updated.

____ partitioning splits a table based on specific lists of values.