All India Exams
Home AptitudeBankEngineeringEnglishGKInterviewOnline TestPlacement PapersReasoning
  • Home
  • Aptitude
  • Bank
  • Engineering
  • English
  • GK
  • Interview
  • Online Test
  • Placement Papers
  • Reasoning

Normal Forms DBMS Questions And Answers

Here you can find Normal Forms DBMS Questions and Answers.

Why Normal Forms DBMS Questions and Answers Required?

In this Normal Forms DBMS Questions and Answers section you can learn and practice Normal Forms DBMS Questions and Answers to improve your skills in order to face technical inerview conducted by organisations. By Practicing these interview questions, you can easily crack any Exams interview.

Where can I get Normal Forms DBMS Questions and Answers?

AllIndiaExams provides you lots Normal Forms DBMS Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Normal Forms DBMS Questions and Answers as PDF files and eBooks.

How to solve these Normal Forms DBMS Questions and Answers?

You no need to worry, we have given lots of Normal Forms DBMS Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Competitive Exams interview.

Normal Forms DBMS Questions & Answers

1. In the __________ normal form, a composite attribute is converted to individual attributes.

Normal Forms DBMS Questions & Answers

2. A table on the many side of a one to many or many to many relationship must:

Normal Forms DBMS Questions & Answers

3. Tables in second normal form (2NF):

Normal Forms DBMS Questions & Answers

4. Which-one ofthe following statements about Normal Forms DBMS is FALSE?

Normal Forms DBMS Questions & Answers

5. Functional Dependencies are the types of constraints that are based on______

Normal Forms DBMS Questions & Answers

6. Which is a bottom-up approach to database design that design by examining the relationship between attributes:

Normal Forms DBMS Questions & Answers

7. Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:

Normal Forms DBMS Questions & Answers

8. Which forms has a relation that possesses data about an individual entity:

Normal Forms DBMS Questions & Answers

9. Which forms are based on the concept of functional dependency:

Normal Forms DBMS Questions & Answers

10. Empdt1(empcode, name, street, city, state,pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in

Home EngineeringComputer Science & EngineeringDBMS Questions and AnswersNormal Forms

Normal Forms - DBMS Questions and Answers

This is the DBMS questions and answers section on "Normal Forms" with explanation for various interview, competitive examination and entrance test. Solved examples with detailed answer description, explanation are given and it would be easy to understand.

Normal Forms DBMS Questions

Online Test Name Normal Forms
Exam Type Multiple Choice Questions
Category Computer Science Engineering Quiz
Number of Questions 10
1. In the __________ normal form, a composite attribute is converted to individual attributes.
  • A. First
  • B. Second
  • C. Third
  • D. Fourth
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option A

Explanation:

First

The first normal form is used to eliminate the duplicate information.

Workspace

Report Error


2. A table on the many side of a one to many or many to many relationship must:
  • A. Be in Second Normal Form (2NF)
  • B. Be in Third Normal Form (3NF)
  • C. Have a single attribute key
  • D. Have a composite key
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option D

Explanation:

Have a composite key

The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.

Workspace

Report Error


3. Tables in second normal form (2NF):
  • A. Eliminate all hidden dependencies
  • B. Eliminate the possibility of a insertion anomalies
  • C. Have a composite key
  • D. Have all non key fields depend on the whole primary key
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option A

Explanation:

Eliminate all hidden dependencies

The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.

Workspace

Report Error


4. Which-one ofthe following statements about normal forms is FALSE?
  • A. BCNF is stricter than 3 NF
  • B. Lossless, dependency -preserving decomposition into 3 NF is always possible
  • C. Loss less, dependency "“ preserving decomposition into BCNF is always possible
  • D. Any relation with two attributes is BCNF View Answer
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option A

Explanation:

Loss less, dependency “ preserving decomposition into BCNF is always possible

We say that the decomposition is a lossless decomposition if there is no loss of information by replacing r (R) with two relation schemas r1(R1) andr2(R2).

Workspace

Report Error


5. Functional Dependencies are the types of constraints that are based on______
  • A. Key
  • B. Key revisited
  • C. Superset key
  • D. None of these
  • View Answer
  • Workspace
  • Report
  • Discuss

Answer & Explanation

Answer: Option A

Explanation:

Key

Key is the basic element needed for the constraints.

Workspace

Report Error


  • «
  • 1
  • 2
  • »

Related Topics:

  • Constraints
  • OLAP
  • SQL Basics
  • RAID
  • Physical Storage Media
  • DBMS Keys
  • Joins
  • Storage Structure
  • Deadlocks
  • Data Types

Mock Tests & Online Quizzes

  • Aptitude Online Test

  • Reasoning Online Test

  • GK Online Test

  • English Online Test

  • RRB Mock Test

  • RBI Mock Test

  • Free SBI Mock Test

  • IBPS Mock Test FREE

  • SSC Mock Test

  • CAT Exam Mock Test

  • GATE Mock Test

  • IT Courses Quiz

Questions and Answers

  • Aptitude Questions
  • Verbal Reasoning Questions
  • Non Verbal Reasoning
  • Logical Reasoning Questions
  • Data Sufficiency Questions
  • Data Interpretation
  • eLitmus Sample Papers
  • ECE Questions and Answers
  • EEE Questions and Answers
  • Verbal Ability Questions
  • GK Questions

Programming Quiz

  • C Programming
  • C++ Programming
  • PHP Programming
  • Java Programming
  • Python Programming
  • DataScience MCQ
  • Hadoop MCQ
  • Mongo DB MCQ
  • MySQL MCQ

Interview Questions

  • Java Interview Questions
  • .Net Interview Questions
  • Networking Interview Questions
  • C Language Interview Questions
  • C++ Interview Questions
  • Testing Interview Questions
  • Android Interview Questions
  • HR Interview Questions
  • Group Discussion Topics

Our Sites

AView.in

© by AllIndiaExams.in. All Rights Reserved | Copyright | Terms of Use & Privacy Policy