Telangana SET (TG SET) Database Management Systems Previous Year Questions
Try the preview and open any solution for a worked explanation.
Telangana SET (TG SET) practice pack
The practice pack for Telangana SET (TG SET) is coming soon to LawMint.
Question 1
Consider the database Integrity constraints on database entities in List I and the corresponding purposes in the List II.
| List I (Integrity Constraint) | List II (Purpose) |
| a. Domain Integrity | i. Enforces application-specific business rules |
| b. Entity Integrity | ii. Maintains consistency between related tables |
| c. Referential Integrity | iii. Ensures each row is uniquely identifiable |
| d. User-Defined (Semantic) Integrity | iv. Ensures that attribute values are valid |
Question 2
The trade-off between database design efficiency, information requirements, and query processing performance is often addressed by:
Question 3
Which one of the following statements correctly describes the Rigorous 2-Phase Locking protocol (Rigorous 2PL)?
Question 4
Consider the following relation schemas:
• Employee(Eid, Ename, Dno, Salary, Address)
• Department(Dno, Dname)
What is the output of the following SQL query?
SELECT Dname, COUNT(*) FROM Department D, Employee E
WHERE D.Dno = E.Dno AND E.Salary > 4000
GROUP BY Dname HAVING COUNT(*) > 5;
Question 5
A company stores customer purchase data in a data warehouse and wants to analyse sales by year, region, and product category from different perspectives. Which technology is most appropriate?
Question 6
An e-commerce company processes petabytes of clickstream data distributed across hundreds of servers. The computation is divided into map tasks and reduce (aggregation) tasks. Which of the following frameworks is most suitable for this type of large-scale data processing?
Question 7
Consider the following schedule involving two transactions:
| Time | Transaction |
| 1 | T1: Read(A) |
| 2 | T2: Read(A) |
| 3 | T1: Write(A) |
| 4 | T2: Write(A) |
Question 8
Consider the ACID properties of transactions listed in List I and the corresponding mechanisms or entities primarily responsible for ensuring them listed in List II.
| List I (ACID Properties) | List II (Mechanism) |
| a. Atomicity | i. Concurrency Control |
| b. Consistency | ii. Undo Log |
| c. Isolation | iii. Application Programmer |
| d. Durability | iv. Redo Log |
Question 9
Consider a relation R(K,A,B,C) in which K is the super key. Also, consider the following functional dependencies.
I. K→{A, B, C}
II. K→C
III. A→B
IV. B→C
Which of the above functional dependencies are guaranteed to hold for the relation?
Question 10
Which one of the following statements about NoSQL databases is generally true?
Previous papers with Database Management Systems questions
Telangana SET (TG SET) practice pack
The practice pack for Telangana SET (TG SET) is coming soon to LawMint.