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.
51. Using the tables below, what does this query return? sql SELECT COUNT() FROM student, course; 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
30
27
28
29
Answer: C) 28
Explanation: Running the query on the given data returns: 28. Lesson 4.2 · Databases
55. Using the tables below, what does this query return? sql SELECT dept FROM student GROUP BY dept ORDER BY AVG(cgpa) DESC LIMIT 1; 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
SE
AI
NULL
CS
Answer: B) AI
Explanation: Running the query on the given data returns: AI. Lesson 4.2 · Databases
58. Using the tables below, what does this query return? sql SELECT COUNT() FROM student WHERE city = 'Lahore'; 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
5
2
Answer: A) 3
Explanation: Running the query on the given data returns: 3. Lesson 4.2 · Databases
60. Using the tables below, what does this query return? sql SELECT city FROM student GROUP BY city ORDER BY COUNT() DESC LIMIT 1; 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
Karachi
Lahore
Islamabad
Quetta
Answer: B) Lahore
Explanation: Running the query on the given data returns: Lahore. Lesson 4.2 · Databases
73. Using the tables below, what does this query return? sql SELECT COUNT() FROM student WHERE NOT (dept = 'CS' OR city = 'Lahore'); 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
2
5
Answer: A) 3
Explanation: Running the query on the given data returns: 3. Lesson 4.2 · Databases
75. Using the tables below, what does this query return? sql SELECT name FROM student WHERE name LIKE '%a'; 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
Sara, Hina, Ayesha
Sara, Hina
Sara, Hina, Ayesha, Ali
Sara, Hina, Zain
Answer: A) Sara, Hina, Ayesha
Explanation: Running the query on the given data returns: Sara, Hina, Ayesha. Lesson 4.2 · Databases