LawMint Sign in

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 Integrityi. Enforces application-specific business rules
b. Entity Integrityii. Maintains consistency between related tables
c. Referential Integrityiii. Ensures each row is uniquely identifiable
d. User-Defined (Semantic) Integrityiv. Ensures that attribute values are valid
Which one of the following gives the correct matching?

Select one answer

Question 2

The trade-off between database design efficiency, information requirements, and query processing performance is often addressed by:

Select one answer

Question 3

Which one of the following statements correctly describes the Rigorous 2-Phase Locking protocol (Rigorous 2PL)?

Select one answer

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;

Select one answer

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?

Select one answer

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?

Select one answer

Question 7

Consider the following schedule involving two transactions:

TimeTransaction
1T1: Read(A)
2T2: Read(A)
3T1: Write(A)
4T2: Write(A)
Which of the following concurrency anomalies may occur in this schedule?

Select one answer

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. Atomicityi. Concurrency Control
b. Consistencyii. Undo Log
c. Isolationiii. Application Programmer
d. Durabilityiv. Redo Log
Which one of the following gives the correct matching?

Select one answer

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?

Select one answer

Question 10

Which one of the following statements about NoSQL databases is generally true?

Select one answer

Continue practising

The practice pack for Telangana SET (TG SET) is coming soon to LawMint.

Telangana SET (TG SET) practice pack

The practice pack for Telangana SET (TG SET) is coming soon to LawMint.