Which of the following statements is TRUE regarding the application of WHERE clause? Can only be used on columns that are present in SELECT clauseIs used to choose the columns that need to be fetched in the resultCan be used on all columnsNone of the above

Which statements are true regarding the USING and ON clauses in table joins? Select one or more:a.The WHERE clause can be used to apply additional conditions in SELECT statement containing the ON or the USING clause.b.Both USING and ON clause can be used for equijoins and nonequijoins c.Maximum of one pair of columns can be joined between two tables using the ON claused.The ON clause can be used to join tables on columns that have different names but compatible data types.

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.

What is the purpose of the WHERE clause in an SQL statement?To specify the columns to be retrievedTo specify the table to be queriedTo filter records based on specified conditionsTo sort the retrieved data

Which of the following statements is true regarding subqueries in SQL?Answer choicesSelect an optionSubqueries can only return a single value.Subqueries cannot be used in the SELECT clause.Subqueries can be used in the SELECT, WHERE, and FROM clauses.Subqueries must always use the JOIN clause to relate to the outer query.

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