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!

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

Wireless and Mobile Communications

Get to grips with modern communication technologies with our Wireless and Mobile...

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

Discrete Mathematics

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

IT Fundamentals

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

Software Architecture and Design

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