Previous Year Questions

Q421 MCQ GATE CS Medium 2 Marks 2020

DBMS → Relational Design

Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following statements is TRUE?

Choose One:

A) R has a nontrivial functional dependency X -> A, where X is not a superkey and A is a prime attribute.

B) R has a nontrivial functional dependency X -> A, where X is not a superkey and A is a non-prime attribute and X is not a proper subset of any key.

C) R has a nontrivial functional dependency X -> A where X is not a superkey and A is a non-prime attribute and X is a proper subset of some key.

D) A cell in R holds a set instead of an atomic value.

Q422 MCQ GATE CS Hard 2 Marks 2020

DBMS → Concurrency Control

Consider a schedule of transactions T1 and T2: T1: RA, RC, WD, WB, Commit. T2: RB, WB, RD, WC, Commit. Here, RX stands for Read(X) and WX stands for Write(X). Which one of the following schedules is conflict equivalent to the above schedule?

Choose One:

A) T1: RA, RC, WD, WB, Commit. T2: RB, WB, RD, WC, Commit.

B) T1: RA, RC, WD, WB, Commit. T2: RB, WB, RD, WC, Commit.

C) T1: RA, RC, WD, WB, Commit. T2: RB, WB, RD, WC, Commit.

D) T1: RA, RC, WD, WB, Commit. T2: RB, WB, RD, WC, Commit.

Q423 MCQ GATE CS Medium 1 Mark 2020

DBMS → SQL

Consider a relational database containing the following schemas. Catalogue(sno, pno, cost), Suppliers(sno, sname, location), Parts(pno, pname, part_spec). SELECT s.sno, s.sname FROM Suppliers s, Catalogue c WHERE s.sno = c.sno AND cost > (SELECT AVG (cost) FROM Catalogue WHERE pno = 'P4' GROUP BY pno); The number of rows returned by the above SQL query is

Choose One:

A) 4

B) 5

C) 0

D) 2

Q424 MCQ GATE CS Medium 1 Mark 2020

DBMS → SQL

Consider a relational database containing the following schemas. Catalogue(sno, pno, cost), Suppliers(sno, sname, location), Parts(pno, pname, part_spec). SELECT s.sno, s.sname FROM Suppliers s, Catalogue c WHERE s.sno = c.sno AND cost > (SELECT AVG (cost) FROM Catalogue WHERE pno = 'P4' GROUP BY pno); The number of rows returned by the above SQL query is

Choose One:

A) 4

B) 5

C) 0

D) 2

Q425 MCQ GATE CS Hard 2 Marks 2020

DL → Number Representation

Consider three registers R1, R2, and R3 that store numbers in IEEE-754 single precision floating point format. Assume that R1 and R2 contain the values (in hexadecimal notation) 0x42200000 and 0xC1200000, respectively. If R3 = R1/R2, what is the value stored in R3?

Choose One:

A) 0x40800000

B) 0xC0800000

C) 0x83400000

D) 0xC8500000

PYQBOOK

Filter Questions

Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following statements is TRUE?

Choose One:

Consider a schedule of transactions T1 and T2: T1: RA, RC, WD, WB, Commit. T2: RB, WB, RD, WC, Commit. Here, RX stands for Read(X) and WX stands for Write(X). Which one of the following schedules is conflict equivalent to the above schedule?

Choose One:

Choose One:

Choose One:

Consider three registers R1, R2, and R3 that store numbers in IEEE-754 single precision floating point format. Assume that R1 and R2 contain the values (in hexadecimal notation) 0x42200000 and 0xC1200000, respectively. If R3 = R1/R2, what is the value stored in R3?

Choose One: