NDOLA TRUST SCHOOL
COMPUTER STUDIES MARKS = 40
GRADE 12 SCHOOL BASED ASSESSMENT - 4
Multiple Choice questions – 40 marks
1. What does SQL stand for?
a. Strong question language.
b. Structural query language.
c. Structured query language.
d. None of the above.
2. Which SQL statement is used to extract data from a database?
a. OPEN
b. EXTRACT
c. SELECT
d. GET
3. Which SQL statement is used to update data in a database?
a. UPDATE
b. MODIFY
c. SAVE AS
d. SAVE
4. Which SQL statement is used to delete data from a database?
A. REMOVE
B. COLLAPSE
C. DELETE
D. None of the above.
5. Which SQL statement is used to insert new data in a database?
a. ADD NEW
b. INSERT INTO
c. INSERT NEW
d. ADD RECORD
6. With SQL, how do you select a column named “First Name” from a table named “persons”?
a. Select Persons.FirstName.
b. Extract FirstName from Persons.
c. Select FirstName from Persons
d. Select Persons, FirstName
7. With SQL, how do you select all the columns from a table named “persons”?
a. Select [all] from Persons.
b. Select Persons
c. Select * from Persons
d. Select *Persons
8. With SQL, how do you select all the records from a table named “Person”, where the value of the
column “FirstName” is Peter?
a. Select[all] from persons where FirstName like “Peter”
b. Select from perons where FirstName < > ‘Peter’
c. Select *from Persons where FirstName = ‘Peter’
d. Select [all] from Persons where FirstName =’Peter’
9. Which SQL statement is used to return only different values?
a. SELECT UNIQUE
b. SELECT DISTINCT
c. SELECT DIFFERENT
d. SELECT VALUES
10. With SQL, how can you insert a record into the “Persons”table?
a. INSERT values (‘Jimmy, ‘Jackson) INTO Persons
b. INSERT (‘Jimmy’,’jackson’) INTO ‘Persons’
c. INSERT INTO Persons values (‘Jimmy’,’Jackson’)
11. What is the purpose of the SQL GROUP BY clause?
a) To filter rows based on specific condition
b) To sort the results in ascending order
c) To group rows with the same values into summary rows
d) To join two or more tables
12. Which SQL statement is used to insert data into a database table?
a) ADD
b) INSERT
c) UPDATE
d) CREATE
13. Which SQL command is used to make permanent changes to a database?
a) COMMIT
b) ROLLBACK
c) SAVEPOINT
d) ALTER
14. What is the purpose of the SQL ORDER BY clause?
a) To filter rows based on specific conditions
b) To sort the results in ascending or descending order
c) To group rows with the same values into summary rows
d) To join two or more tables
15. Which SQL function is used to count the number of rows in a table?
a) COUNT
b) SUM
c) AVG
d) MAX
16. Which SQL statement is used to update existing data in a database table?
a) ALTER
b) MODIFY
c) UPDATE
d) CHANGE
17. Which SQL command is used to remove a database table?
a) REMOVE
b) DELETE
c) DROP
d) ERASE
18. Which SQL function is used to find the highest value in a column?
a) TOP
b) MAX
c) HIGHEST
d) UPPER
19. Which SQL statement is used to delete data from a database table?
a) DELETE
b) REMOVE
c) ERASE
d) DROP
20. Which SQL statement is used to add a new column to a database table?
a) ADD COLUMN
b) ALTER TABLE
c) CREATE COLUMN
d) INSERT COLUMN
