🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

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

Quiz Instructions

Select an option to see the correct answer instantly.

1. .... Command withdraws the access permission given by the GRANT statement

Correct Answer: A) Revoke.

2. In order to modify data in a database we would use which SQL statement?

Correct Answer: A) Update.

3. A column in a database

Correct Answer: C) Field.

4. The HAVING clause includes a predicate used to filter rows resulting from the ..... clause

Correct Answer: C) GROUP.

5. What does a declarative language mean in the context of SQL?

Correct Answer: B) It expresses what needs to be achieved.

6. ANSI stands for .....

Correct Answer: C) American National Standard Institute.

7. A primary key can be set to null.

Correct Answer: B) False.

8. ..... command restores the database to last commit state

Correct Answer: B) Rollback.

9. Which SQL function is used to count the number of rows in a SQL query?

Correct Answer: D) COUNT(*).

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

Correct Answer: D) All of the above.

11. What word is missing from the line below?SELECT * ..... CUSTOMER;

Correct Answer: A) FROM.

12. List the Data Definition Language (DDL) command.

Correct Answer: A) CREATE, USE ALTER, DROP.

13. What is the purpose of *?

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

14. Identify if there is an error in the SQL UPDATE statement below:UPDATE Employee ..... details SHOW Employee ..... details.Lastname = 'THANTRA', Employee ..... details.Salary = '3600' WHERE Employee ..... details.ID =8;

Correct Answer: E) Show.

15. Values of ..... type is enclosed in single quotes.

Correct Answer: B) Char.

16. .... are instructions given by the user to the database also known as statements.

Correct Answer: A) Comments.

17. Return only the customers who have ER anywhere in their last name.

Correct Answer: A) Last name LIKE "%er%".

18. Which keyword is used to add conditions to your query?

Correct Answer: C) WHERE.

19. What represents no value?

Correct Answer: A) NULL.

20. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" ends with an "a" ?

Correct Answer: C) SELECT * FROM Persons WHERE FirstName LIKE '%a'.

21. WHICH QUERY?defines the list of tables the data will come from

Correct Answer: B) FROM.

22. You're creating a table for a movie database.Which column should be a foreign key?

Correct Answer: B) Director id INT.

23. SQL is

Correct Answer: A) Structured Query Language.

24. Select all the possible data types in an sql database

Correct Answer: A) CURRENCY.

25. What are Joins?

Correct Answer: A) They combine two or more tables to retrieve data from multiple tables, based on a common field between them.

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