Join our Telegram Channel

8000+ STATIC GK MCQs for SSC/ Railway/ PSC
1000 POLITICAL SCIENCE MCQS | EBook
Get 22 nos. GK EBooks | Combo Pack
Current Affairs Monthly Magazine -Subscribe Now!
1000 BIOLOGY MCQS AND ANSWERS | EBook
1000 ECONOMICS MCQS FOR EXAMS | EBook
Mughal Empire MCQs | EBook
ECONOMIC GEOGRAPHY MCQs | EBook
350 MCQs ON INDIAN CONSTITUTION | EBook

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]
Advertisement
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]
Advertisement

Chapters

current affairs 2022 pdf plan

Current Affairs MCQs

Current Affairs Quiz September 2022
Current Affairs Quiz August 2022
Current Affairs Quiz July 2022
Current Affairs Quiz June 2022
Current Affairs Quiz May 2022
Current Affairs Quiz April 2022
Current Affairs Quiz March 2022
Current Affairs Quiz February 2022
Current Affairs Quiz November 2021
Current Affairs Quiz October 2021
Current Affairs Quiz September 2021
Current Affairs Quiz August 2021

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

General Knowledge

Geography Quiz
Political Science GK MCQs
Indian Economy Quiz
Indian History MCQs
Law General Knowledge
Physics Quiz
GST Multiple Choice Questions
Environmental Science GK

Month-wise Current Affairs 2022

September 2022
August 2022
July 2022
June 2022
May 2022
April 2022
March 2022
February 2022

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