West Bengal SET (WB SET) Database Management Systems Previous Year Questions
Try the preview and open any solution for a worked explanation.
West Bengal SET (WB SET) practice pack
The practice pack for West Bengal SET (WB SET) is coming soon to LawMint.
Question 1
Data scrubbing is
Question 2
Consider a market basket data with 100 transactions. The association rule A → B has a support value of 30, and confidence value of 60%. In how many transactions has the item A been purchased?
Question 3
In a data warehouse (OLAP), the write performance is slower than in OLTP systems. Why?
Question 4
Consider the following ER diagram.

Assume the following data:
(i) There are 10 departments, each with exactly 20 employees.
(ii) There are 30 projects.
(iii) Each employee is assigned to exactly 3 distinct projects.
How many tuples will be there in the “Assigned To” relation and “Works For” relation, respectively?
Question 5
Which of the following equivalences in relational algebra is incorrect? [Assume the condition θ is applied on attributes of R only.]
Question 6
Which of the following ensures atomicity in a DBMS?
Question 7
A table with attributes (Student ID, Course ID, Instructor, Grade) has the following functional dependencies:
{Student ID, Course ID} → {Grade}
{Course ID} → {Instructor}
To remove redundancy, you normalize the table. How many tables will be in the 3NF decomposition?
Question 8
Which of the following is not true about lossless join decomposition?
Question 9
Which of the following is true regarding HAVING clause in SQL?
Question 10
__________ are not a data mining functionality.
Previous papers with Database Management Systems questions
West Bengal SET (WB SET) practice pack
The practice pack for West Bengal SET (WB SET) is coming soon to LawMint.