Modern Database Management - Chapter 5 Quiz
Answer: TRUE
Fast data retrieval is one factor to consider when choosing a file organization for a particular database file.
Answer: FALSE
Free range partitioning is a type of horizontal partitioning in which each partition is defined by a range of values for one or more columns in the normalized table.
Answer: TRUE
Hash partitioning spreads data evenly across partitions independent of any partition key value.
Answer: FALSE
Horizontal partitioning is very different from creating a supertype/subtype relationship.
when different categories of a table's rows are processed separately.
Horizontal partitioning makes sense:
Answer: FALSE
Horizontal partitioning refers to the process of combining several smaller relations into a larger table.
Answer: TRUE
One decision in the physical design process is selecting structures.
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):
Answer: FALSE
One method to handle missing values is to substitute an exact value.
Answer: TRUE
One objective of selecting a data type is to minimize storage space.
Answer: FALSE
Parallel query processing speed is not significantly different from running queries in a non-parallel mode.
Answer: TRUE
Along with table scans, other elements of a query can be processed in parallel.
efficiency.
An advantage of partitioning is:
Answer: FALSE
An extent is a named portion of secondary memory allocated for the purpose of storing physical records.
join index.
An index on columns from two or more tables that come from the same domain of values is called a:
range control.
An integrity control supported by a DBMS is:
data replication.
Another form of denormalization where the same data are stored in multiple places in the database is called:
Answer: FALSE
The logical database design always forms the best foundation for grouping attributes in the physical design.
Answer: FALSE
The query processor always knows the best way to process a query.
field.
The smallest unit of application data recognized by system software is a:
Answer: FALSE
The smallest unit of named application data is a record.
data integrity
The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space.
default value.
The value a field will assume unless the user enters an explicit value for an instance of that field is called a(n):
Answer: TRUE
A hashing algorithm is a routine that converts a primary key value into a relative record number.
Answer: FALSE
A join index is a combination of two or more indexes.
selecting structures.
A key decision in the physical design process is:
Answer: FALSE
A key is a data structure used to determine the location of rows in a file that satisfy some condition.
all of the above.
A method for handling missing data is to:
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:
clustering.
A method to allow adjacent secondary memory space to contain rows from several tables is called:
Answer: TRUE
A pointer is a field of data that can be used to locate a related field or record of data.
Answer: TRUE
A range control limits the set of permissible values that a field may assume.
all of the above.
A requirement to begin designing physical files and databases is:
all of the above.
A rule of thumb for choosing indexes is to:
Answer: TRUE
A tablespace is a named set of disk storage elements in which physical files for the database tables may be stored.
pointer
A(n) ________ is a field of data used to locate a related field or record.
hashing algorithm
A(n) ________ is a routine that converts a primary key value into a relative record number.
file organization
A(n) ________ is a technique for physically arranging the records of a file on secondary storage devices.
horizontal partitioning.
Distributing the rows of data into separate files is called:
Answer: TRUE
Efficient database structures will be beneficial only if queries and the underlying database management system are tuned to properly use the structures.
Vertical
________ partitioning distributes the columns of a table into several separate physical records.
boolean.
All of the following are valid datatypes in Oracle 11g EXCEPT:
transaction volumes.
Database access frequencies are estimated from:
Answer: TRUE
Denormalization almost always leads to more storage space for raw data.
Answer: FALSE
Denormalization is the process of transforming relations with variable-length fields into those with fixed-length fields.
extra space and update time.
A disadvantage of partitioning is:
all of the above.
A factor to consider when choosing a file organization is:
Answer: FALSE
A file organization is a named portion of primary memory.
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:
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:
extent.
A contiguous section of disk storage space is called a(n):
Answer: FALSE
A default value is the value that a field will always assume, regardless of what the user enters for an instance of that field.
data type.
A detailed coding scheme recognized by system software for representing organizational data is called a(n):
descriptions
Designing physical files requires ________ of where and when data are used in various ways.
a one-to-many relationship.
All of the following are common denormalization opportunities EXCEPT:
multivalued partitioning.
All of the following are horizontal partitioning methods in Oracle EXCEPT:
Answer: FALSE
Adding notations to the EER diagram regarding data volumes and usage is of no value to the physical design process.
use a lot of storage space.
All of the following are objectives when selecting a data type EXCEPT:
Answer: TRUE
Clustering allows for adjacent secondary memory locations to contain rows from several tables.
Answer: TRUE
In a sequential file, the records are stored in sequence according to primary key.
efficient data processing
In most cases the goal of ________ dominates the design process.
Physical
In which data model would a code table appear?
Hashed
In which type of file is multiple key retrieval not possible?
Answer: TRUE
Indexes are most useful for columns that frequently appear in WHERE clauses of SQL commands, either to qualify the rows to select or for linking.
Answer: FALSE
Indexes are most useful on small, clustered files.
Answer: TRUE
Keeping the zip code with the city and state in a table is a typical form of denormalization.
Answer: FALSE
Reduced uptime is a disadvantage of partitioning.
Answer: TRUE
Requirements for response time, data security, backup and recovery are all requirements for physical design.
Answer: FALSE
SOX stands for the Sorbet-Oxford Act.
Answer: TRUE
Security is one advantage of partitioning.
Answer: TRUE
Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results.
checking to see if missing data will greatly impact results.
Sensitivity testing involves:
Answer: FALSE
Using an index for attributes referenced in ORDER BY and GROUP BY clauses has no significant impact upon database performance.
Answer: TRUE
Vertical partitioning means distributing the columns of a table into several separate physical records.
Improve data integrity
Which of the following is an objective of selecting a data type?
Hashed
Which type of file is easiest to update?
Sequential
Which type of file is most efficient with storage space?
operating system.
While Oracle has responsibility for managing data inside a tablespace, the tablespace as a whole is managed by the:
tablespace.
Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n):
