Deck 8: Advanced Table Management

Question 1

VARRAYs LOB can be in a different tablespace than the table.

Answer 1

False

Question 2

A good use for index-organized tables is a table in which most of the columns are indexed within the primary key of the table and the data that is not part of the primary key is relatively small and static.

Answer 2

True

Question 3

It is a prerequisite for efficiency that an index-organized table contain only static data.

Answer 3

False

Question 4

From a performance tuning perspective,caching LOB objects is not sensible unless your application uses very small objects,such as iconic images.

Question 5

Because of their potentially huge size,Oracle 10g has special storage methods for LOBs.

Question 6

When copying an external LOB,only the pointer to the location of the file is actually copied;the original file is not copied.

Question 7

The BFILE data is stored inside the database.

Question 8

An index-organized table indexes all columns in a table.

Question 9

Subjected to constant DML change activity,an index-organized table will deteriorate more rapidly than a regular BTree index.

Question 10

The BLOB,CLOB,and NCLOB datatypes all have their data stored outside the database.

Question 11

Procedures and functions in the DBMS_LOB package are all standard programming structures,used to open,close,read,and write files,along with various other activities.

Question 12

You cannot include LOB columns in index-organized tables.

Question 13

An index-organized table does not have an index.

Question 14

When creating a relational table with a BLOB column,naming the LOB data segment is optional.

Question 15

You should use LOB storage for VARRAYs,when the VARRAY is intended to be very large.

Question 16

If you copy an external LOB from one row or column to another,the entire LOB-including its data-is copied to the new location.

Question 17

Many portions of the storage structure of a table can be modified after the table is created.

Question 18

When storing LOB values out of line,Oracle 10g allocates space by data blocks,rather than by chunks.

Question 19

When deallocating space,the data blocks that are below the high watermark are released back to the database.

Question 20

A BTree index balances data in even branches that split into narrowing ranges of key values.

Question 21

The LOB datatypes are divided into ____ groups,according to where they are stored.

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

Question 22

Oracle 10g introduced encryption of data within the confines of an Oracle database,preventing potential snooping into datafiles from outside the confines of Oracle database software.

Question 23

The BFILE datatype is a(n)____ LOB.

A) internal
B) external
C) auxiliary
D) dummy

Question 24

Moving a row changes its ROWID.

Question 25

There is a special ____ package called DBMS_LOB,used to simplify the manipulation of data in LOB columns.

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

Question 26

The LOGGING clause suppresses the creation of redo log entries for some DDL commands,and some DML commands against the table,and for mass insert commands,such as those run by SQL*Loader.

Question 27

The CREATE TABLE and ALTER TABLE commands can both be used to encrypt table data at the column level.

Question 28

Internal LOBs use ____ semantics.

A) value
B) reference
C) copy
D) write

Question 29

A LOB column has one of ____ datatypes.

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

Question 30

When dropping a table it will automatically be saved in the Oracle 10g database recycle bin.

Question 31

Index-organized tables help you query table rows more quickly by reducing the number of times a process must read either memory or disk to retrieve the row data,when rows are read according to the ____.

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

Question 32

The ____ datatype is for pointers to an externally stored multimedia file.

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

Question 33

External LOBs use ____ semantics.

A) value
B) reference
C) copy
D) write

Question 34

There is more to the FLASHBACK TABLE command than simply recovering tables from the recycle bin.

Question 35

When little or no down time is available for database maintenance,you can use the DBMS_REDEFINTION for tables in the high-demand system.

Question 36

Upgrading a table structure causes any object types used in the table to be updated with the most recent version of the object type definition.

Question 37

By default the CASCADE CONSTRAINTS and PURGE option are included in a DROP TABLE.

Question 38

The NCLOB datatype is equivalent to the CLOB datatype,but for using ____.

A) ASCII
B) EBCDIC
C) XML
D) Unicode

Question 39

An example of a ____ table could be a table used to look up the population of a city by its state,county,and municipal code.

A) static
B) semi-static
C) dynamic
D) fully dynamic

Question 40

The USER_TAB_PRIVS_MADE dictionary view lists table privileges granted by the current user on tables owned by the current user

Question 41

The pointer that directs the database to the actual location of the value is called the ____ locator for external LOBs.

A) internal
B) external
C) BFILE
D) LOB

Question 42

____ was created for high-availability applications,such as online airline reservations or online banking services.

A) DBMS_REDEFINITION
B) DBMS_LOB
C) DBMS_STATS
D) DBMS_ONLINE

Question 43

In an index-organized table every row is stored in a(n)____ index structure.

A) heap
B) LOB
C) advanced
D) BTree

Question 44

