Database Management System MCQs | DBMS Solved Objective Questions and Answers on Normalization

Questions
11 Third normal form is based on the concept of _________
A Closure Dependency
B Transitive Dependency
C Normal Dependency
D Functional Dependency

Answer: Option [B]
12 Third normal form is inadequate in situations where the relation :
A has multiple candidate keys
B has candidate keys that are composite
C has overlapped candidate keys
D none of the above

Answer: Option [D]
13 Which of the following statements is/are true ?
A A relation is in BCNF if it is not in 4NF
B BCNF is stricter than 3NF
C A relation is in BCNF if every determinant of the relation is a candidate key.
D All are true

Answer: Option [D]
14 Which normal form is considered as adequate for usual database design ?
A 2NF
B 3NF
C 4NF
D 5NF

Answer: Option [B]
15 Which of the following is true ?
A A relation in BCNf is always in 3NF.
B A relation in 3NF is always in BCNF.
C BCNF and 3NF are same.
D A relation in BCNF is not in 3NF

Answer: Option [A]

Chapters

current affairs 2021 pdf plan

Current Affairs MCQs

Current Affairs Quiz November 2021
Current Affairs Quiz October 2021
Current Affairs Quiz September 2021
Current Affairs Quiz August 2021
Current Affairs Quiz July 2021
Current Affairs Quiz June 2021
Current Affairs Quiz May 2021
Current Affairs Quiz April 2021
Current Affairs Quiz March 2021
Current Affairs Quiz February 2021
Current Affairs Quiz January 2021
Current Affairs Quiz December 2020

State-wise Current Affairs

Andhra Pradesh Current Affairs
Arunachal Pradesh Current Affairs
Assam Current Affairs
Bihar Current Affairs
Chhattisgarh Current Affairs
Delhi Current Affairs
Goa Current Affairs
Gujarat Current Affairs
Haryana Current Affairs
Himachal Pradesh Current Affairs
Jammu & Kashmir Current Affairs
Jharkhand Current Affairs
Karnataka Current Affairs
Kerala Current Affairs
Madhya Pradesh Current Affairs
Maharashtra Current Affairs
Manipur Current Affairs
Meghalaya Current Affairs
Mizoram Current Affairs
Nagaland Current Affairs
Odisha Current Affairs
Puducherry Current Affairs
Punjab Current Affairs
Rajasthan Current Affairs
Sikkim Current Affairs
Tamil Nadu Current Affairs
Telangana Current Affairs
Tripura Current Affairs
Uttarakhand Current Affairs
Uttar Pradesh Current Affairs
West Bengal Current Affairs

Month-wise Current Affairs 2021

November 2021
October 2021
September 2021
August 2021
July 2021
June 2021
May 2021
April 2021

Category-wise Current Affairs

Agriculture Current Affairs
Art & Culture Current Affairs
Awards & Prizes Current Affairs
Bank Current Affairs
Bill & Acts Current Affairs
Committees and Commissions Current Affairs
Memorandum of Understanding Current Affairs
Days & Events Current Affairs
Economic Survey 2020-21 Currrent Affairs
Environment Current Affairs
Festivals Current Affairs
Finance Current Affairs
Health Current Affairs
History Current Affairs
Indian Polity Current Affairs
International Relationship Current Affairs
NITI Aayog Current Affairs
Science & Technology Current Affairs
Sports Current Affairs
Union Budget 2021 Current Affairs

Jobs by Qualification

8th Pass Jobs
10th Pass Jobs
12th Pass Jobs
BCA Pass Jobs
B.Com Pass Jobs
B.Ed Pass Jobs
B.Sc Pass Jobs
B.tech Pass Jobs
LLB Pass Jobs
M.Com Pass Jobs
M.Sc Pass Jobs
M.Tech Jobs
MCA Pass Jobs
MA Pass Jobs
MBBS Pass Jobs
MBA Pass Jobs

Free Mock Test

Current Affairs Mock Test
IBPS Exam Mock Test
Indian History Mock Test
Political Science Mock Test
RBI Mock Test
RBI Assistant Mock Test
RBI Grade B General Awareness Mock Test
RRB NTPC General Awareness Mock Test
SBI Mock Test
SBI PO Mock Test
SSC Mock Test
SSC General Awareness Mock Test