DBMS Chapter 5 QUIZ

A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers and join tables to prepare query results is the: A) explain plan. B) show optimization. C) explain query. D) analyze query.

A

An advantage of partitioning is: A) efficiency. B) remote optimization. C) extra space and update time. D) both A and B.

A

Database access frequencies are estimated from: A) transaction volumes. B) user logins. C) security violations. D) none of the above

A

The smallest unit of application data recognized by system software is a: A) field. B) row. C) data type. D) column.

A

Horizontal partitioning makes sense: A) when different categories of a table's rows are processed separately. B) when less security is needed. C) when partitions must be organized the same. D) when all of the above are true

A

In most cases the goal of ________ dominates the design process. A) efficient data processing B) security C) quick pointer updates D) shorter design times

A

One field or combination of fields for which more than one record may have the same combination of values is called a(n): A) secondary key. B) index. C) composite key. D) linked key.

A

Which type of file is most efficient with storage space? A) Sequential B) Hashed C) Indexed D) Clustered

A

A detailed coding scheme recognized by system software for representing organizational data is called a(n): A) DBMS code. B) data type. C) SQL. D) DB layouts.

B

A key decision in the physical design process is: A) knowing the user base. B) selecting structures. C) deciding on the monitor. D) all of the above.

B

A method to allow adjacent secondary memory space to contain rows from several tables is called: A) cluttering. B) clustering. C) concatenating. D) compiling.

B

All of the following are common denormalization opportunities EXCEPT: A) two entities with a one-to-one relationship. B) a one-to-many relationship. C) a many-to-many relationship with nonkey attributes. D) reference data.

B

All of the following are valid datatypes in Oracle 11g EXCEPT: A) varchar2. B) booolean. C) blob. D) number.

B

Another form of denormalization where the same data are stored in multiple places in the database is called: A) data duplication. B) data replication. C) advanced placement. D) horizontal partitioning.

B

Designing physical files requires ________ of where and when data are used in various ways. A) maps B) descriptions C) keys D) hints

B

Distributing the rows of data into separate files is called: A) normalization. B) horizontal partitioning. C) vertical partitioning. D) file allocation.

B

In which type of file is multiple key retrieval not possible? A) Sequential B) Hashed C) Indexed D) Clustered

B

Which type of file is easiest to update? A) Sequential B) Hashed C) Indexed D) Clustered

B

) Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n): A) extent. B) table. C) tablespace. D) partition.

C

A contiguous section of disk storage space is called a(n): A) track. B) sector. C) extent. D) tablespace.

C

A disadvantage of partitioning is: A) simplicity. B) remote optimization. C) extra space and update time. D) shorter technology spans

C

A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called: A) multiple partition queries. B) perpendicular query processing. C) parallel query processing. D) query optimization

C

A(n) ________ is a routine that converts a primary key value into a relative record number. A) record index calculator B) index pointer program C) hashing algorithm D) pointing algorithm

C

A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices. A) physical pointer B) retrieval program C) file organization D) update program

C

All of the following are horizontal partitioning methods in Oracle EXCEPT: A) key range partitioning. B) hash partitioning. C) multivalued partitioning. D) composite partitioning

C

An index on columns from two or more tables that come from the same domain of values is called a: A) bitmap index. B) multivalued index. C) join index. D) transaction index

C

An integrity control supported by a DBMS is: A) substitute estimates. B) security. C) range control. D) GUI guards.

C

In which data model would a code table appear? A) Conceptual B) Logical C) Physical D) Data layout

C

Sensitivity testing involves: A) checking to see if you teeth hurt when you brush. B) seeing how accurate data are. C) checking to see if missing data will greatly impact results. D) none of the above.

C

The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space. A) query design B) programmer productivity C) data integrity D) data integration

C

________ partitioning distributes the columns of a table into several separate physical records. A) Horizontal B) Crossways C) Vertical D) Final

C

A factor to consider when choosing a file organization is: A) fast data retrieval. B) security. C) efficient storage. D) all of the above.

D

A file organization that uses hashing to map a key into a location in an index where there is a pointer to the actual data record matching the hash key is called a: A) hashed file organization. B) hash key. C) multi-indexed file organization. D) hash index table.

D

A method for handling missing data is to: A) substitute and estimate for the missing data. B) track missing data with special reports. C) perform sensitivity testing. D) all of the above.

D

A requirement to begin designing physical files and databases is: A) normalized relations. B) definitions of each attribute. C) technology descriptions. D) all of the above.

D

A rule of thumb for choosing indexes is to: A) be careful indexing attributes that may be null. B) index each primary key of each table. C) use an index when there is variety in attribute values. D) all of the above.

D

A(n) ________ is a field of data used to locate a related field or record. A) key B) index C) lock D) pointer

D

Which of the following is an objective of selecting a data type? A) Represent a small number of possible values B) Maximize storage space C) Limit security D) Improve data integrity

D

While Oracle has responsibility for managing data inside a tablespace, the tablespace as a whole is managed by the: A) user. B) database administrator. C) application developer. D) operating system.

D