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

Q141.
An entity instance is a single occurrence of an …………..
Discuss
Answer: (a).entity type
Q142.
Generalization is ………… process.
Discuss
Answer: (b).bottom up
Q143.
Match the following:

Set-I
I. 2 NF
II. 3 NF
III. 4 NF
IV. 5 NF

Set-II
(a) transitive dependencies eliminated
(b) multivalued attribute removed
(c) contain no partial functional dependencies
(d) contains no join dependency

Codes :
    I    II   III   IV
Discuss
Answer: (b).(d) (a) (b)  (c)
Q144.
Which data management language component enabled the DBA to define the schema components?
Discuss
Answer: (c).Schema DLL
Q145.
The PROJECT Command will create new table that has
Discuss
Answer: (d).none of these
Q146.
A chained hash table has an array size of 100. What is the maximum number of entries that can be placed in the table?
Discuss
Answer: (d).There is no upper limit
Q147.
The E-R model is expressed in term of

I. Entities
II. The relationship among entities.
III. The attributes of the entities.
IV. Functional relationship.
Discuss
Answer: (d).I, II, III
Q148.
Specialization is …………… process.
Discuss
Answer: (a).top-down
Q149.
Match the following :

List-I
(1) Determinants
(2) Candidate key
(3) Non-redundancy
(4) Functional dependency

List-II
(a) No attribute can be added
(b) Uniquely identified a row
(c) A constraint between two attribute
(d) Group of attributes on the left hand side of arrow of function dependency.
Discuss
Answer: (a).1 – d, 2 – b, 3 – a, 4 – c
Q150.
A function that has no partial functional dependencies is in ……………. form.
Discuss
Answer: (b).2 NF

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!