Classical

Database MCQ - Database design

1:  

A relation empdt1 is defined with attributes
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

A.

1 NF only

B.

2 NF and hence also in 1 NF

C.

3NF and hence also in 2NF and 1NF

D.

BCNF and hence also in 3NF, 2NF and 1NF

 
 

Option: B

Explanation :

empdt1 {empcode, name, street, city, state, pincode)
Given functional dependency
pincode -> (city) (state)
(street) (city) (state) -->pincode

This is in I NF and 2NF but not in 3NF because it contain transitive dependency.
Hence correct answer is (b).


2:  

A table has fields F1, F2 , F3 , F4, F5 with the following functional dependencies
Fi —> F3,
F2 —> F4
(FI,F2) —> F5

In terms of normalization, this table is in

A.

1 NF

B.

2 NF

C.

3 NF

D.

None of these

 
 

Option: A

Explanation :

Primary key (candidates key) for this relation is [F1] [F2] because [F1, F2] column contains [F1, F2, F3, F4, F5]
So, there is, functional dependency F1 -> F3 , F2
It also have partial depedency so it is not in 2nd, 3rd NF.


3:  

Amongst the ACID properties of a transaction, the 'Durability' property requires. that the changes made to the database by a successful transaction persist

A.

Except in case of an operating system crash

B.

Except in case of a disk crash

C.

Except in case of a power failure

D.

Always, even if there is a failure of any kind

 
 

Option: D

Explanation :


4:  

In a schema with attributes A, B, C, D and E following set of functional dependencies are given
A --> B
A -->C
CD —>E
B --> D
E —> A 
            Which of the following functional dependencies is the implied by the above set.

A.

CD —> AC

B.

BD --> CD

C.

BC —> CD

D.

AC —> BC

 
 

Option: B

Explanation :

CD—>A     {CD —>E;E —> A; E —>C}
CD —> C
BC —> CD
B—>D;
CD—>E;
E—>A;
A—>C
AC—>BC:
A—>B:
A—>C


5:  

 Let R(A, B, C, D) be a relational schema with the following functional dependencies A —> B, B --> C ,

A.

Gives a lossless join, and is dependency preserving.

B.

Gives a lossless join, but is not dependency preserving

C.

Does not give a loss less join, but is depency preserving

D.

Does not give a lossless join and is not depency preserving

 
 

Option: A

Explanation :




Suggest an improvement

 


Syllabus covered in this section is-

  • E- R diagrams and their transformation, to relational design
  •  Normalization - l NF, 2NF, 3NF
  •  BCNF and 4NF.Limitations of 4NF and BCNF
  • SQL :Data Definition Language (DDL) , Data Manipulation Language (DML), Data Control Language· (DCL)-
  • Database objects like Views, indexes, sequences, synonyms, Data dictionary
  • Database Concepts
  • Data Models,
  • Design of Relational Database
  • Query Processing and Optimization
  • Centralized and Distributed Database
  •  Security.
  •  Concurrency and Recovery in Centralized and Distributed Database Systems,
  • Object Oriented Database Management
  • Systems (Concepts, Composite objects, Integration with ROBMS applications),

 

This Section covers Data Warehousing Questions Answers .These questions can be used for the preparation of various competitive and academic exams like

  • Undergraduate Computer Science Examinations
  • Graduate Aptitude Test in Engineering (GATE)
  • Post Graduate Exams
  •  PhD Entrance Exam
  • Computer Engineering
  • UGC NET
  • Pre PhD Entrance Exam
  • DOEACC Exams
  • Kendriya Vidyalaya Sangathan Entrance Exam

Who can benefit

  • DBMS MCQ can be useful for the students who are pursuing any undergraduate or post graduate degree in Computer Science like BE, ME, Btech, MTech, .BSc, Msc, BCA, MCA or any other such degree
  • DBMS MCQ with Answers and explanation can also be useful for the students who are preparing for any competitive Exam or recruitment exams like GATE or UGC NET Computer Science, Kendriya Vidyalaya Sangathan PGT Entrance Exam, PSU, IES, Bank Exams or any other such Exam.
  • DBMS Multiple Choice Questions Answers  can also be used by any candidate who wants to gain credits in DBMS in BS  or MS Computer Science,
  • Database management System Multiple Choice Questions with Answers can also be used by student who is pursuing degree/diploma in Information Technology like BSc in Information Techology, Msc in Information Technology or any other such degree.
  • This section can also be used by any student who is preparing for PhD Entrance Exam, Pre PhD Entrance Exam, NET JRF Entrance exam and many more.
  • Any student who is preparing for DOEACC A Level, DOEACC B Level and DOEACC C Level exams can also use Database Questions Answers.
  • You can also get free Database mcq pdf from site.
  • You can download Database MCQ pdf from this site.
  • You can get access to DBMS Multiple Choice Questions Answers EBook.

 

Various Search Terms used for this section are

  • DBMS quiz questions with answers

  • DBMS exam questions answers

  • DBMS MCQ questions Answers

  • DBMS MCQ

  • DBMS MCQ Pdf Download