DBMS- Normalization Questions and Answers

Practice Mode
Showing 10 of 26 questions
Q11
Multi-valued dependencies are the result of 1NF, which prohibited an attribute from having a set of values.
  • A TRUE
  • B FALSE
Answer: Option B
Q12
5NF does not require semantically related multiple relationships.
  • A TRUE
  • B FALSE
Answer: Option A
Q13
Normalization is formal process of developing data structure in a manner that eliminates redundancy and promites integrity.
  • A TRUE
  • B FALSE
Answer: Option A
Q14
5NF is also called projection-join normal form (PJNF).
  • A TRUE
  • B FALSE
Answer: Option A
Q15
Normalization is a process of
  • A decomposing a set of relations
  • B successive reduction of relation schema.
  • C deciding which attributes in relation to be
  • D all of these
Answer: Option D
Q16
The normalization process was developed by
  • A E. F. Codd
  • B R. F. Boyce
  • C R. Fagin
  • D Collin White
Answer: Option A
Q17
A normal form is
  • A a state of a relation that results from applying simple rules regarding FDs.
  • B the highest normal form condition that it meets
  • C an indication of the degree to which it has been normalised
  • D all of these.
Answer: Option D
Q18
Which of the following is the formal process of deciding which attributes should be grouped together in a relation ?
  • A optimization
  • B normalization
  • C turning
  • D none of these
Answer: Option B
Q19
In 1NF,
  • A all domains are simple
  • B in a simple domain, all elements are atomic
  • C both (a) & (b)
  • D None of these
Answer: Option C
Q20
2NF is always in
  • A 1NF
  • B BCNF
  • C MVD
  • D none of these
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test