The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.Where, fromSelect, fromFrom, whereFrom, select

___________ clause is used to retrieve data from one or more tables?Select one:WhereOrder bySelectHaving

What is the purpose of the WHERE clause in a SQL query?Select one:a. To specify the order of the resultsb. To group rows into subsetsc. To specify the columns to be retrievedd. To filter rows based on a condition

SELECT, FROM and WHERE are mandatory for any SELECT statement in SQL.

When to use SQL WHERE clause?Answer choicesSelect an optionTo limit the column data that are returned.To limit the row data are returned.Both A and B are correctNeither A nor B are correct.

The Oracle WHERE clause: A.Limits the column data that are returned.B.Limits the row data are returned.