MODERN DATABASE MANAGEMENT FINAL
PAPER 2026 PRACTICE TEST COMPLETE
QUESTIONS SOLUTIONS GRADED A+
◉ A relation that contains minimal redundancy and allows easy use
is considered to be:
A) clean.
B) simple.
C) complex.
D) well-structured.
Answer: Well-structured
◉ A nonkey attribute is also called a(n):
A) column.
B) unimportant datum.
C) descriptor.
D) address.
Answer: Descriptor
,◉ All of the following are that main goals of normalization EXCEPT:
A. minimize data redundancy.
B. simplify the enforcement of referential integrity.
C. maximize storage space.
D. make it easier to maintain data.
Answer: Maximize storage space
◉ When all multivalued attributes have been removed from a
relation, it is said to be in:
first normal form
second normal form
Boyce-Codd normal form
third normal form
Answer: First normal form
◉ A relation that contains no multivalued attributes and has nonkey
attributes solely dependent on the primary key but contains
transitive dependencies is in which normal form?
Answer: Second
,◉ A constraint between two attributes is called a(n):
A) functional relation.
B) attribute dependency.
C) functional dependency.
D) functional relation constraint
Answer: Functional dependency
◉ A candidate key must satisfy all of the following EXCEPT:
The key must uniquely identify the row
The key must indicate the row's position in the table
The key must be nonredundant
Each nonkey attribute is functionally dependent
One of the primary key.
Answer: the key must indicate the row's position in the table
◉ The attribute on the left-hand side of the arrow in a functional
dependency is the:
Answer: Determinant
, ◉ Two or more attributes having different names but the same
meaning are called:
Answer: Synonyms
◉ An attribute that may have more than one meaning is call a:
Answer: Homonym
◉ A ________ is a detailed coding scheme recognized by system
software, such as a DBMS, for representing organizational data
A) DBMS code.
B) data type.
C) SQL.
D) DB layout.
Answer: data type
◉ A ________ is a named set of disk storage elements in which physical
files for database tables may be stored
Answer: tablespace
◉ A ________ key is one field or a combination of fields for which more
than one record may have the same combination of values
Answer: secondary
PAPER 2026 PRACTICE TEST COMPLETE
QUESTIONS SOLUTIONS GRADED A+
◉ A relation that contains minimal redundancy and allows easy use
is considered to be:
A) clean.
B) simple.
C) complex.
D) well-structured.
Answer: Well-structured
◉ A nonkey attribute is also called a(n):
A) column.
B) unimportant datum.
C) descriptor.
D) address.
Answer: Descriptor
,◉ All of the following are that main goals of normalization EXCEPT:
A. minimize data redundancy.
B. simplify the enforcement of referential integrity.
C. maximize storage space.
D. make it easier to maintain data.
Answer: Maximize storage space
◉ When all multivalued attributes have been removed from a
relation, it is said to be in:
first normal form
second normal form
Boyce-Codd normal form
third normal form
Answer: First normal form
◉ A relation that contains no multivalued attributes and has nonkey
attributes solely dependent on the primary key but contains
transitive dependencies is in which normal form?
Answer: Second
,◉ A constraint between two attributes is called a(n):
A) functional relation.
B) attribute dependency.
C) functional dependency.
D) functional relation constraint
Answer: Functional dependency
◉ A candidate key must satisfy all of the following EXCEPT:
The key must uniquely identify the row
The key must indicate the row's position in the table
The key must be nonredundant
Each nonkey attribute is functionally dependent
One of the primary key.
Answer: the key must indicate the row's position in the table
◉ The attribute on the left-hand side of the arrow in a functional
dependency is the:
Answer: Determinant
, ◉ Two or more attributes having different names but the same
meaning are called:
Answer: Synonyms
◉ An attribute that may have more than one meaning is call a:
Answer: Homonym
◉ A ________ is a detailed coding scheme recognized by system
software, such as a DBMS, for representing organizational data
A) DBMS code.
B) data type.
C) SQL.
D) DB layout.
Answer: data type
◉ A ________ is a named set of disk storage elements in which physical
files for database tables may be stored
Answer: tablespace
◉ A ________ key is one field or a combination of fields for which more
than one record may have the same combination of values
Answer: secondary
