LawMint Sign in

Maharashtra and Goa SET (MH SET) Database Management Systems Previous Year Questions

Try the preview and open any solution for a worked explanation.

Maharashtra and Goa SET (MH SET) practice pack

The practice pack for Maharashtra and Goa SET (MH SET) is coming soon to LawMint.

Question 1

Among the following, which is foreign key constraint ?

Select one answer

Question 2

Which of the following represents a query in the tuple relational calculus?

Select one answer

Question 3

A set of one or more attributes which, taken collectively, allow us to uniquely identify an entity in the entity set is called __________.

Select one answer

Question 4

The future trends and behaviors (For business managers to make proactive knowledge-driven decisions) can be predicted by :

Select one answer

Question 5

Which NoSQL database is known for its ability to handle complex queries and data analysis ?

Select one answer

Question 6

Let R = (M N O P Q) be a relational scheme with functional dependency
F = {M → N, N → O, MO → P}
Then closures of Q and M are :

Select one answer

Question 7

The __________ file organization provides very fast access to any arbitrary record of a file.

Select one answer

Question 8

Select the correct option:

Select one answer

Question 9

An ER model of a database consists of entity types P and Q. These are connected by a relationship R, which does not have its own attributes (i.e., no self attributes).
Under which one of the following condition, can the relational table for R be merged with that of P ?

Select one answer

Question 10

A data dictionary system is called a __________ if it is used only by designers, users, and administrators and not by the DBMS software.

Select one answer

Continue practising

The practice pack for Maharashtra and Goa SET (MH SET) is coming soon to LawMint.

Maharashtra and Goa SET (MH SET) practice pack

The practice pack for Maharashtra and Goa SET (MH SET) is coming soon to LawMint.