LawMint Sign in

Gujarat SET (GSET) Database Management Systems Previous Year Questions

Try the preview and open any solution for a worked explanation.

Gujarat SET (GSET) practice pack

The practice pack for Gujarat SET (GSET) is coming soon to LawMint.

Question 1

What does logical data independence refer to?

Select one answer

Question 2

Consider the following relations P(X, Y, Z), Q(X,Y,T) and R(Y,V)
P

XYZ
X1Y1Z1
X1Y1Z2
X2Y2Z2
X2Y4Z4
Q
XYT
X2Y12
X1Y25
X1Y16
X3Y31
R
YV
Y1V1
Y3V2
Y2V3
Y2V2
How many tuples will be returned by the following relational algebra query?
ΠX(σ(P.Y = R. Y ∧ R.V = "V2")(P × R))–
ΠX(σ(Q.Y = R.Y ∧ Q. T > 2)(Q × R))

Select one answer

Question 3

If for two attributes A and B, Domain of A is subset of Domain of B; then which of the following is always true?

Select one answer

Question 4

Consider the table employees (Id, Name, Salary, Department). Which of the following SQL query filters out the departments with 5 or fewer employees (with salary > 50000)?

Select one answer

Question 5

Consider a MongoDB collection of documents with fields : _id, name, cellphone and city. Which of the following methods is correct to include only name and city in output?

Select one answer

Question 6

If a relation R is decomposed into R1 and R2, we say the decomposition is lossless if

Select one answer

Question 7

In a MapReduce job, what is the purpose of the combiner function?

Select one answer

Question 8

In a Write-Ahead Logging (WAL) protocol, which of the following must happen before an actual database write?

Select one answer

Question 9

A library database stores information about books that are frequently browsed by subject category (e.g., “Science Fiction”, “History”) and publication year ranges (e.g., “books from 2020-2024”). Librarians need to generate reports listing all books in specific categories or year ranges. Which file organization would be most appropriate ?

Select one answer

Question 10

Consider two tables Dept(dno, floorno) - containing details about departments located on which floors, and Floor(floorno) - all possible floors. Which Relational Algebraic operator would be used to find departments which are located on all the floors ?

Select one answer

Continue practising

The practice pack for Gujarat SET (GSET) is coming soon to LawMint.

Gujarat SET (GSET) practice pack

The practice pack for Gujarat SET (GSET) is coming soon to LawMint.