Global MCQ Practice

🌐 Total MCQ
🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

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

Quiz Instructions

Select an option to see the correct answer instantly.

1. If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default
2. Which statement is used to extract data from a database?
3. .... datatype precision up to a maximum of 64.
4. Which operator test the column for absence of data?
5. Define the type of SQL that used to insert, delete and retrieve data within the database tables.
6. What does the SQL statement 'SELECT name FROM world WHERE population > (SELECT population FROM world WHERE name = Algeria)' do?
7. What is the built-in MySQL function that gives you the current time in an SQL statement?
8. The ..... statement is used to delete a table.
9. Which of the following types of tables often are created without a primary key?
10. How can you delete all records from a table with a population larger than 10 million?
11. When editing the columns in a pre-existing table, which command adds a new column?
12. What is a field (column) in a database table?
13. What is the purpose of the 'join' keyword in SQL?
14. When editing columns in a pre-existing table, which command allows you to delete a column?
15. Which of the following is NOT a characteristic of a relational database?
16. .... helps to set a limit value placed for a field.
17. State True or False:1. FROM statement groups rows with similar values in the specified grouping field.
18. What is the label we give to a column that is an integer and used to point to a row in a different table?
19. Which key is used to execute a query?
20. .... which helps to uniquely identify a record.
21. What is the purpose of the 'order by' command in SQL?
22. Can the result of a SELECT statement contain duplicate rows?
23. How can you perform an SQL query on more than one table?
24. .... is a computer programming language used for adding, removing, and modifying data in a database.
25. Which of the following is NOT a good rule to follow when developing a database model?
🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books