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 23 of 23

Q221.
In SQL, .................. is an Aggregate function.
Discuss
Answer: (c).AVG
Q222.
Match the following with respect to RDBMS:

List - I
(a) Entity integrity
(b) Domain integrity
(c) Referential integrity
(d) Userdefined integrity

List - II
(i) enforces some specific business rule that do not fall into entity or domain
(ii) Rows can't be deleted which are used by other records
(iii) enforces valid entries for a column
(iv) No duplicate rows in a table

Code:
(a) (b) (c) (d)
Discuss
Answer: (b).(iv) (iii) (ii) (i)
Q223.
In RDBMS, different classes of relations are created using ................... technique to prevent modification anomalies.
Discuss
Answer: (d).Normal Forms
Q224.
.................. SQL command changes one or more fields in a record.
Discuss
Answer: (c).MODIFY
Q225.
If every non-key attribute is functionally dependent on the primary key, then the relation is in ....................
Discuss
Answer: (c).Third normal form
Q226.
Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist.

CH → G
A → BC
B → CFH
E → A
F → EG

The relation R is ....................
Discuss
Answer: (a).in 1NF but not in 2NF
Q227.
Given two relations R1(A, B) and R2(C, D), the result of following query
Select distinct A, B from R1, R2
is guaranteed to be same as R1 provided one of the following condition is satisfied.
Discuss
Answer: (b).R1 has no duplicates and R2 is non - empty.
Q228.
Consider a schema R(A, B, C, D) and following functional dependencies.

A → B
B → C
C → D
D → B

Then decomposition of R into R1(A, B), R2(B, C) and R3(B, D) is ..................
Discuss
Answer: (a).Dependency preserving and lossless join.

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!