chapter10

Question 1

is a special tablespace that is required to be online all the time for the database to function properly

Answer 1

SYSTEM

Question 2

is an auxiliary tablespace always created when oracle database is created

Answer 2

SYSAUX

Question 3

Contain data dictionary and tables containing administrative information about the database.

Answer 3

SYSTEM

Question 4

System tablespace of earlier version

Answer 4

SYSAUX

Question 5

SQL execution requiring temporary segments

Answer 5

TEMP tablspace

Question 6

use for storing undo information

Answer 6

UNDOTBS1

Question 7

use for storing user objects

Answer 7

users

Question 8

contain sample schema

Answer 8

Example

Question 9

note:

Answer 9

The tablespace cannot exceed 30 characters. The name should begin with an alphabetic character and can contain alphabetic characters, numeric character and the special characters #,_,$

Question 10

note2:

Answer 10

tables and indexes are examples of segments.

Question 11

tablespaces are built on a single data file

Answer 11

Bigfile

Question 12

is the new name for the old Oracle tablespace data file option

Answer 12

Smallfile

Question 13

can ease the administration of files used by an Oracle 11g database

Answer 13

Oracle Managed Files

Question 14

Defines the location of the default file system directory for data files and temporary files

Answer 14

DB_CREATE_FILE_DEST

Question 15

Defines the location for redo log files and control file creation

Answer 15

DB_CREATE_ONLINE_LOG_DEST_n

Question 16

Default location for the flash recovery area

Answer 16

DB_RECOVERY_FILE_DEST