LawMint Sign in

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

Select one answer

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?

Select one answer

Question 3

In a data warehouse (OLAP), the write performance is slower than in OLTP systems. Why?

Select one answer

Question 4

Consider the following ER diagram.

ER diagram. Entity Department (key Dept ID, attribute Dept Name) is linked with cardinality 1 to relationship Works For, which is linked with cardinality N to entity Employee (key Emp ID, attributes Emp Name, Salary). Employee is linked with cardinality M to relationship Assigned To, which is linked with cardinality N to entity Project (key Proj ID, attribute Proj Name).

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?

Select one answer

Question 5

Which of the following equivalences in relational algebra is incorrect? [Assume the condition θ is applied on attributes of R only.]

Select one answer

Question 6

Which of the following ensures atomicity in a DBMS?

Select one answer

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?

Select one answer

Question 8

Which of the following is not true about lossless join decomposition?

Select one answer

Question 9

Which of the following is true regarding HAVING clause in SQL?

Select one answer

Question 10

__________ are not a data mining functionality.

Select one answer

Continue practising

The practice pack for West Bengal SET (WB SET) is coming soon to LawMint.

West Bengal SET (WB SET) practice pack

The practice pack for West Bengal SET (WB SET) is coming soon to LawMint.