Database Ch 5
70 Questions
| Attempts: 220
Questions and Answers
- 1.
Normalization works through a series of stages called normal forms.
- A.
True
- B.
False
Correct Answer
A. True -
- 2.
Normalization produces a lower normal form.
- A.
True
- B.
False
Correct Answer
B. False -
- 3.
Normalization should be part of the design process.
- A.
True
- B.
False
Correct Answer
A. True -
- 4.
Normalization is a process that is used for changing attributes to entities.
- A.
True
- B.
False
Correct Answer
B. False -
- 5.
In order to meet performance requirements, you may have to denormalize portions of the database design.
- A.
True
- B.
False
Correct Answer
A. True -
- 6.
Denormalization produces a lower normal form.
- A.
True
- B.
False
Correct Answer
A. True -
- 7.
Normalization is a very important database design ingredient and the highest level is always the most desirable.
- A.
True
- B.
False
Correct Answer
B. False -
- 8.
Relational models view the data as part of a table or collection of tables in which all key values must be identified.
- A.
True
- B.
False
Correct Answer
A. True -
- 9.
Repeating groups must be eliminated by making sure that each row defines a single entity.
- A.
True
- B.
False
Correct Answer
A. True -
- 10.
Repeating groups must be eliminated by making sure that each column defines a single entity.
- A.
True
- B.
False
Correct Answer
B. False -
- 11.
Dependencies can be identified with the help of the dependency diagram.
- A.
True
- B.
False
Correct Answer
A. True -
- 12.
Dependencies that are based on only a part of a composite primary key are called transitive dependencies.
- A.
True
- B.
False
Correct Answer
B. False -
- 13.
A dependency of one nonprime attribute on another nonprime attribute is a partial dependency.
- A.
True
- B.
False
Correct Answer
B. False -
- 14.
All relational tables satisfy the 1NF requirements.
- A.
True
- B.
False
Correct Answer
A. True -
- 15.
Data redundancies are caused by the fact that every row entry requires duplication of data.
- A.
True
- B.
False
Correct Answer
A. True -
- 16.
Converting a database format from 1NF to 2NF is a complex process.
- A.
True
- B.
False
Correct Answer
B. False -
- 17.
Because a partial dependency can exist only if a table's primary key is composed of several attributes, a table whose primary key consists of only a single attribute must automatically be in 2NF if it is in 1NF.
- A.
True
- B.
False
Correct Answer
A. True -
- 18.
A table is in 2NF if it is in 1NF and it includes no partial dependencies.
- A.
True
- B.
False
Correct Answer
A. True -
- 19.
It is possible for a table in 2NF to exhibit transitive dependency, where one or more attributes may be functionally dependent on non-key attributes.
- A.
True
- B.
False
Correct Answer
A. True -
- 20.
A determinant is any attribute whose value determines other values within a column.
- A.
True
- B.
False
Correct Answer
B. False -
- 21.
Atomic attributes are attributes that can be further divided.
- A.
True
- B.
False
Correct Answer
B. False -
- 22.
A table is in BCNF if every determinant in the table is a candidate key.
- A.
True
- B.
False
Correct Answer
A. True -
- 23.
A table is in BCNF if every determinant in the table is a foreign key.
- A.
True
- B.
False
Correct Answer
B. False -
- 24.
A table is in fourth normal form if it is in third normal form and has no multiple sets of multivalued dependencies.
- A.
True
- B.
False
Correct Answer
A. True -
- 25.
Normalization represents a micro view of the entities within the ERD.
- A.
True
- B.
False
Correct Answer
A. True -
- 26.
The combination of normalization and ER modeling yields a useful ERD, whose entities may now be translated into appropriate relationship structures.
- A.
True
- B.
False
Correct Answer
B. False -
- 27.
A good relational DBMS excels at managing denormalized relations.
- A.
True
- B.
False
Correct Answer
B. False -
- 28.
The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.
- A.
True
- B.
False
Correct Answer
A. True -
- 29.
Normalization purity is easy to sustain in the modern database environment.
- A.
True
- B.
False
Correct Answer
B. False -
- 30.
Unnormalized database tables often lead to various data redundancy disasters in production databases.
- A.
True
- B.
False
Correct Answer
A. True -
- 31.
Normalization works through a series of stages called normal forms. Typically ____ stages are processed.
- A.
Two
- B.
Three
- C.
Four
- D.
Five
Correct Answer
B. Three -
- 32.
1NF, 2NF, and 3NF are ____.
- A.
Normalization stages
- B.
Anomalies
- C.
Repeating groups
- D.
Atomic attributes
Correct Answer
A. Normalization stages -
- 33.
From a structural point of view, 2NF is better than ____.
- A.
1NF
- B.
3NF
- C.
4NF
- D.
BCNF
Correct Answer
A. 1NF -
- 34.
____ yields better performance.
- A.
Denormalization
- B.
Normalization
- C.
Atomization
- D.
Compression
Correct Answer
A. Denormalization -
- 35.
A table that displays data redundancies yields ____.
- A.
Consistencies
- B.
Anomalies
- C.
Fewer attributes
- D.
More entities
Correct Answer
B. Anomalies -
- 36.
Data redundancy produces ____.
- A.
Slower lookups
- B.
Robust design
- C.
Efficient storage use
- D.
Data integrity problems
Correct Answer
D. Data integrity problems -
- 37.
Converting a ____ is not an example of denormalization.
- A.
3NF to 2NF
- B.
2NF to 1NF
- C.
3NF to 1NF
- D.
3NF to BCNF
Correct Answer
D. 3NF to BCNF -
- 38.
Some very specialized applications may require normalization beyond the ____.
- A.
1NF
- B.
2NF
- C.
3NF
- D.
4NF
Correct Answer
D. 4NF -
- 39.
Of the following normal forms,____, is mostly of theoretical interest.
- A.
3NF
- B.
1NF
- C.
BCNF
- D.
DKNF
Correct Answer
D. DKNF -
- 40.
____ is not a valid normal form.
- A.
1NF
- B.
BCNF
- C.
3NF
- D.
MVNF
Correct Answer
D. MVNF -
- 41.
A relation is not in 1NF if ____.
- A.
It has multiple candidate keys
- B.
All of the key attributes are defined
- C.
There are repeating groups in the table
- D.
All attributes are dependent on the primary key
Correct Answer
C. There are repeating groups in the table -
- 42.
A(n) ____ should not be placed in a relational table.
- A.
Entity
- B.
Attribute
- C.
Relationship
- D.
Repeating group
Correct Answer
D. Repeating group -
- 43.
Attribute A ____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.
- A.
Determines
- B.
Derives from
- C.
Controls
- D.
Owns
Correct Answer
A. Determines -
- 44.
Dependencies based on only a part of a composite primary key are called ____ dependencies.
- A.
Primary
- B.
Partial
- C.
Incomplete
- D.
Composite
Correct Answer
B. Partial -
- 45.
An attribute that is part of a key is known as a(n) ____ attribute.
- A.
Important
- B.
Nonprime
- C.
Prime
- D.
Entity
Correct Answer
C. Prime -
- 46.
Given the table EMP_PROJ (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, HOURS), of the following,____, is a partial dependency.
- A.
PROJ_NUM --> PROJ_NAME
- B.
JOB_CLASS --> CHG_HOUR
- C.
PROJ_NUM, EMP_NUM --> HOURS
- D.
PROJ_NUM, EMP_NUM --> CHG_HOURS
Correct Answer
A. PROJ_NUM --> PROJ_NAME -
- 47.
A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in ____.
- A.
1NF
- B.
2NF
- C.
3NF
- D.
4NF
Correct Answer
A. 1NF -
- 48.
In a(n) ____ diagram, the arrows above the attributes indicate all desirable dependencies.
- A.
Chen
- B.
Dependency
- C.
Functionality
- D.
ER
Correct Answer
B. Dependency -
- 49.
A table that is in 1NF and includes no partial dependencies only is said to be in ____.
- A.
BCNF
- B.
2NF
- C.
3NF
- D.
4NF
Correct Answer
B. 2NF -
- 50.
If you have three different transitive dependencies ____ different determinant(s) exist.
- A.
One
- B.
Two
- C.
Three
- D.
Four
Correct Answer
C. Three -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 17, 2022Quiz Edited by
ProProfs Editorial Team -
Apr 28, 2014Quiz Created by
Rudy12
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top