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 GATE CSE 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 GATE CSE Exam.

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 GATE CSE 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 7 of 11

Explore more Topics under GATE CSE Exam

01

Networking

02

Operating System

03

Data Structures and Algorithms

04

Computer Architecture

05

Compiler Design

06

Theory of Computation(TOC)

07

Engineering Mathematics

Q61.

R(A,B,C,D) is a relation. Which of the following does not have a lossless join, dependency preserving BCNF decomposition?

A->B, B->CD

A->B, B->C, C->D

AB->C, C->AD

A ->BCD

Discuss

Answer: (c).AB->C, C->AD

Q62.

Consider a relation geq which represents “greater than or equal to”, that is, (x,y) ∈ geq only if y >= x.

create table geq
(
ib integer not null
ub integer not null
primary key 1b
foreign key (ub) references geq on delete cascade
)

Which of the following is possible if a tuple (x,y) is deleted?

A tuple (z,w) with z > y is deleted

A tuple (z,w) with z > x is deleted

A tuple (z,w) with w < x is deleted

The deletion of (x,y) is prohibited

Discuss

Answer: (c).A tuple (z,w) with w < x is deleted

Q63.

Given the following relation instance.

x y z
1 4 2
1 5 3
1 6 3
3 2 2

Which of the following functional dependencies are satisfied by the instance? (GATE CS 2000)

XY -> Z and Z -> Y

YZ -> X and Y -> Z

YZ -> X and X -> Z

XZ -> Y and Y -> X

Discuss

Answer: (b).YZ -> X and Y -> Z

Q64.

Consider the relation X(P, Q, R, S, T, U) with the following set of functional dependencies

F = {
{P, R} → {S,T},
{P, S, U} → {Q, R}
}

Which of the following is the trivial functional dependency in F+ is closure of F?

{P,R}→{S,T}

{P,R}→{R,T}

{P,S}→{S}

{P,S,U}→{Q}

Discuss

Answer: (c).{P,S}→{S}

Q65.

A relational database contains two tables student and department in which student table has columns roll_no, name and dept_id and department table has columns dept_id and dept_name. The following insert statements were executed successfully to populate the empty tables:

Insert into department values (1, 'Mathematics')
Insert into department values (2, 'Physics')
Insert into student values (l, 'Navin', 1)
Insert into student values (2, 'Mukesh', 2)
Insert into student values (3, 'Gita', 1)

How many rows and columns will be retrieved by the following SQL statement?

Select * from student, department

0 row and 4 columns

3 rows and 4 columns

3 rows and 5 columns

6 rows and 5 columns

Discuss

Answer: (d).6 rows and 5 columns

Q66.

A table has fields Fl, F2, F3, F4, F5 with the following functional dependencies F1 → F3 F2→ F4 (F1 . F2) → F5 In terms of Normalization, this table is in

1 NF

2 NF

3 NF

none of the above

Discuss

Answer: (a).1 NF

Q67.

Which of the following is NOT a superkey in a relational schema with attributes V, W, X, Y, Z and primary key V Y ?

V X Y Z

V W X Z

V W X Y

V W X Y Z

Discuss

Answer: (b).V W X Z

Q68.

Let R (A, B, C, D, E, P, G) be a relational schema in which the following functional dependencies are known to hold: AB → CD, DE → P, C → E, P → C and B → G. The relational schema R is

in BCNF

in 3NF, but not in BCNF

in 2NF, but not in 3NF

not in 2NF

Discuss

Answer: (d).not in 2NF

Q69.

Which option is true about the SQL query given below?

SELECT firstName, lastName
FROM Employee
WHERE lastName BETWEEN 'A%' AND 'D%';

It will display all the employees having last names starting with the alphabets 'A' till 'D' inclusive of A and exclusive of D.

It will throw an error as BETWEEN can only be used for Numbers and not strings.

It will display all the employees having last names starting from 'A' and ending with 'D'.

It will display all the employees having last names in the range of starting alphabets as 'A' and 'D' excluding the names starting with 'A' and 'D'.

Discuss

Answer: (a).It will display all the employees having last names starting with the alphabets 'A' till 'D' inclusive of A and exclusive of D.

Q70.

Which of the given options define a transaction correctly?

A transaction consists of DDL statements on the database schema.

A transaction consists of COMMIT or ROLLBACK in a database session.

A transaction consists of either a collection of DML statements or a DDL or DCL or TCL statement to form a logical unit of work in a database session.

A transaction consists of collection of DML and DDL statements in different sessions of the database.

Discuss

Answer: (c).A transaction consists of either a collection of DML statements or a DDL or DCL or TCL statement to form a logical unit of work in a database session.

Page 7 of 11

Welcome to the DBMS MCQs Page

DBMS MCQs | Page 7 of 11

Explore more Topics under GATE CSE Exam

Networking

Operating System

Data Structures and Algorithms

Computer Architecture

Compiler Design

Theory of Computation(TOC)

Engineering Mathematics

Suggested Topics

Microprocessor

Human Computer Interaction

Artificial Intelligence

Python

Neural Networks

HTML

MATLAB

Digital Image Processing (DIP)

Cloud Computing