SQL QUIZ

What does SQL stand for?

• 1. SQL stands for Sample Query Language

• 1. SQL stands for Structured Query List

• 1. SQL stands for Structured Query Language

• 1. SQL stands for Sample Query List

What does this SQL database language design to?

• 1. Maintain the data in hierarchal database management systems.

• 1. Maintain the data in relational database management systems.

• 1. Maintain the data in network database management systems.

• 1. Maintain the data in object-oriented database management systems.

Which statement is not true about SQL?

• 1. Using SQL in relational databases is all about inserting, updating, and deleting data.

• 1. Sample data can also be described with the aid of this tool.

• 1. It helps develop relational database functions, events, and views.

• 1. A SQL user can also set restrictions and permissions for a table column, a view, and a stored procedure.

Determine the correct SQL command?

• 1. CREATE

• 1. UPDATE

• 1. DELETE

• 1. All of the above

What is the work of CREATE command?

• 1. Using this command, you can remove or erase recorded information from a database table.

• 1. It enables you to create new databases, tables, table views, and other objects using this command.

• 1. Inserting records or data into the database tables is accomplished with this command. In addition to inserting records in single rows, we can insert records in multiple rows as well.

• 1. A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.

What is the work of SELECT command?

• 1. Database objects such as tables, table views, and other objects can be deleted using this command.

• 1. Database objects such as tables, table views, and other objects can be deleted using this command.

• 1. One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.

• 1. It enables you to create new databases, tables, table views, and other objects using this command.

What is the work of DROP command?

• 1. Using this command, you can remove or erase recorded information from a database table.

• 1. Database objects such as tables, table views, and other objects can be deleted using this command.

• 1. One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.

• 1. It enables you to create new databases, tables, table views, and other objects using this command.

What is the work of INSERT command?

• 1. Inserting records or data into the database tables is accomplished with this command. In addition to inserting records in single rows, we can insert records in multiple rows as well.

• 1. Database objects such as tables, table views, and other objects can be deleted using this command.

• 1. One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.

• 1. It enables you to create new databases, tables, table views, and other objects using this command.

Syntax of the Structured Query Language is ____?

• 1. Case-sensitive

• 1. Not case-sensitive

Which of the following statement is false?

• 1. There is no difference between a lower case and upper case keyword in SQL.

• 1. It is easier to read SQL queries when the keywords are in lowercase.

• 1. An SQL statement's syntax is determined by its text line.

• 1. One or more SQL statements can be placed on a single line of text.