Deck 7: Basic Table Management

Question 1

Partitioned tables can store each partition in a separate tablespace.

Answer 1

True

Question 2

Index-organized tables cannot be partitioned.

Answer 2

False

Question 3

Clusters speed up the access to sets of tables that are frequently referenced together.

Answer 3

True

Question 4

When you create a table you cannot define the storage settings of the table.

Question 5

A null column followed by one or more columns with data must have a placeholder.

Question 6

All full table scans by queries read the entire table,including any deleted extents,ultimately leading to poor performance.

Question 7

In an index-organized table the entire table is an index.

Question 8

Locally managed tables eliminate much of the work in managing storage space.

Question 9

Chaining and migrating of row data increases database performance.

Question 10

All tables must have a primary key.

Question 11

Access by ROWID is probably the fastest and most reliable method of data retrieval.

Question 12

Tables can be partitioned to store large quantities of data and increase performance of access to that data.

Question 13

A row that spans multiple blocks is called a multi-row.

Question 14

Temporary tables use temporary segments in either a temporary tablespace or a permanent tablespace.

Question 15

Tablespace parameters cannot be overridden by setting them when you create a table.

Question 16

For a locally managed tablespace with uniform extent size,storage settings such as NEXT will be ignored when overridden for a table in that tablespace.

Question 17

When a row is dropped in a table,the row directory shrinks.

Question 18

A query cannot execute against a single partition.

Question 19

After a table is defined,you can use SQL to add data to the table.

Question 20

Locally managed tablespaces handle free space using a bitmap within the tablespace.

Question 21

One ____ in a row contains one field of data for one record.

A) column
B) database
C) segment
D) tablespace

Question 22

____ are programmed processes stored with the object type's definition.

A) Scripts
B) Functions
C) Methods
D) Procedures

Question 23

A nested table is a fixed length array,such that the number of elements is known,and relatively constant.

Question 24

A(n)____ is a column or set of columns that uniquely identify each row.

A) segment
B) partition
C) primary key
D) index

Question 25

Unlike working with permanent tables,adding or changing data in a temporary table does not generate undo log entries;however,it does generate redo log entries.

Question 26

A table can contain zero or more columns.

Question 27

SQL*Plus is limited in its ability to execute high-level database administration functionality,such as starting up and shutting down a database.

Question 28

You must create an object type that has the design you want to use for your object table before actually creating the object table.

Question 29

A ____ is the basic storage unit for data in the Oracle 10g database.

A) table
B) tablespace
C) database
D) datatype

Question 30

VARRAYs cannot be indexed.

Question 31

One ____ in a table contains data for one record.

A) column
B) row
C) segment
D) tablespace

Question 32

____ tables contain data in a file outside the database,such as in a text file.

A) External
B) Global
C) Cluster
D) Temporary

Question 33

A(n)____ table holds objects and attributes of those objects.

A) index-organized
B) object
C) external
D) relational

Question 34

A(n)____ table is a table where the primary key contains both the index and the data (non-indexed columns in the table).

A) index-organized
B) object
C) external
D) relational

Question 35

The traditional way of looking at metadata is using metadata and data dictionary views.

Question 36

A(n)____ table is the standard table traditionally used in a relational database.

A) index-organized
B) object
C) external
D) relational

Question 37

The user-defined datatype can be any collection of the other datatypes you want assembled into its own datatype.

Question 38

The CREATE ____ command is used to create a temporary table.

A) TABLE
B) TEMP TABLE
C) TEMPORARY TABLE
D) GLOBAL TEMPORARY TABLE

Question 39

Two sessions cannot use the same temporary table at the same time.

Question 40

A nested table must contain a single column of either a built-in data type,or a collection type data type.

Question 41

____ tables contain data that is stored within a single column of another table.

A) Cluster
B) External
C) Nested
D) XML

Question 42

Each ____ represents a group of bytes in the physical file.

A) segment
B) tablespace
C) data block
D) cluster

Question 43

A ____ stores the number of columns contained in the column data area,some overhead,and the ROWID pointing to a chained or migrated row (if any).

A) row header
B) ROWID
C) row tag
D) chained row

Question 44

There are two formats for the physical ROWID: extended ROWID and ____ ROWID.

A) restricted
B) standard
C) logical
D) basic

Question 45

The default block size is ____ bytes,determined on database creation.

A) 1024
B) 2047
C) 4096
D) 8192

Question 46

It is generally better to keep extent sizes the same or multiples of the same size within the ____ so that any deallocated free space can be more readily used later on.

A) row
B) segment
C) tablespace
D) data block

Question 47

Clusters store data of multiple tables in one ____.

A) row
B) column
C) segment
D) tablespace

