LawMint Sign in

Himachal Pradesh SET (HP SET) Database Management Systems Previous Year Questions

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

Himachal Pradesh SET (HP SET) practice pack

The practice pack for Himachal Pradesh SET (HP SET) is coming soon to LawMint.

Question 1

Consider the below relations :
(i) R (A, B, C, D) & F = {A → B, B → C, C → D}
(ii) R (A, B, C, D, E) & F = {A → BC, CD → E, B → D, E → A}
(iii) R (A, B, C, D) & F = {A → B, B → C, C → A}
Arrange the above relations w.r.t. the number of candidate keys they have in ascending order.

Select one answer

Question 2

Student and course enrolled, is an example of :

Select one answer

Question 3

Match List-I with List-II:

List-IList-II
(a) Normalization(i) Contains metadata describing database structure
(b) Data dictionary(ii) Enforce match of primary key to foreign key
(c) Referential integrity(iii) Defines view(s) of the database for particular user(s)
(d) External schema(iv) Reduces data redundancy in a database
Select one answer

Question 4

Given the following statements :
(i) Mining knowledge in multidimensional space.
(ii) Handling uncertainty, noise or incompleteness of data.
(iii) Pattern evaluation and finding of hidden truths.
How many of these statements describe aspects of data mining methodologies?

Select one answer

Question 5

Given below are two statements :
(I) NOSQL databases support vertical scalability but do not support horizontal scalability.
(II) NOSQL databases are suitable for structured, semi-structured as well as unstructured data.
Which statements are correct?

Select one answer

Question 6

In wait-die scheme, transactions T1 and T2 have timestamps 6 and 13 respectively. If T1 requests a data item held by T2 then :

Select one answer

Question 7

For a database relation R (a, b, c, d), the domains of a, b, c and d include only atomic values, and the functional dependencies a → c and b → d hold. The relation is in:

Select one answer

Question 8

Which level of Abstraction describes how data are stored in the database ?

Select one answer

Question 9

Which of these properties characterize a weak entity type?
(i) It must have total participation in an identifying relationship.
(ii) It does not have a key attribute(s).

Select one answer

Question 10

A rule that states that in a base relation, the value of attribute of a primary key cannot be null is :

Select one answer

Continue practising

The practice pack for Himachal Pradesh SET (HP SET) is coming soon to LawMint.

Himachal Pradesh SET (HP SET) practice pack

The practice pack for Himachal Pradesh SET (HP SET) is coming soon to LawMint.