Deck 5: Basic Storage Concepts and Settings

Question 1

The size of an operating system block is 8 bytes.

Answer 1

False

Question 2

The contents of the datafiles are stored in encrypted and specialized record structures readable only by the Oracle 10g database.

Answer 2

True

Question 3

Data blocks are made up of one or more operating system blocks,depending on the size of each type of block.

Answer 3

True

Question 4

You cannot create a datafile without an associated tablespace.

Question 5

A database may not contain a large number of tablespaces.

Question 6

In an Oracle database,logical structures are generally associated with one or more physical structures.

Question 7

Logical structures can be viewed or modified outside the database (from the operating system).

Question 8

The storage capacity of a tablespace is the sum of the size of all the datafiles assigned to that tablespace.

Question 9

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

Question 10

A tablespace is a physical structure.

Question 11

The data dictionary views primarily display metadata.

Question 12

A segment cannot be spread among several datafiles.

Question 13

There is a direct correlation between a segment and a datafile.

Question 14

Datafiles are the primary physical structure that contain all the data you store in the database.

Question 15

Extents always belong to one datafile.

Question 16

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

Question 17

Extents can be different sizes,depending on the storage parameters set for the object or the tablespace.

Question 18

A datafile can be made up of several fragmented sections in different locations on the operating system.

Question 19

After a database is created,you cannot change the block size without re-creating the database.

Question 20

You can create a tablespace before creating its initial datafile.

Question 21

Each ____ belongs to one schema object.

A) table
B) tablespace
C) segment
D) extent

Question 22

____ contain the names and locations of all the datafiles and redo log files.

A) Redo log files
B) Redo log groups
C) Archive log files
D) Control files

Question 23

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

A) physical
B) logical
C) metadata
D) server

Question 24

Each index has one index segment.

Question 25

The ____ is made up of database files,control files,and redo log files.

A) tablespace
B) datafile
C) database
D) instance

Question 26

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

A) tablespace
B) datafile
C) database
D) instance

Question 27

The freelist is the same as the free space in a datafile.

Question 28

A(n)____ is a contiguous group of data blocks that are assigned to a segment.

A) table
B) tablespace
C) schema object
D) extent

Question 29

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

A) segment
B) database block
C) schema object
D) extent

Question 30

You may only perform one task per ALTER TABLESPACE command.

Question 31

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

A) Redo log files
B) Redo log groups
C) Archive log files
D) Control files

Question 32

The extent management mode can be changed using the ALTER TABLESPACE command.

Question 33

The biggest issue with using locally managed tablespaces is one of performance.

Question 34

Index segments are allowed in temporary tablespaces.

Question 35

Dropping a temporary tablespace is the same as dropping a permanent tablespace.

Question 36

A ____ is a physical file on the computer.

A) metadata
B) table
C) datafile
D) tablespace

Question 37

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

Question 38

A(n)____ is the largest logical object.

A) table
B) tablespace
C) segment
D) extent

Question 39

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.

Question 40

All critical errors need to be sent to the trace files.

Question 41

____ segments are allowed in undo tablespaces (if automatic undo management)or any permanent tablespace (if manual undo management).

A) Data
B) Rollback
C) Index
D) Temporary

Question 42

A ____ is a small record in the datafile header with one bit for each data block number that marks the beginning of a used group,or a free group,of consecutive blocks in the datafile.

A) data block
B) block
C) bitmap
D) byte

Question 43

The EXTENT MANAGEMENT and ____ MANAGEMENT clauses of the CREATE TABLESPACE command tell Oracle 10g how to track the usage of blocks within each extent.

A) EXTENT SPACE
B) SEGMENT SPACE
C) SCHEMA SPACE
D) BLOCK SPACE

Question 44

A data block is typically ____.

A) 4KB
B) 8KB
C) 16KB
D) 32KB

Question 45

A smallfile tablespace can contain ____ datafiles.

A) 12
B) 22
C) 122
D) 1022

Question 46

____ extents are automatically coalesced with any neighboring free space.

A) Segmented
B) Contiguous
C) Deallocated
D) Joined

Question 47

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

A) cache space
B) schema object
C) segment
D) extent

Question 48

Tablespaces are ____-managed by default.

A) locally
B) dictionary
C) remotely
D) distributively

Question 49

A ____-managed tablespace has a bitmap in the header of the tablespace that stores all the details about free space,used space,and location of extents.

