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

Explore more Topics under UGC CBSE NET Exam

Q111.
Which normal form is considered as adequate for usual database design?

a.

2NF

b.

3NF

c.

4NF

d.

5NF

Discuss
Answer: (b).3NF
Q112.
If D1, D2,…. Dn are domains in a relational model, then the relation is a table, which is a subset of

a.

D1+D2+…. +Dn

b.

D1x D2x… xDn

c.

D1U D2U….UDn

d.

D1- D2-….-Dn

Discuss
Answer: (b).D1x D2x… xDn
Q113.
Given an open address hash table with load factor a < 1, the expected number of probes in a successful search is

a.

Atmost  1/α ln (1-α/α)

b.

Atmost  1/α ln (1/1-α)

c.

Atleast  1/α ln (1/1-α)

d.

Atleast  1/α ln (α/1-α)

Discuss
Answer: (b).Atmost  1/α ln (1/1-α)
Q114.
The “PROJECT” operator of a relational algebra creates a new table that has always

a.

More columns than columns in original table

b.

More rows than original table

c.

Same number of rows as the original table

d.

Same number of columns as the original table

Discuss
Answer: (c).Same number of rows as the original table
Q115.
The employee information of an Organization is stored in the relation:

Employee (name, sex, salary, deptname)

Consider the following SQL query

Select deptname from Employee Where sex = ‘M’ group by deptname having avg (salary) > {select avg (salary) from Employee}

Output of the given query corresponds to

a.

Average salary of employee more than average salary of the organization.

b.

Average salary less than average salary of the organization.

c.

Average salary of employee equal to average salary of the organization.

d.

Average salary of male employees in a department is more than average salary of the organization.

Discuss
Answer: (d).Average salary of male employees in a department is more than average salary of the organization.
Q116.
For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a → c, b → d holds in the following relation

a.

In 1NF not in 2NF

b.

In 2NF not in 3NF

c.

In 3NF

d.

In 1NF

Discuss
Answer: (a).In 1NF not in 2NF
Q117.
Match the following:

a. Foreign keys                                  i. Domain constraint
b. Private key                                     ii. Referential integrity
c. Event control action model         iii. Encryption
d. Data security                                 iv. Trigger

Codes:
      a   b   c   d

a.

iii   ii    i   iv

b.

ii   i    iv  iii

c.

iii  iv   i   ii

d.

i    ii   iii  iv

Discuss
Answer: (b).ii   i    iv  iii
Q118.
In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so by

a.

Jamming

b.

Password

c.

Documentation

d.

Record lock

Discuss
Answer: (d).Record lock
Q119.
What deletes the entire file except the file structure ?

a.

ERASE

b.

DELETE

c.

ZAP

d.

PACK

Discuss
Answer: (c).ZAP
Q120.
Which command is the fastest among the following ?

a.

COPY TO < NEW FILE >

b.

COPY STRUCTURE TO < NEW FILE >

c.

COPY FILE < FILE 1 > < FILE 2 >

d.

COPY TO MFILE-DAT DELIMITED

Discuss
Answer: (b).COPY STRUCTURE TO < NEW FILE >
Page 12 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!

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

IT Fundamentals

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

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

C Programming

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

Software Engineering

Learn about the systematic approach to developing software with our Software...

Computer Graphics

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

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...