Rajasthan SET (RSET) Database Management Systems Previous Year Questions
Try the preview and open any solution for a worked explanation.
Rajasthan SET (RSET) practice pack
The practice pack for Rajasthan SET (RSET) is coming soon to LawMint.
Question 1
Which of the following statements are true ?
(a) If R is in 3NF and every key is simple, then R is in BCNF.
(b) The reverse of the above statement is true.
(c) If X, Y, Z are sets of attributes and if and then
Question 2
Which of the following schedules is conflict serializable ?
Question 3
A database security policy requires that users assigned to the Manager role must be able to view all data within the Employee relation, but their modification permissions must be restricted exclusively to updating employee compensation. Which of the following SQL statements correctly implements this security policy ?
Question 4
A super key is a set of one or more attributes that, taken collectively, allows us to :
Question 5
What core components must be defined to establish a trigger in a database system ?
Question 6
Which of the following NoSQL data models does NOT share the characteristic of “aggregate orientation” ?
Question 7
The machine that stores data blocks in Hadoop Distributed File System (HDFS) is called
Question 8
Match the following :
| Type of NoSQL system | Example of database |
|---|---|
| a. Key-value store | i. Apache Cassandra |
| b. Document Database | ii. Neo4j |
| c. Column-family database | iii. Mongo DB |
| d. Graph database | iv. Amazon Dynamo DB |
Question 9
In Database Management System, which one of the following ACID properties ensures that once the transaction has completed its execution successfully, the updates and modifications to the database are stored in and written to disk and they persist even if a system failure occurs ?
Question 10
Which one of the following databases is often used for handling large amounts of unstructured and semi-structured data and for applications with a high degree of scalability and availability ?
Previous papers with Database Management Systems questions
Rajasthan SET (RSET) practice pack
The practice pack for Rajasthan SET (RSET) is coming soon to LawMint.