A) locally
B) dictionary
C) remotely
D) distributively

Question 50

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

A) table
B) tablespace
C) segment
D) extent

Question 51

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

A) OMF
B) OFA
C) RAC
D) SQL*Plus

Question 52

A data block can't be smaller than ____ or larger than 32KB.

A) 1KB
B) 2KB
C) 4KB
D) 8KB

Question 53

The initialization parameter ____ contains the default or standard block size.

A) DB_BLOCK_SIZE
B) DB_BLOCK
C) DB_BLOCKS
D) DB_DATABLOCK

Question 54

Changes to data are written to datafiles by the ____ background process.

A) LGWR
B) LDWR
C) DFWn
D) DBWn

Question 55

The CREATE TABLESPACE ____ option indicates that the tablespace is allowed to automatically grow.

A) EXTEND
B) GROW
C) AUTOEXTEND
D) AUTOGROW

Question 56

When creating a tablespace,the ____ option allows creation of very large permanent or temporary tablespaces,with a single very large datafile.

A) EXTRAFILE
B) LARGEFILE
C) BIGFILE
D) HUGEFILE

Question 57

Undo tablespaces are specialized to store undo (____)data.

A) metadata
B) temporary
C) logical
D) rollback

Question 58

Dictionary-managed tablespaces have a problem that causes slower performance of ____ commands.

A) SQL
B) PL / SQL
C) UML
D) DML

Question 59

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

A) Data
B) Rollback
C) Index
D) Temporary

Question 60

A ____-managed tablespace stores the details about its free space and other information inside the data dictionary tables,in the SYSTEM tablespace.

A) locally
B) dictionary
C) remotely
D) distributively

Question 61

An operating system ____________________ is made up of a group of contiguous bytes within the file.

Question 62

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

A) online
B) rollback
C) transportable
D) temporary

Question 63

When you take a tablespace offline,there are ____ methods you can specify for Oracle 10g's execution of the command.

A) two
B) three
C) four
D) five

Question 64

If your tablespace keeps running out of space,you may want to modify the ____ setting.

A) DEFAULT STORAGE
B) AUTOEXTEND
C) MINIMUM EXTENT
D) LOGGING

Question 65

The utility ____ reads trace files and loads the data into a readable file or even loads it into a database table so you can query the results.

A) TRACERT
B) TKPROF
C) LGTR
D) LGWR

Question 66

A(n)____ uniquely identifies each row in a table.

A) primary key
B) foreign key
C) constraint
D) index

Question 67

Trace files can be found in both the bdump and ____ directories.

A) bdump
B) gdump
C) cdump
D) udump

Question 68

A(n)____ contains a copy of a primary key value from a parent table.

A) clone key
B) foreign key
C) constraint
D) index

Question 69

____________________ structures are composed of orderly groupings of information that allow you to manipulate and access related data.

Question 70

The DROP option is required if you take a datafile offline when your database is in ____ mode.

A) NOARCHIVELOG
B) NOLOGGING
C) TEMPORARY
D) IMMEDIATE

Question 71

Undo data is made up of ____ blocks.

A) file
B) contiguous
C) data
D) undo

Question 72

____ is the default status for a new tablespace.

A) TEMPORARY
B) IMMEDIATE
C) ONLINE
D) OFFLINE

Question 73

Each tablespace contains one or more ____________________.

Question 74

Tables,indexes,and other objects are created within a(n)____________________.

Question 75

The ____ view contains information on free extents within all tablespaces.

A) DBA_FREE_SPACE
B) DBA_EXTENTS
C) DBA_USERS
D) DBA_TEMP_FILES

Question 76

The table containing the list of each table's columns,their data types,lengths,and so on,is a table of ____________________.

Question 77

The ____ view contains details on default and temporary tablespaces assigned to all users.

A) DBA_FREE_SPACE
B) DBA_EXTENTS
C) DBA_USERS
D) DBA_TEMP_FILES

Question 78

To modify a tempfile,you can use the ____ command.

A) ALTER DATABASE
B) ALTER TEMPFILE
C) ALTER DATABASE TEMPFILE
D) ALTER TABLESPACE TEMPFILE

Question 79

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

A) bdump
B) gdump
C) cdump
D) udump

Question 80

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

A) DBA_FREE_SPACE
B) DBA_EXTENTS
C) DBA_USERS
D) DBA_TEMP_FILES