Exam 5: Basic Storage Concepts and Settings

Multiple temporary tablespaces require a tablespace ____________________.

You can drop an undo tablespace by using the ____________________ TABLESPACE command.

Before creating a tablespace with a nonstandard block size,you are required to create a(n)____ with a matching block size.

In Oracle 10g,segments are created automatically when they are needed.

When you use ____,you allow the database to determine the actual names of datafiles.

A segment cannot be spread among several datafiles.

The ____ directory in ORACLE_BASE / admin contains background dump trace files,including the alert log and background process trace files.

You can look at the ____ parts of an Oracle database within the operating system

You cannot create a datafile without an associated tablespace.

The ____ view contains information on data extents in all tablespaces.

There is no direct correlation between a schema object and a datafile.

____ segments are created during execution of SQL that needs space to perform sorting or other operations.

The second largest logical structure is a(n)____.

____ extents are automatically coalesced with any neighboring free space.

A datafile can be associated with multiple tablespaces within one database.

The primary purpose of a read-only tablespace is to make large amounts of static data available to the database without having to slow down the database backup and recovery or the need for logging and checkpointing.

The ____ is made up of the memory (SGA)and the background processes.

____ contain redo entries that record changes to the database to allow recovery of changed data.

A(n)____ is the smallest of the logical units.

A(n)____ tablespace is an advanced Oracle 10g feature used to transport tablespaces between different databases,even different platforms and operating systems.