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

Explore more Topics under UGC CBSE NET Exam

Q211.
Consider a relation book (title, price) which contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query list? 
Select title
from book as B
where (select count (*)
             from book as T
             where T.price > B.price) < 7

a.

Titles of the six most expensive books.

b.

Title of the sixth most expensive books.

c.

Titles of the seven most expensive books.

d.

Title of the seventh most expensive books.

Discuss
Answer: (c).Titles of the seven most expensive books.
Q212.
In a Hierachical database, a hashing function is used to locate the .................

a.

Collision

b.

Root

c.

Foreign Key

d.

Records

Discuss
Answer: (b).Root
Q213.
Relations produced from E - R Model will always be in ..............

a.

1 NF

b.

2 NF

c.

3 NF

d.

4 NF

Discuss
Answer: (c).3 NF
Q214.
Consider the following schedules involving two transactions.

S1 : r1(X) ; r1(Y) ; r2(X) ; r2(Y) ; w2(Y) ; w1(X)
S2 : r1(X) ; r2(X) ; r2(Y) ; w2(Y) ; r1(Y) ; w1(X)

Which one of the following statements is correct with respect to above?

a.

Both S1 and S2 are conflict serializable.

b.

Both S1 and S2 are not conflict serializable.

c.

S1 is conflict serializable and S2 is not conflict serializable.

d.

S1 is not conflict serializable and S2 is conflict serializable.

Discuss
Answer: (d).S1 is not conflict serializable and S2 is conflict serializable.
Q215.
For a database relation R(a, b, c, d) where the domains of a, b, c and d include only atomic values, and only the following functional dependencies and those that can be inferred from them hold:

a → c
b → d

The relation is in ...............

a.

First normal form but not in second normal form

b.

Second normal form but not in third normal form

c.

Third normal form

d.

BCNF

Discuss
Answer: (a).First normal form but not in second normal form
Q216.
A many-to-one relationship exists between entity sets r1 and r2. How will it be represented using functional depedencies if Pk(r) denotes the primary key attribute of relation r?

a.

Pk(r1) → Pk(r2)

b.

Pk(r2) → Pk(r1)

c.

Pk(r2) → Pk(r1) and Pk(r1) → Pk(r2)

d.

Pk(r2) → Pk(r1) or Pk(r1) → Pk(r2)

Discuss
Answer: (a).Pk(r1) → Pk(r2)
Q217.
Database systems that store each relation in a separate operating system file may use the operating system’s authorization scheme, instead of defining a special scheme themselves. In this case, which of the following is false?

a.

The administrator enjoys more control on the grant option.

b.

It is difficult to differentiate among the update, delete and insert authorizations.

c.

Cannot store more than one relation in a file.

d.

Operations on the database are speeded up as the authorization procedure is carried out at the operating system level.

Discuss
Answer: (a).The administrator enjoys more control on the grant option.
Q218.
Let R1(a, b, c) and R2(x, y, z) be two relations in which a is the foreign key of R1 that refers to the primary key of R2. Consider following four options.

(a) Insert into R1 (b) Insert into R2
(c) Delete from R1 (d) Delete from R2

Which of the following is correct about the referential integrity constraint with respect to above?

a.

Operations (a) and (b) will cause violation.

b.

Operations (b) and (c) will cause violation.

c.

Operations (c) and (d) will cause violation.

d.

Operations (d) and (a) will cause violation.

Discuss
Answer: (d).Operations (d) and (a) will cause violation.
Q219.
Consider a hash table of size seven, with starting index zero, and a hash function (7x+3) mod 4. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Here “__” denotes an empty location in the table.

a.

3, 10, 1, 8, __, __, __

b.

1, 3, 8, 10, __, __, __

c.

1, __, 3, __, 8, __, 10

d.

3, 10, __, __, 8, __, __

Discuss
Answer: (a).3, 10, 1, 8, __, __, __
Q220.
Which of the following is/are true with reference to 'view' in DBMS?

(a) A 'view' is a special stored procedure executed when certain event occurs.
(b) A 'view' is a virtual table, which occurs after executing a pre-compiled query.

a.

Only (a) is true

b.

Only (b) is true

c.

Both (a) and (b) are true

d.

Neither (a) nor (b) are true

Discuss
Answer: (b).Only (b) is true
Page 22 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!

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

C# programming

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

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

Software Architecture and Design

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

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

Computer Architecture

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

CompTIA PenTest+ Certification Exam PT0 002

Prepare for the CompTIA PenTest+ PT0-002 exam with our targeted MCQs. Covering...

IT Fundamentals

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

Compiler Design

Unravel the process of translating source code into executable programs with our...