Let the statement SELECT column1 FROM myTable return 10 rows The

Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return

A. less than 10 rows

B. more than 10 rows

C. exactly 10 rows

D. None of these

Answer: Option C

Solution (By Examveda Team)

In SQL, the "SELECT ALL" statement is used to select all rows, which is the default behavior of the "SELECT" statement. If the statement "SELECT column1 FROM myTable;" returns 10 rows, then the statement "SELECT ALL column1 FROM myTable;" will also return exactly 10 rows because it selects all rows from the specified column in the table. Option C is the correct choice.

Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return

Solution (By Examveda Team)

Join The Discussion

Read More: MCQ Type Questions and Answers