LawMint Sign in

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 X↠YX\twoheadrightarrow Y and X↠ZX\twoheadrightarrow Z then X↠(Y−Z)X\twoheadrightarrow(Y-Z)

Select one answer

Question 2

Which of the following schedules is conflict serializable ?

Select one answer

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 ?

Select one answer

Question 4

A super key is a set of one or more attributes that, taken collectively, allows us to :

Select one answer

Question 5

What core components must be defined to establish a trigger in a database system ?

Select one answer

Question 6

Which of the following NoSQL data models does NOT share the characteristic of “aggregate orientation” ?

Select one answer

Question 7

The machine that stores data blocks in Hadoop Distributed File System (HDFS) is called

Select one answer

Question 8

Match the following :

Type of NoSQL systemExample of database
a. Key-value storei. Apache Cassandra
b. Document Databaseii. Neo4j
c. Column-family databaseiii. Mongo DB
d. Graph databaseiv. Amazon Dynamo DB

Select one answer

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 ?

Select one answer

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 ?

Select one answer

Continue practising

The practice pack for Rajasthan SET (RSET) is coming soon to LawMint.

Rajasthan SET (RSET) practice pack

The practice pack for Rajasthan SET (RSET) is coming soon to LawMint.