CIS 305 Chapter 5 Quiz

Blob

An appropriate datatype for adding a sound clip would be: Char. Blob. VarChar. Date.

Improve data integrity

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

Hashed

Which type of file is easiest to update? Indexed Clustered Hashed Sequential

heap file organization

A file organization where files are not stored in any particular order is considered a: heap file organization. multi-indexed file organization. hash key. hashed file organization

Physical

In which data model would a code table appear? Conceptual Data layout Logical Physical

field

The smallest unit of application data recognized by system software is a: field. data type. row. Column.

default value

The value a field will assume unless the user enters an explicit value for an instance of that field is called a: range control. gurand. null value. default value.

Sequential

Which type of file is most efficient with storage space? Hashed Indexed Clustered Sequential

extent

A contiguous section of disk storage space is called a(n): track. extent. tablespace. Sector.

data type

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

extra space and update time

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

efficient storage

A factor to consider when choosing a file organization is: DML. efficient storage. DDL. inefficient data retrieval.

hash index table

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: hashed file organization. hash index table. multi-indexed file organization. hash key.

selecting structures

A key decision in the physical design process is: ignoring the size of the database. deciding the e-r diagrams. selecting structures. deciding on the monitor.

track missing data with special reports

A method for handling missing data is to: perform insensitivity testing. substitute with random numbers for the missing data. delete the associated row. track missing data with special reports.

parallel query processing

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

clustering.

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

normalized relations

A requirement to begin designing physical files and databases is: implementation complete. all datatypes determined. normalized relations. physical tables created.

pointer

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

hashing algorithm

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

file organization

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

use a lot of storage space

All of the following are objectives when selecting a data type EXCEPT: support all data manipulations. represent all possible values. use a lot of storage space. improve data integrity.

boolean

All of the following are valid datatypes in Oracle 11g EXCEPT: blob. number. varchar2 boolean.

efficiency

An advantage of partitioning is: extra space and update time. remote optimization. efficiency. increase redundancy.

Char

An appropriate datatype for one wanting a fixed-length type for last name would include: Date. Blob. VarChar. Char.

join index

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

range control

An integrity control supported by a DBMS is: substitute estimates. GUI guards. security. range control.

transaction volumes

Database access frequencies are estimated from: random number generation. user logins. transaction volumes. security violations.

Descriptions

Designing physical files requires ________ of where and when data are used in various ways. keys maps hints Descriptions

when different categories of a table's rows are processed separately.

Horizontal partitioning makes sense: when partitions must be organized the same. when only one category is allowed. when different categories of a table's rows are processed separately. when less security is needed.

Hashed

In which type of file is multiple key retrieval not possible? Clustered Hashed Indexed Sequential

secondary key

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

checking to see if missing data will greatly impact results.

Sensitivity testing involves: checking to see if your teeth hurt when you brush. seeing how accurate data are. checking to see if missing data will greatly impact results. deleting the associated row.

data integrity

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

operating system.

While Oracle has responsibility for managing data inside a tablespace, the tablespace as a whole is managed by the: user. operating system. CEO. XML.

tablespace

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

Vertical

________ partitioning distributes the columns of a table into several separate physical records. Crossways Horizontal Vertical Final