What is true about the ANY operator used for sub-queries?Returns rows that match all the values in a list/sub-queryReturns rows that match the first 5 values in a list/sub-queryReturns rows that match any value in a list/sub-queryReturns the value 0 when all the rows match in a list/sub-query

Consider the query given below SELECT first_name, last_name, salary, commission_pct FROM employees WHERE salary < ANY (SELECT salary FROM employees WHERE department_id = 100)What will be the outcome of the query given above if the < ANY operator is replaced with = ANY operator, if we assume that the department 100 has more employees? It will treat each value of the salary returned from the sub-query as it does with IN operatorThere will be no difference in the resultsThe results will differThe execution will thrown an SQL error

Which of the following statements are TRUE regarding subqueries?Answer choicesSelect an optionA subquery can retrieve zero or more rowsA subquery can appear on either side of a comparison operatorThere is no limit on the number of subquery levels in the WHERE clause of a SELECT statementAll of above

Question 6: (1.00) One of the main rules that subqueries must follow: Subqueries must be enclosed within parentheses Subquery can have multiple columns in the SELECT clause Subqueries that return more than one row can only be used with multiple value operators, such as the >, <,=, >=, <= A subquery can return zero or more rows The BETWEEN operator can be used with a subquery

What does the SQL LIKE operator do?OptionsCombines multiple conditionsSearches for a specified pattern in a columnCompares two values for equalityChecks if a column is empty

In order to prevent multiple records from being returned by the sub query, ____ must be used before the sub query.*Many Value OperatorsUnique Value OperatorSingle Value OperatorMultiple Value Operators