Question 1
48
32
64
16
Question 2
not in 2NF
in 2NF but not in 3NF
in 3NF but not in 2NF
in both 2NF and 3NF
Question 3
Consider the following table 1:
| Country | Player | Runs | Wickets |
|---|---|---|---|
| India | Sharma | a | b |
| India | Pandya | c | 23 |
| India | Sharma | 676 | 20 |
| India | Pandya | 500 | 23 |
Table 1: Scorecard
Choose the correct values of a, b, and c such that the following MVD is true:
a: 500, b: 23, c: 676
a: 676, b: 20, c: 500
a: 500, b: 23, c: 500
a: 500, b: 20, c: 676
11 more questions in this paper
Sign in with Google — it is free — to see every question with its answer and explanation, practise it in learning mode, or take it as a timed mock test.
More on the DBMS Quiz 2 4 Aug 2024 paper
The IIT Madras BS Database Management Systems (DBMS) Quiz 2 paper sat on 4 Aug 2024, in the May 2024 term: 14 questions for 50 marks in 120 minutes. The first 3 questions are below. Sign in with Google — it is free — to see the whole paper with its answers and explanations, in learning mode or as a timed mock test.
| Feature | DBMS Quiz 2 4 Aug 2024 at a glance |
|---|---|
| Term | May 2024 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 14 |
| Marks | 50 |
| Duration | 120 min |
| MCQ | 10 |
| MSQ | 4 |
| Official paper | IIT M DIPLOMA AN EXAM QDD2 4 Aug 2024 |
| Negative marking | No negative marking. |
| Updated |