🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

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

Quiz Instructions

Select an option to see the correct answer instantly.

1. State True or False:1. SELECT statement is used to extract records from one or more tables

Correct Answer: A) True.

2. What does * mean when writing code?

Correct Answer: A) Select all columns.

3. Which type of language is SQL?

Correct Answer: A) Declarative.

4. What could be the correct datatype for 'H.NO. 234, SEC-14' data

Correct Answer: C) Varchar.

5. State the use of WHERE clause.

Correct Answer: A) In SELECT statement specifies the condition, which restricts the rows returned by the query.

6. Pernyataan SQL manakah yang digunakan untuk mengekstrak data daripada pangkalan data?

Correct Answer: B) SELECT.

7. Choose SQL command to display the name of cake that end with word cheese.

Correct Answer: B) SELECT cakeNameFROM CAKEWHERE cakeName LIKE "cheese%";.

8. SELECT *FROM BarangORDER BY NamaBarang DESCPernyataan diatas bertujuan untuk

Correct Answer: A) Menyenaraikan SEMUA maklumat dalam jadual Barang secara menurun.

9. In a database, what is the role of a primary key?

Correct Answer: B) To uniquely identify each record in a table.

10. TRUE OR FALSE:when adding data to all fields in a table, you still have to specify the field names

Correct Answer: B) FALSE.

11. Choose the CORRECT query for using comparison operators in SQL.

Correct Answer: B) SELECT eName, ePositionFROM employeeInfoWHERE age>40 AND age<60;.

12. Which SQL statement is used to update existing records in a table?

Correct Answer: C) UPDATE.

13. Which of the following SQL clauses is used to DELETE tuples from a database table?

Correct Answer: A) DELETE.

14. What is the default sorting order of the ORDER BY clause in SQL?

Correct Answer: A) Ascending.

15. Arthur is working on a database for his school project and wants to retrieve specific data from a table. Which SQL statement should he use?

Correct Answer: A) SELECT.

16. Apakah maksud SQL?

Correct Answer: C) Structured Query Language.

17. What does the SQL command 'DROP TABLE' do?

Correct Answer: A) Deletes existing tables.

18. Which of the following is the label we give a column that the "outside world" uses to look up a particular row?

Correct Answer: A) Logical key.

19. Which function is used to calculate the summary values?

Correct Answer: A) Aggregate.

20. .... have a special meaning in SQL.

Correct Answer: D) Keyword.

21. SQL query to find all the cities whose humidity is 95.

Correct Answer: B) SELECT city FROM weather WHERE humidity = 95.

22. The ..... consist of SQL statements used to define the database structure or schema.

Correct Answer: A) DDL.

23. Images, PDF, movies cannot be stored in a database.

Correct Answer: B) False.

24. Apakah penyataan SQL untuk mengemas kini nombor telefon '012345678' hanya untuk attribut DesignerID, "SMI01" dalam jadual "Designer" ?

Correct Answer: C) UPDATE Designer SET PhoneNo = '012345678' WHERE DesignerID = 'SMI01'.

25. What does the SQL statement 'SELECT * FROM world WHERE name = Algeria' do?

Correct Answer: A) Retrieves all fields of the record for Algeria from the 'world' table.

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