Vidyalelo
SQL · Q10

SQL

Programming · SQL · question 10

Q10

The FROM SQL clause is used to...

A.
specify what table we are selecting or deleting data FROM
Answer
B.
specify range for search condition
C.
specify search condition
D.
None of these

Answer: Option A

Solution

Answer: Option A
Solution:
The FROM SQL clause is used to specify from which table we are selecting or deleting data. It defines the source table from which data will be retrieved or modified in a SQL query. Here's the breakdown:

Option A: specify what table we are selecting or deleting data FROM
This option correctly describes the purpose of the FROM clause, which is to specify the table from which data operations will be performed.

Option B: specify range for search condition
This is not the primary purpose of the FROM clause. It is used for table specification, not defining search ranges.

Option C: specify search condition
The FROM clause is not used to specify search conditions. Search conditions are typically defined in the WHERE clause.

Option D: None of these
Option A is a valid description of the FROM clause's purpose.

So, the correct answer is Option A: specify what table we are selecting or deleting data FROM.