🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

Class 12 Computer Science Chapter 4 Structured Query Language (Sql) Quiz 4 (25 MCQs)

Quiz Instructions

Select an option to see the correct answer instantly.

1. What does the SQL statement 'DELETE FROM world WHERE population > 10000000' do?

Correct Answer: A) Deletes records from the 'world' table if their population is larger than 10 million.

2. What is a record (row) in a database table?

Correct Answer: B) A single entry in a table, consisting of data for each field within that table.

3. What is a special value in SQL that represents missing or unknown data?

Correct Answer: C) NULL.

4. Pernyataan (a) ..... dalam SQL digunakan untuk membina jadual daripada pangkalan data, manakala pernyataan (b) ..... dalam SQL digunakan untuk menghapuskan jadual daripada pangkalan data.

Correct Answer: D) CREATE b)DROP.

5. SQL query to find the temperature in increasing order of all cities.

Correct Answer: D) SELECT city, temperature FROM weather ORDER BY city.

6. WHICH QUERY?defines the list of search criteria

Correct Answer: C) WHERE.

7. The ..... consists of commands used to query or retrieve data from a database.

Correct Answer: B) Data Query Language.

8. What is the main purpose of a relational database?

Correct Answer: B) To organise data into related tables and link data across tables.

9. Which command is used to add a new field to an existing table in SQL?

Correct Answer: A) Alter table.

10. Which SQL command is used to select specific data from a table?

Correct Answer: D) SELECT.

11. What does a NULL value represent in SQL?

Correct Answer: B) It is treated as a non-existent value.

12. Select SQL command to insert values in COURSE table.

Correct Answer: D) INSERT INTO COURSE VALUES ("DFC20203", "Database Design");.

13. Which of the following scripts will run successfully?

Correct Answer: A) SELECT customer name FROM customers;.

14. "INSERT INTO" is the keyword used to insert data into tables.

Correct Answer: A) True.

15. What can you do with SQL besides the commands mentioned?

Correct Answer: D) All of the above.

16. What is missing in this code? SELECT * FROM WHERE genre = 'action' ORDER BY year ASC;

Correct Answer: B) Table name.

17. What is the SQL keyword that reconnects rows with foreign keys with the corresponding data in the table that the foreign key points to?

Correct Answer: D) JOIN.

18. What does the SQL command 'SELECT *' do?

Correct Answer: A) Selects all fields from the table.

19. SQL is a ..... language designed for the retrieval and management of relational database.

Correct Answer: B) Programming.

20. What is the purpose of the 'like' keyword in SQL?

Correct Answer: A) To select records based on a pattern.

21. Where does the CREATE Command belong?

Correct Answer: B) DDL.

22. The command to remove rows from a table 'CUSTOMER' is .....

Correct Answer: D) DELETE FROM CUSTOMER WHERE.

23. What is the purpose of the 'update' command in SQL?

Correct Answer: B) To modify existing records.

24. The LIMIT clause reduces the number of rows returned by a query.

Correct Answer: A) True.

25. Differentiate between DELETE and DROP command.

Correct Answer: D) DELETE is used to remove a record of a table while DROP is used to remove a structure and records of a table.

🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books