adplus-dvertising

Welcome to the DBMS MCQs Page

Dive deep into the fascinating world of DBMS with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of DBMS, a crucial aspect of UGC CBSE NET Exam. In this section, you will encounter a diverse range of MCQs that cover various aspects of DBMS, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within UGC CBSE NET Exam.

frame-decoration

Check out the MCQs below to embark on an enriching journey through DBMS. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of UGC CBSE NET Exam.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of DBMS. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

DBMS MCQs | Page 17 of 23

Explore more Topics under UGC CBSE NET Exam

Q161.
If a relation is in 2NF then:

a.

every candidate key is a primary key

b.

every non-prime attribute is fully functionally dependent on each relation key

c.

every attribute is functionally independent

d.

every relational key is a primary key

Discuss
Answer: (b).every non-prime attribute is fully functionally dependent on each relation key
Q162.
Which of the following is true ?

a.

A relation in 3NF is always in BCNF

b.

A relation in BCNF is always in 3NF

c.

BCNF and 3NF are totally different

d.

A relation in BCNF is in 2NF but not in 3NF

Discuss
Answer: (b).A relation in BCNF is always in 3NF
Q163.
Consider the query : SELECT student_name FROM student_data WHERE rollno (SELECT rollno FROM student_marks WHERE SEM1_MARK=SEM2_MARK);

Which of the following is true?

a.

It gives the name of the student whose marks in semester 1 and semester 2 are same.

b.

It gives all the names and roll nos  of those students whose marks in semester 1 and semester 2 are same.

c.

It gives the names of all the students whose marks in semester 1 and semester 2 are same.

d.

It gives roll numbers of all students whose marks in semester 1 and semester 2 are same.

Discuss
Answer: (c).It gives the names of all the students whose marks in semester 1 and semester 2 are same.
Q164.
A primary key for an entity is:

a.

a candidate key

b.

any  attribute

c.

a unique attribute

d.

a super key

Discuss
Answer: (c).a unique attribute
Q165.
Aggregate functions in SQL are:

a.

GREATEST, LEAST and ABS

b.

SUM, COUNT and AVG

c.

UPPER, LOWER and LENGTH

d.

SQRT, POWER and MOD

Discuss
Answer: (b).SUM, COUNT and AVG
Q166.
If a relation is in 2NF and 3NF forms then:

a.

no non-prime attribute is functionally dependent on other non-prime attributes

b.

no non-prime attribute is functionally dependent on prime attributes

c.

all attributes are functionally independent

d.

prime attribute is functionally independent of all non-prime attributes

Discuss
Answer: (a).no non-prime attribute is functionally dependent on other non-prime attributes
Q167.
The end of an SQL command is denoted by:

a.

an  end-of-line character

b.

an ‘enter-key’ marker

c.

entering F4 key

d.

a semicolon (;)

Discuss
Answer: (d).a semicolon (;)
Q168.
Consider  the  query  :  SELECT  student_name  FROM  students  WHERE class_name=(SELECT  class_name  FROM  students  WHERE  math_marks=100); what will be the output ?

a.

the list of names of students with 100 marks in mathematics

b.

the  names  of  all  students  of  all  classes  in  which  at  least  one  student  has 100 marks in mathematics

c.

the names of all students in all classes having 100 marks in mathematics

d.

the names and class of all students whose marks in mathematics is 100

Discuss
Answer: (b).the  names  of  all  students  of  all  classes  in  which  at  least  one  student  has 100 marks in mathematics
Q169.
Which of the following statements is wrong?

a.

2-phase Locking Protocols suffer from deadlocks

b.

Time-Stamp Protocols suffer from more aborts

c.

Time-Stamp Protocols suffer from cascading roll back where as 2-Phase locking Protocol do not

d.

None of these

Discuss
Answer: (c).Time-Stamp Protocols suffer from cascading roll back where as 2-Phase locking Protocol do not
Q170.
A recursive foreign key is a:

a.

references a relation

b.

references a table

c.

references its own relation

d.

references a foreign key

Discuss
Answer: (c).references its own relation
Page 17 of 23

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Compiler Design

Unravel the process of translating source code into executable programs with our...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

MySQL Database

Enhance your knowledge of relational databases with our MySQL MCQs. Understand...

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...