Chapter 5
Improve data integrity
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
Hashed
Which type of file is easiest to update? A) Sequential B) Hashed C) Indexed D) Clustered
Default Value
The value a field will assume unless the user enters an explicit value for an instance of that field is called a: A) c. B) null value. C) range control. D) gurand.
explain plan
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
extent.
A contiguous section of disk storage space is called a(n): A) track. B) sector. C) extent. D) tablespace.
data type.
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 layout.
extra space and update time
A disadvantage of partitioning is: A) simplicity. B) remote optimization. C) extra space and update time. D) shorter technology spans.
efficient storage.
A factor to consider when choosing a file organization is: A) inefficient data retrieval. B) DDL. C) efficient storage. D) DML.
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: A) hashed file organization. B) hash key. C) multi-indexed file organization. D) hash index table
heap file organization.
A file organization where files are not stored in any particular order is considered a: A) hashed file organization. B) hash key. C) multi-indexed file organization. D) heap file organization
data replication.
A form of denormalization where the same data are purposely stored in multiple places in the database is called: A) data duplication. B) data replication. C) advanced placement. D) horizontal partitioning
selecting structures
A key decision in the physical design process is: A) ignoring the size of the database. B) selecting structures. C) deciding on the monitor. D) deciding the e-r diagrams
track missing data with special reports
A method for handling missing data is to: A) substitute with random numbers for the missing data. B) track missing data with special reports. C) perform insensitivity testing. D) delete the associated row
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: A) multiple partition queries. B) perpendicular query processing. C) parallel query processing. D) query optimization.
clustering
A method to allow adjacent secondary memory space to contain rows from several tables is called: A) cluttering. B) clustering. C) concatenating. D) compiling.
normalized relations
A requirement to begin designing physical files and databases is: A) normalized relations. B) physical tables created. C) implementation complete. D) all datatypes determined.
Pointer
A(n) ________ is a field of data used to locate a related field or record. A) key B) index C) lock D) pointer
hashing algorithm
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
file organization
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
a one-to-many relationship
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.
multivalued partitioning
All of the following are horizontal partitioning methods in Oracle EXCEPT: A) key range partitioning. B) hash partitioning. C) multivalued partitioning. D) composite partitioning
use a lot of storage space
All of the following are objectives when selecting a data type EXCEPT: A) represent all possible values. B) improve data integrity. C) support all data manipulations. D) use a lot of storage space
boolean.
All of the following are valid datatypes in Oracle 11g EXCEPT: A) varchar2. B) boolean. C) blob. D) number
efficiency.
An advantage of partitioning is: A) efficiency. B) remote optimization. C) extra space and update time. D) increase redundancy.
Blob
An appropriate datatype for adding a sound clip would be: A) VarChar. B) Char. C) Blob. D) Date.
Char
An appropriate datatype for one wanting a fixed-length type for last name would include: A) VarChar. B) Char. C) Blob. D) Date.
join index.
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
range control
An integrity control supported by a DBMS is: A) substitute estimates. B) security. C) range control. D) GUI guards.
transaction volumes
Database access frequencies are estimated from: A) transaction volumes. B) user logins. C) security violations. D) random number generation
descriptions
Designing physical files requires ________ of where and when data are used in various ways. A) maps B) descriptions C) keys D) hints
horizontal partitioning.
Distributing the rows of data into separate files is called: A) normalization. B) horizontal partitioning. C) vertical partitioning. D) file allocation.
when different categories of a table's rows are processed separately.
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 only one category is allowed
efficient data processing
In most cases, the goal of ________ dominates the design process. A) efficient data processing B) security C) quick pointer updates D) shorter design times
Physical
In which data model would a code table appear? A) Conceptual B) Logical C) Physical D) Data layout
Hashed
In which type of file is multiple key retrieval not possible? A) Sequential B) Hashed C) Indexed D) Clustered
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): A) secondary key. B) index. C) composite key. D) linked key
checking to see if missing data will greatly impact results
Sensitivity testing involves: A) checking to see if your teeth hurt when you brush. B) seeing how accurate data are. C) checking to see if missing data will greatly impact results. D) deleting the associated row.
field.
The smallest unit of application data recognized by system software is a: A) field. B) row. C) data type. D) column.
data integrity
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
Sequential
Which type of file is most efficient with storage space? A) Sequential B) Hashed C) Indexed D) Clustered
operating system
While Oracle has responsibility for managing data inside a tablespace, the tablespace as a whole is managed by the: A) user. B) CEO. C) XML. D) operating system.
tablespace.
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
Vertical
________ partitioning distributes the columns of a table into several separate physical records. A) Horizontal B) Crossways C) Vertical D) Final