Database MCQ - Database design

6:  

Consider the following set of functional dependencies on the schema (A, B, C)
A --> BC,
B —> C,
A —> B,
AB —> C
The cannonical cover for this set is

A.

A —> BC and B ---->C

B.

A ----> BC and AB —> C

C.

A —> BC and A —> B

D.

A —> B and B —> C

 
 

Option: A

Explanation :

Sets of functional dependencies may have redundant dependencies that can be inferred from the other functional dependencies. A canonical cover of F is a “minimal” set of functional dependencies equivalent to F, having no redundant dependencies or redundant parts of dependencies.

As we can infer all FD's from option A , so A is right answer.

Click on Discuss to view users comments.

Write your comments here:



7:  

 A table T1 in a relation database has following rows and columns.

Roll number                       Marks.
1                                           10
2                                           20
3                                           30
4                                           NULL

The following sequence of SQL statements was successfully executed in table T1.

Update T1 set marks =marks + 5 ;

select avg(marks) from T1 ;

 What is the output of the select statement?

 

A.

18.75

B.

20

C.

25

D.

NULL

 
 

Option: A

Explanation :

Average = (15+25+35+null)/4 = 18.75

Click on Discuss to view users comments.

kiran said: (3:45pm on Sunday 12th May 2013)
5 in each marks then calculate and find its average
mubina said: (3:44pm on Thursday 27th June 2013)
null is updated but the average calculated on (15 25 35)/3 so it wwill give output 25

Write your comments here:



8:  

Which normal form is considered adequate for relational database design?

 

A.

2NF

B.

3NF

C.

4 NF

D.

BCNF

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



9:  

 A functional dependency of the form x —> y is trival if

A.

⊆ x

B.

⊂  x

C.

 y

D.

y and y⊂ x

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



10:  

If every non-key attribute is functionally depedent primary key, then the relation will be in

A.

First normal form

B.

Second normal form

C.

Third form

D.

Fourth normal form

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Amit said: (1:15pm on Friday 6th September 2013)
in 2nf partial dependency should not exist den how it can be 2nf
Atul said: (10:56pm on Wednesday 11th January 2017)
I think it should be A. First normal form , i.e for 2nf there would be FULLY functionally dependent..

Write your comments here:




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