Choose the correct order of execution of SQL clauses.
FROM → WHERE → HAVING → GROUP BY→ SELECT → ORDER BY
FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY
SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY
SELECT → FROM → WHERE → ORDER BY →GROUP BY → HAVING
Consider a magnetic disk with 16 platters, 2 surfaces/platter, 1024 tracks/surface, 2048 sectors/track, and 1024 bytes/sector. The disk rotates with 6000 revolutions per minute. What is the capacity of the disk?
64 GB
32 GB
32 MB
64 MB
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) End Term paper sat on 30 Apr 2023, in the January 2023 term, set QPD1-S1: 25 questions for 50 marks in 180 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 End Term 30 Apr 2023 Set QPD1-S1 at a glance |
|---|---|
| Term | January 2023 term |
| Subject | Database Management Systems |
| Course code | BSCS2001 |
| Questions | 25 |
| Marks | 50 |
| Duration | 180 min |
| MCQ | 14 |
| MSQ | 7 |
| Numerical | 4 |
| Official paper | IIT M DIPLOMA ET1 EXAM QPD1 S2 30 Apr 2023 |
| Negative marking | No negative marking. |
| Updated |
