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.
101. INSERT, UPDATE and DELETE belong to:
TCL
DCL
DML
DDL
Answer: C) DML
Explanation: Data Manipulation Language changes rows. Lesson 4.2 · Databases
103. Using the tables below, what does this query return? sql SELECT name FROM student WHERE id IN (SELECT sid FROM enrol WHERE code = 'CS201') ORDER BY name; 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 enrol (sid, code, marks): (1, CS101, 78), (1, CS201, 65), (2, CS201, 88), (3, CS101, 55), (4, AI401, 91), (6, CS201, 72), (6, CS301, 80), (5, CS101, 60) course (code, title, credits): (CS101, Programming, 4), (CS201, Databases, 3), (CS301, Networks, 3), (AI401, Machine Learning, 3)
Ali, Ayesha, Sara, Usman
Ali, Ayesha
Ali, Ayesha, Sara
Ali, Ayesha, Zain
Answer: C) Ali, Ayesha, Sara
Explanation: Running the query on the given data returns: Ali, Ayesha, Sara. Lesson 4.2 · Databases
107. Using the tables below, what does this query return? sql SELECT name FROM student ORDER BY name LIMIT 2; 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
Ali
Ali, Ayesha, Sara
Ali, Zain
Ali, Ayesha
Answer: D) Ali, Ayesha
Explanation: Running the query on the given data returns: Ali, Ayesha. Lesson 4.2 · Databases
111. Using the tables below, what does this query return? sql SELECT COUNT(cgpa) FROM student; 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
8
6
7
5
Answer: B) 6
Explanation: Running the query on the given data returns: 6. Lesson 4.2 · Databases