Opening the paper…

Database Management Systems, End Term

January 2023 term, 30 Apr 2023, Set QPD1-S1

Learning mode

Question 1

+2−0Single correct

Choose the correct order of execution of SQL clauses.

Select one option

A.
FROM → WHERE → HAVING → GROUP BY→ SELECT → ORDER BY
B.
FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY
C.
SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY
D.
SELECT → FROM → WHERE → ORDER BY →GROUP BY → HAVING

Report a problem

to report a problem with this question.

Choose a question

Answered: 0
Not answered: 1
Marked for review: 0
Answered & marked for review: 0
Not visited: 24

Discussion

Submit this paper?

You cannot change your answers after submitting.

Answered: 0
Not answered: 1
Marked for review: 0
Answered & marked for review: 0
Not visited: 2

Instructions

The palette shows the status of every question. Pick a number to go straight to it.

Answered: 0
Not answered: 1
Marked for review: 0
Answered & marked for review: 0
Not visited: 2

Save & Next moves to the next question. Answers are saved as you go.
Mark for Review & Next flags the question to come back to. A flagged answer still counts.
Clear Response removes your answer to the question on screen.
The ← and → keys move to the previous and next question.

Choose the correct order of execution of SQL clauses. 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? Figure from the original question paper