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!

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

Formal Languages and Automata Theory

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

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

MySQL Database

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

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

C# programming

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

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Human Computer Interaction

Enhance your knowledge of Human-Computer Interaction with our specialized MCQs....

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...