112 multiple-choice questions on NSCT: Databases from Computer Science, each with the correct answer and, where available, a teacher's explanation. Read through them to revise the chapter, then practise the same questions one by one to test yourself.
76. Using the tables below, what does this query return? sql SELECT COUNT() FROM (SELECT city FROM student UNION ALL SELECT city FROM student WHERE dept = 'AI'); student id name dept cgpa city --------------- 1 Ali CS 3.4 Lahore 2 Sara SE 3.8 Karachi 3 Usman CS 2.9 Lahore 4 Hina AI 3.6 Islamabad 5 Bilal SE 3.1 Lahore 6 Ayesha CS 3.9 Karachi 7 Zain AI NULL Quetta
10
8
9
11
Answer: C) 9
Explanation: Running the query on the given data returns: 9. Lesson 4.2 · Databases
81. Using the tables below, what does this query return? sql SELECT ROUND(AVG(cgpa), 2) FROM student WHERE dept = 'CS'; student id name dept cgpa city --------------- 1 Ali CS 3.4 Lahore 2 Sara SE 3.8 Karachi 3 Usman CS 2.9 Lahore 4 Hina AI 3.6 Islamabad 5 Bilal SE 3.1 Lahore 6 Ayesha CS 3.9 Karachi 7 Zain AI NULL Quetta
3.4
3.5
3.6
3.3
Answer: A) 3.4
Explanation: Running the query on the given data returns: 3.4. Lesson 4.2 · Databases
89. Using the tables below, what does this query return? sql SELECT COUNT() FROM (SELECT city FROM student UNION SELECT city FROM student WHERE dept = 'AI'); student id name dept cgpa city --------------- 1 Ali CS 3.4 Lahore 2 Sara SE 3.8 Karachi 3 Usman CS 2.9 Lahore 4 Hina AI 3.6 Islamabad 5 Bilal SE 3.1 Lahore 6 Ayesha CS 3.9 Karachi 7 Zain AI NULL Quetta
6
4
3
5
Answer: B) 4
Explanation: Running the query on the given data returns: 4. Lesson 4.2 · Databases
97. Using the tables below, what does this query return? sql SELECT name FROM student WHERE cgpa 3.5 ORDER BY cgpa DESC; student id name dept cgpa city --------------- 1 Ali CS 3.4 Lahore 2 Sara SE 3.8 Karachi 3 Usman CS 2.9 Lahore 4 Hina AI 3.6 Islamabad 5 Bilal SE 3.1 Lahore 6 Ayesha CS 3.9 Karachi 7 Zain AI NULL Quetta
Ayesha, Sara
Ayesha, Sara, Hina, Ali
Ayesha, Sara, Zain
Ayesha, Sara, Hina
Answer: D) Ayesha, Sara, Hina
Explanation: Running the query on the given data returns: Ayesha, Sara, Hina. Lesson 4.2 · Databases