DBMS 3330 FINAL EXAM QUESTIONS AND
ANSWERS
A relational query optimizer ____. - Correct Answers -None of the above.
Data in ____ has only a single attribute value in every attribute position. - Correct
Answers -All of the above.
"In the division remainder hashing algorithm, the divisor (the number divided into the
other number) is _____." - Correct Answers -the number of main record storage
locations (not including overflow locations)
Having dedicated experts whose job it is to perform database design would be most
directly characterized as ____. - Correct Answers -efficiency in job specialization
"Which of the following is true about indexes, in general?" - Correct Answers -An index
can be used to retrieve the records of a file in logical sequence based on the indexed
field.
Abstract data types _____. - Correct Answers -can have associated operations that act
upon them
"In a hospital setting, the data that most likely would be represented by an abstract data
type would be _____." - Correct Answers -digitized x-rays
"In the SQL SELECT command, the search arguments that limit the rows involved in the
query are specified in the ____ clause." - Correct Answers -WHERE
A subquery can be used in place of a(n) ____. - Correct Answers -join
"All of the following are SQL commands, except ____." - Correct Answers -CREATE
SELECT
Typing SQL SELECT commands in at a keyboard and sending them directly to the
relational DBMS for processing is referred to as ____. - Correct Answers -query mode
Placing the unique identifier of one database table in another existing or new table in
the database ____. - Correct Answers -All of the above.
, In an indexed sequential file _____. - Correct Answers -the field on which the file is
sequenced must be indexed
"All of the following are good candidates for having an index built over them, except
____." - Correct Answers -All of the above.
An access path is _____. - Correct Answers -a plan for the steps to take to respond to
an SQL query
The SQL SELECT BETWEEN operator is used ____. - Correct Answers -to find a
numeric value between two numeric values
"In SQL, the use of a(n) _____ is capable of obtaining the same result as a Join
operation." - Correct Answers -subquery
"In an SQL SELECT command, a SELECT clause with several attributes and the
absence of a WHERE clause indicates a(n) ____." - Correct Answers -relational Project
operation
"The conversion of a unary many-to-many relationship, a binary many-to-many
relationship, and a ternary relationship, into relational tables have in common _____." -
Correct Answers -the addition of one additional table beyond those required for the
entities themselves
Consider Table A on the one side of a one-to-many relationship and Table B on the
many side of the relationship. The repeating groups in Table B may be considered for
merging into the related records of Table A if ____. - Correct Answers -there is a small
number of occurrences of the repeating groups of Table B for each record of Table A
Data in ____ cannot have partial functional dependencies but can have transitive
dependencies. - Correct Answers -second normal form
"In third normal form, the exception to the rule that a non-key attribute cannot define
another non-key attribute is ____." - Correct Answers -if the defining attribute is a
candidate key
"All of the following are true if a relational database is in third normal form, except each
of the tables of the database is _____." - Correct Answers -in every normal form higher
than third normal form
Converting a one-to-one binary relationship into a relational database from an E-R
diagram ____. - Correct Answers -a & b above
Converting a many-to-many unary relationship into a relational database from an E-R
diagram ____. - Correct Answers -can be done by adding another copy of the unique
identifier of the single entity s table into the same table with a different attribute name
ANSWERS
A relational query optimizer ____. - Correct Answers -None of the above.
Data in ____ has only a single attribute value in every attribute position. - Correct
Answers -All of the above.
"In the division remainder hashing algorithm, the divisor (the number divided into the
other number) is _____." - Correct Answers -the number of main record storage
locations (not including overflow locations)
Having dedicated experts whose job it is to perform database design would be most
directly characterized as ____. - Correct Answers -efficiency in job specialization
"Which of the following is true about indexes, in general?" - Correct Answers -An index
can be used to retrieve the records of a file in logical sequence based on the indexed
field.
Abstract data types _____. - Correct Answers -can have associated operations that act
upon them
"In a hospital setting, the data that most likely would be represented by an abstract data
type would be _____." - Correct Answers -digitized x-rays
"In the SQL SELECT command, the search arguments that limit the rows involved in the
query are specified in the ____ clause." - Correct Answers -WHERE
A subquery can be used in place of a(n) ____. - Correct Answers -join
"All of the following are SQL commands, except ____." - Correct Answers -CREATE
SELECT
Typing SQL SELECT commands in at a keyboard and sending them directly to the
relational DBMS for processing is referred to as ____. - Correct Answers -query mode
Placing the unique identifier of one database table in another existing or new table in
the database ____. - Correct Answers -All of the above.
, In an indexed sequential file _____. - Correct Answers -the field on which the file is
sequenced must be indexed
"All of the following are good candidates for having an index built over them, except
____." - Correct Answers -All of the above.
An access path is _____. - Correct Answers -a plan for the steps to take to respond to
an SQL query
The SQL SELECT BETWEEN operator is used ____. - Correct Answers -to find a
numeric value between two numeric values
"In SQL, the use of a(n) _____ is capable of obtaining the same result as a Join
operation." - Correct Answers -subquery
"In an SQL SELECT command, a SELECT clause with several attributes and the
absence of a WHERE clause indicates a(n) ____." - Correct Answers -relational Project
operation
"The conversion of a unary many-to-many relationship, a binary many-to-many
relationship, and a ternary relationship, into relational tables have in common _____." -
Correct Answers -the addition of one additional table beyond those required for the
entities themselves
Consider Table A on the one side of a one-to-many relationship and Table B on the
many side of the relationship. The repeating groups in Table B may be considered for
merging into the related records of Table A if ____. - Correct Answers -there is a small
number of occurrences of the repeating groups of Table B for each record of Table A
Data in ____ cannot have partial functional dependencies but can have transitive
dependencies. - Correct Answers -second normal form
"In third normal form, the exception to the rule that a non-key attribute cannot define
another non-key attribute is ____." - Correct Answers -if the defining attribute is a
candidate key
"All of the following are true if a relational database is in third normal form, except each
of the tables of the database is _____." - Correct Answers -in every normal form higher
than third normal form
Converting a one-to-one binary relationship into a relational database from an E-R
diagram ____. - Correct Answers -a & b above
Converting a many-to-many unary relationship into a relational database from an E-R
diagram ____. - Correct Answers -can be done by adding another copy of the unique
identifier of the single entity s table into the same table with a different attribute name
