Evaluate this SQL statement:SELECT first_name, commissionFROM employeeWHERE commission =(SELECT commissionFROM employeeWHERE UPPER(first_name) = 'SCOTT');What would cause this statement to fail?Select one:a.All the given optionsb.The FIRST_NAME values in the database are in lowercase.c.There is more than one employee with the first name Scott.d.Scott has a zero commission value.e.Scalar function is not allowed in Subquery.

he following query throws an error. Choose the correct reason for the error as given in the options. SELECT first_name, last_nameFROM employeesWHERE commission_pct = (SELECT min(commission_pct ) FROM employees GROUP BY department_id); A. The GROUP BY clause is not required in the sub-queryB. A function cannot be used in a sub-query SELECT statementC. The single row sub-query gives multiple records

Mr. John is the president of a company. Five managers report to him. All other employees report to these managers.Examine the code:SELECT employee.ename FROM emp employeeWHERE employee.empno NOT IN (SELECT manager.mgrFROM emp manager);The above statement returns no rows selected. as the result. Why?Select one:a.A NULL value is returned from the subquery.b.NOT IN operator is not allowed in subqueries.c.None of the employees has a manager.d.All employees have a manager.

Which of the following SQL statements demonstrates the correct usage of the UPPER() function to convert a column ‘name’ into uppercase? This question is required.*ASELECT name FROM employees WHERE name = UPPER(name);BSELECT UPPERfunction(name) FROM employees WHERE name = name;CSELECT UPPEROF(name) FROM employees WHERE name = LOWER(name);DSELECT UPPER(name) FROM employees;

Review this SQL Statement: SELECT ename, emp_number, salary FROM employee WHERE dept_number = (SELECT dept_number FROM department WHERE location IN('CHICAGO','ATLANTA')); Why may this statement return an error?

Consider the following SQL query: SELECT name FROM Customers WHERE date_registered > (SELECT MIN(date_registered) FROM Customers);OptionsThe names of customers who registered after the first registered customer. The names of customers who registered on the same date as the first registered customer.An error because the subquery returns multiple values.An error because the subquery is missing the FROM clause.