Consider the following table:
| PlayerID | PlayerName | Team | Runs |
|---|---|---|---|
| 001 | Virat | India | 100 |
| 002 | Rohit | India | 100 |
| 003 | Smith | Australia | 70 |
| 004 | Jason | England | 60 |
| 005 | Rohit | Bangladesh | 65 |
| 006 | Asif | Pakistan | 50 |
| 007 | Smith | Newzealand | 70 |
Table 1: Players
Which of the following functional dependencies hold in the Players table? [MSQ]
2 NF
1 NF
3 NF
BCNF
Consider a magnetic disk with 4 platters, 2 surfaces per platter, 1024 tracks per surface, and 2048 sectors per track, with a disk capacity of 8 GB. Find the capacity of one sector.
2048 bytes per sector
1024 bytes per sector
512 bytes per sector
256 bytes per sector
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.
The IIT Madras BS Database Management Systems (DBMS) Quiz 2 paper sat on 3 Dec 2023, in the September 2023 term: 15 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 3 Dec 2023 at a glance |
|---|---|
| Term | September 2023 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 15 |
| Marks | 50 |
| Duration | 120 min |
| MSQ | 4 |
| MCQ | 9 |
| Numerical | 2 |
| Official paper | IIT M DIPLOMA AN2 EXAM QDD2 03 Dec 2023 |
| Negative marking | No negative marking. |
| Updated |