If you are sure you do not need the data and want to remove thousands or millions of rows quickly,you can use the ____ command.

A) REMOVE
B) EMPTY
C) TRUNCATE
D) DELETE

Question 45

A(n)____________________ with LOB columns can store huge amounts of data in a single column.

Question 46

Large-sized files can be loaded into a(n)____________________ record in the database,where they are protected from unauthorized use and possible theft or damage.

Question 47

When creating a relational table with a BLOB column,the ____ parameter sets the number of bytes allocated for working with the LOB value.

A) CHUNK
B) LOB
C) STORAGE
D) STORE AS

Question 48

When using transparent table encryption,a random string called a ____ string is added to the column in clear text prior to encryption.

A) RANDOM
B) RAND
C) SALT
D) DUMMY

Question 49

Sometimes,Oracle 10g stores an internal LOB's value within the row (____).

A) view
B) reference
C) inline
D) copy

Question 50

When creating a relational table with a BLOB column,the ____ parameter tells Oracle 10g to place the LOB values into the data buffer for faster retrieval of frequently accessed data.

A) CHUNK
B) RETENTION
C) STORAGE
D) CACHE

Question 51

The large majority of relational data is stored in ____ tables.

A) schema
B) index-organized
C) heap-organized
D) LOB

Question 52

A(n)____ table is a relational table with a primary key,in which the rows are stored physically in order of the primary key.

A) relational
B) index-organized
C) heap-organized
D) LOB

Question 53

When you set ____ for a table,data blocks read are placed in the "most recently used" section of the buffer.

A) LOGGING
B) BUFFER
C) LOG
D) CACHE

Question 54

The CLOB datatype is a(n)____________________ large object,for storing text strings.

Question 55

The BLOB datatype is a binary ____________________.

Question 56

Unless you specify that all LOB values must be stored out of line,Oracle 10g stores LOB values that are less than ____-byte-long inline.

A) 1000
B) 2000
C) 4000
D) 8000

Question 57

There is now only one type of optimizer available to Oracle 10g: ____-based optimization.

A) rule
B) cost
C) plan
D) auto

Question 58

The BLOB,CLOB,and NCLOB datatypes are called ____________________ LOBs.

Question 59

It is possible to remove all the rows from a table by typing:
____ FROM ;

A) TRUNCATE
B) DELETE
C) DROP
D) REMOVE

Question 60

The pointer that directs the database to the actual location of the value is called the ____ locator for internal LOBs.

A) internal
B) external
C) BFILE
D) LOB

Question 61

Object tables and object-type columns are based on the definition of a(n)____________________.

Question 62

SCN stands for ____________________.

Question 63

A relational table with a primary key constraint automatically has a unique ____________________ associated with the primary key.

Question 64

You can remove all the rows in a table without generating redo log entries by using the ____________________ command.

Question 65

The large majority of relational data is stored in ____________________-organized tables because it is the default format used by Oracle 10g for relational tables (and for many other database engines).

Question 66

When an internal LOB is stored out of line,a separate LOB data ____________________ is created.

Question 67

LONG and ____________________ are deprecated.

Question 68

A query ____________________ is a list of steps taken to retrieve data for a query.

Question 69

To analyze a table,you can use either the ____________________ command or the DBMS_STATS predefined package.

Question 70

Index-organized tables tend to have smaller-sized rows (than tables with LOBs)that benefit from a consolidation of the table's ____________________ storage and the table's data storage.

Question 71

Executing a(n)____________________ command that removes all the table's rows causes Oracle 10g background processes to write undo records and redo log entries for each row deleted.

Question 72

You can partition index-organized tables,but only using ____________________ or range partitioning.

Question 73

You can remove all the table's rows along with the table structure by using the ____________________ TABLE command.

Question 74

A non index-organized table is also called a heap-organized or ____________________ table.

Question 75

The index of a relational table is stored in primary key order in a(n)____________________ index structure,making queries by primary key very fast.

Question 76

The DBA_RECYCLEBIN and ____________________ metadata views can be used to display the contents of all recycle bins,for all users,or a specifically connected user recycle bin.

Question 77

____________________-based optimization uses statistics on the actual volume and distribution of table data to determine the best path to retrieve the data,taking into account the relative costs of I / O,CPU time,execution time,and other factors.

Question 78

The high ____________________ is the boundary between used data blocks and unused data blocks in a table.

Question 79

A dropped table,saved to the recycle bin,can be recovered to its state prior to being dropped using a(n)____________________ TABLE command.

Question 80

Oracle 10g has a feature called _________________________,allowing you to make nearly any change to a table you need,while keeping the table available for inserts and updates most of the time.