The SQL WHERE clause:
A. limits the column data that are returned.
B. limits the row data are returned.
C. Both A and B are correct.
D. Neither A nor B are correct.
Answer: Option B
Solution (By Examveda Team)
The SQL WHERE clause is used to filter records.It limits the row data that are returned by specifying conditions that the records must meet.
Option A is incorrect because the WHERE clause does not limit column data; this is done by the SELECT statement.
Option C is incorrect because only Option B is correct.
Option D is incorrect because the WHERE clause does limit the row data that are returned.
Conclusion: The WHERE clause in SQL is used to filter rows based on specific conditions, limiting the row data returned.
This Question Belongs to Database >> Introduction To SQL
In USER_CONSTRAINTS TABLE column Contraint_type which are attributes have?