How many of the following return rows?

SELECT, SHOW, DESCRIBE

Solution(By Examveda Team)

SELECT: This statement is used to retrieve data from one or more tables in a database. It returns rows containing the selected data based on the specified conditions. Therefore, SELECT returns rows.
SHOW: This statement is used to display various information about databases, tables, columns, indexes, and more. Depending on the context, SHOW can return rows containing information about the specified object. For example, SHOW TABLES returns a list of tables in the current database. Therefore, SHOW can return rows.
DESCRIBE: This statement is used to display information about the structure of a table, such as column names, types, and properties. It does not return rows of data from the table itself; instead, it returns metadata about the table's structure. Therefore, DESCRIBE does not return rows.

Therefore, out of the provided statements, SELECT and SHOW return rows, while DESCRIBE does not. Thus, the number of statements that return rows is Option C: 2.