Home » MCQs » SQL MCQs » SQL Basics (Set 1) MCQs

What is the work of SELECT command?

11. What is the work of SELECT command?

1. Database objects such as tables, table views, and other objects can be deleted using this command.
2. Database objects such as tables, table views, and other objects can be deleted using this command.
3. 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.
4. It enables you to create new databases, tables, table views, and other objects using this command.

Answer: C) 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

Explanation:

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