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?
Question 2
Consider the following relations P(X, Y, Z), Q(X,Y,T) and R(Y,V)
P
| X | Y | Z |
| X1 | Y1 | Z1 |
| X1 | Y1 | Z2 |
| X2 | Y2 | Z2 |
| X2 | Y4 | Z4 |
| X | Y | T |
| X2 | Y1 | 2 |
| X1 | Y2 | 5 |
| X1 | Y1 | 6 |
| X3 | Y3 | 1 |
| Y | V |
| Y1 | V1 |
| Y3 | V2 |
| Y2 | V3 |
| Y2 | V2 |
ΠX(σ(P.Y = R. Y ∧ R.V = "V2")(P × R))–
ΠX(σ(Q.Y = R.Y ∧ Q. T > 2)(Q × R))
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?
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)?
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?
Question 6
If a relation R is decomposed into R1 and R2, we say the decomposition is lossless if
Question 7
In a MapReduce job, what is the purpose of the combiner function?
Question 8
In a Write-Ahead Logging (WAL) protocol, which of the following must happen before an actual database write?
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 ?
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 ?
Previous papers with Database Management Systems questions
Gujarat SET (GSET) practice pack
The practice pack for Gujarat SET (GSET) is coming soon to LawMint.