Question 48

A ____ contains the physical or logical address of the row.

A) row header
B) ROWID
C) row tag
D) chained row

Question 49

____ tells Oracle 10g when to allow more rows to be inserted into the block after the deletion of rows from a block.

A) INITRANS
B) PCTUSED
C) PCTINCREASE
D) PCTFREE

Question 50

The ____ contains information about the table that has data in a particular data block.

A) table directory
B) common header
C) variable header
D) row directory

Question 51

The ____ is a list of row identifiers for rows stored in a data block.

A) table directory
B) common header
C) variable header
D) row directory

Question 52

To prevent row migration,you can adjust two storage parameters to suit the characteristics of your table's data: PCTFREE and ____.

A) INITRANS
B) PCTUSED
C) PCTINCREASE
D) FREELIST

Question 53

A ____ is a special type of ROWID for clustered tables.

A) CLUSID
B) CLUSKEY
C) cluster ID
D) cluster key ID

Question 54

The ____ are bytes of storage used for rows inserted or updated in a data block.

A) row data
B) free space
C) chained rows
D) segments

Question 55

____ tells Oracle 10g how much free space to reserve for updates to existing rows.

A) INITRANS
B) PCTUSED
C) PCTINCREASE
D) PCTFREE

Question 56

Technically,a ____ is not a table,but a group of tables stored together as if they were one table.

A) partition
B) cluster
C) nested table
D) block

Question 57

The default value for INITRANS is 1 for tables and ____ for indexes.

A) 0
B) 2
C) 3
D) 4

Question 58

A(n)____ ROWID identifies a row by its primary key in an index-organized table.

A) physical
B) logical
C) extended
D) restricted

Question 59

The ____ of a data block shrinks as rows are inserted or updated with more data,causing both the row directory and the row data to consume more space.

A) table directory
B) row directory
C) free space
D) row data

Question 60

Oracle 10g allows the physical splitting of table data into separated sections called ____.

A) segments
B) tablespaces
C) clusters
D) partitions

Question 61

An object table is ____ when you insert records into the table.

A) populated
B) instantiated
C) updated
D) incremented

Question 62

You should use a(n)____________________ table when the data is retrieved by primary key values or ranges of primary key values.

Question 63

The two types of embedded tables are called VARRAYs and ____ tables.

A) nested
B) complex
C) hierarchical
D) embedded

Question 64

The ____ datatype contains valid dates that range from January 1,4712 B.C.to December 31,9999 A.D.

A) DATE
B) SYSDATE
C) TIMESTAMP
D) TIME

Question 65

When you create a table,you define the table's name as well as each column's name,____________________,and size.

Question 66

____________________ tables are read-only,require read and write privileges in the directory created within,and can be created and loaded using an AS subquery clause.

Question 67

The ____ datatype is a text string with variable length up to 4000 bytes.

A) CHAR
B) NCHAR
C) CHAR2
D) VARCHAR2

Question 68

Tables are made up of rows and ____________________.

Question 69

A(n)____________________ stores data of all types and is the most common form of storage in the database.

Question 70

To use ____ partitioning,you set up a distinct list of partitioning key values and define which values go into each partition.

A) list
B) hash
C) range
D) key

Question 71

The default display format for DATE is ____.

A) MM-DD-YYYY
B) DD-MM-YY
C) DD-MM-YYYY
D) DD-MMM-YYYY

Question 72

You can partition any table except one that is part of a ____.

A) partition
B) segment
C) cluster
D) tablespace

Question 73

The ____ datatype stores unstructured data in binary format.

A) LOB
B) BLOB
C) CLOB
D) NCLOB

Question 74

The ____ datatype stores pointers to an external file,such as an audio track.

A) RAW
B) BLOB
C) BFILE
D) REF

Question 75

A(n)____ is a calculation producing an integer for a particular value of a string.

A) raw value
B) index
C) VARRAY
D) hash value

Question 76

A table resides in a single tablespace unless it is ____________________.

Question 77

The ____ is a new Oracle 10g feature for deleting objects but allowing for later retrieval.

A) rollback and recovery
B) temporary tablespace
C) recycle bin
D) VARRAY

Question 78

With ____ partitioning,you are actually partitioning the data and then partitioning the data within each partition.

A) composite list-hash
B) composite range-hash
C) subpartitioning
D) bipartitioning

Question 79

____ are rules that define data integrity for a column or group of columns.

A) Raw date
B) Optimizers
C) Constraints
D) Restrictions

Question 80

The ____ runs on a database server through an HTTP protocol and could have security issues.

A) Enterprise Manager
B) Database Control
C) SQL*Plus
D) SQL*Plus Worksheet