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.
Question 2
Student and course enrolled, is an example of :
Question 3
Match List-I with List-II:
| List-I | List-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 |
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?
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?
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 :
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:
Question 8
Which level of Abstraction describes how data are stored in the database ?
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).
Question 10
A rule that states that in a base relation, the value of attribute of a primary key cannot be null is :
Previous papers with Database Management Systems questions
Himachal Pradesh SET (HP SET) practice pack
The practice pack for Himachal Pradesh SET (HP SET) is coming soon to LawMint.