DBMS- Normalization Questions and Answers

Practice Mode
Showing 10 of 26 questions
Q21
A relation R is said to be in 2NF
  • A if it is in 1NF
  • B every non-prime key attributes of R is fully functionally dependent on each relation key of R.
  • C if it is in BCNF
  • D both (a) and (b)
Answer: Option D
Q22
A relation R is said to be in 3NF if the
  • A relation R is in 2NF
  • B nonprime attributes are mutually independent
  • C functionally dependent on the primary key.
  • D all of these.
Answer: Option D
Q23
The idea of multi-valued dependency was introduced by
  • A E.F. Codd
  • B R.F. Boyce
  • C R. Fagin
  • D none of these
Answer: Option C
Q24
The expansion of BCNF is
  • A Boyd-Codd Normal Form
  • B Boyce-Ccromwell Normal Form
  • C Boyce-Codd Normal Form
  • D none of these
Answer: Option C
Q25
The fourth normal form (4NF) is concerned with dependencies between the elements of compound keys composed of
  • A one attribute
  • B two attributes
  • C three or more attributes
  • D none of these
Answer: Option C
Q26
When all the columns (attributes) in a relation describe and depend upton the primary key, the relation is said to be in
  • A 1NF
  • B 2NF
  • C 3NF
  • D 4NF
Answer: Option B

📚 More from Database

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