Database Normalization Objective Type Questions with Answers | Database Management System MCQs

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

Questions
6 Which one is not true ?
A A relation is in BCNF if it is in 4NF
B BCNF is stricter than 3NF
C A relation is in BCNF if ever determinate of the relation is a candidate key
D All are true

Answer: Option [D]
7 If every non-key attribute is functionally dependent on the primary key, then the relation will be in :
A 1NF
B 2NF
C 3NF
D 4NF

Answer: Option [B]
Advertisement
Article and Schedule Quiz Start Test!
DOWNLOAD CURRENT AFFAIRS PDF FROM APP
8 Consider the schema R(S,T,U,V) and the dependencies S→T, T→U, U→V, V→S. Let R= {R1,R2} such that R1∩R2=Φ. Then the decomposition is :
A not in 2NF
B in 2NF but not in 3NF
C in 3NF but not in 2NF
D in both 2NF and 3NF

Answer: Option [B]
9 A table is in 2NF if it is in 1NF and if :
A no column that is not a part of the primary key is dependent on only a portion of the alternate key.
B no column that is not a part of the primary key is dependent on only a portion of the primary key
C no column that is not a part of the primary key is dependent on only a portion of the foreign key
D none of these

Answer: Option [B]
10 A normal form in which every determinant is a key :
A 2NF
B 3NF
C BCNF
D 4NF

Answer: Option [C]

Random GK Questions

Q. Under which Article of the Indian Constitution, the decision of the Central Administrative Tribunal can be challenged in the Supreme Court?
Q. The term territorial water means
Q. Cell or tissue death within a living body is called as
Q. The ratio between cash in hand and total assets maintained by the banks is called :
Q. An element of atomic number 29 belongs to
Q. Who amidst the following won the Nobel Prize in Science in two different disciplines ?

Chapters

Assam Direct Recruitment Test Series

Computer Science Topics