🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

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

Quiz Instructions

Select an option to see the correct answer instantly.

1. What does the SQL statement 'INSERT INTO world (name, capital, population) VALUES ('Ours', 'Emerald City', 1000000)' do?

Correct Answer: A) Inserts a new record with the given values into the 'world' table.

2. Write a code for the following:Return the names and imdb ..... ratings of all movies with 'day' in the name.

Correct Answer: C) SELECT name, imdb rating FROM movies WHERE name LIKE '%day%';.

3. What is the command used to delete entire tables in SQL?

Correct Answer: C) Drop table.

4. How can you select records from a table where the name starts with 'A' and the population is greater than 1 million?

Correct Answer: B) SELECT name, population FROM table WHERE name LIKE 'A%' AND population > 1 million.

5. .... ensure database integrity .

Correct Answer: B) Constraints.

6. A column of type CHAR cannot be indexed.

Correct Answer: B) False.

7. Which statement allows us to add a record to a table?

Correct Answer: D) Insert Into.

8. You're creating a table for a pizza delivery app.Which column might allow NULL values?

Correct Answer: D) Customer comments TEXT.

9. Which SQL command is used to insert new records into a table?

Correct Answer: A) INSERT INTO.

10. Identify the SQL command use to add price column into PRODUCT table.

Correct Answer: A) ALTER TABLE PRODUCTADD price decimal (6, 2);.

11. Yang manakah BUKAN fungsi agregat SQL?Apakah penyataan SQL untuk memilih semua attribut dari Jadual Designer?

Correct Answer: A) SELECT * FROM Designer.

12. Pernyataan SELECT digunakan untuk mencapai data-data daripada jadual dalam pangkalan data. SELECT terdiri daripada tiga pernyataan asas KECUALI:

Correct Answer: D) AND.

13. Which command is used to retrieve all records from the table?

Correct Answer: C) SELECT * FROM Users.

14. What does the SQL statement 'UPDATE world SET population = 2000000, name = 'Wonderland' WHERE capital = 'Emerald City" do?

Correct Answer: A) Updates the population and name of records with the capital 'Emerald City' in the 'world' table.

15. Return all dramas made after 2004.

Correct Answer: B) SELECT * FROM movies WHERE genre = 'drama' AND year > 2004;.

16. Identify if there is an error in the SQL statement below in deleting a record:DELETE WHERE Employee ..... details WHERE Employee ..... details.ID = 10;

Correct Answer: E) WHERE.

17. Berikut menunjukkan pernyataan SQL untuk mengemaskini stok barangan. Jika stok kurang daripada 20 unit, sebanyak lima unit barang akan ditambah.1 ..... A ..... BARANG2 ..... B ..... Kuantiti = Kuantiti + 53 ..... C ..... Kuantiti < 20

Correct Answer: C) UPDATEB. SETC. WHERE.

18. Which of the following statements is true about a relational database?

Correct Answer: B) It uses relationships to link data across tables.

19. Which clause allows you to SORT data?

Correct Answer: A) ORDER BY.

20. In creating a table named "Students2024" . Can you identify which is missing or error in the statement below:CREATE Students2024(Employee ..... ID INTEGER, LASTNAME TEXT (50), FIRSTNAME TEXT (50))

Correct Answer: A) TABLE.

21. It is a DML command that is used to display record.

Correct Answer: D) SELECT.

22. WHICH QUERY?defines the list of fields to be displayed

Correct Answer: A) SELECT.

23. DDL stands for .....

Correct Answer: B) Data Definition Language.

24. The original version of SQL was developed at .....

Correct Answer: B) IBM.

25. Which of the following is true about SQL joins?

Correct Answer: C) A full outer join returns results of an inner join as well as the results of a left and right join.

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