Consider the below table:Products TableColumn NameDatatypeConstraintProd_idNumberPKProd_nameVarchar Prod_list_pricevarchar Cust_credit_limitNumber  What would be the outcome of executing the below SQL statement?select prod_name from products where prod_id in(select prod_id from products where prod_list_price=(select max(prod_list_price) from products where prod_list_price<(select max(prod_list_price)from products)));Select one:a.It shows the names of all products in the table.b.It shown the names of products whose list price is the second highest in the tablec.It produces an errord.It shown the names of all products whose list price is less than the maximum list priceClear my choiceQuestion 9Not yet answeredMarked out of 1.00Flag questionTipsQuestion text_____ is used to retrieve records that do not meet the join conditionSelect one:a.Outer Joinb.Equi Joinc.Non Equi Joind.Self Join

Consider the below tables:Customer TableColumn NameDatatypeConstraintcustNoNumberPKcustnameVarchar custaddressvarchar Cust_credit_limitNumber  Grade  TableColumn NameDatatypeConstraintGradeVarchar StartvalNumber EndvalNumber To display names and grades of customers who have the highest credit limit.Which SQL statements would accomplish the task? Select one or more:a.SELECT custname, gradeFROM customers, gradesWHERE (SELECT MAX(cust_credit_limit)FROM customers) BETWEEN startval and endvalAND cust_credit_limit BETWEEN startval AND endval;b.SELECT custname, gradeFROM customers, gradesWHERE cust_credit_limit = (SELECT MAX(cust_credit_limit)FROM customers)AND cust_credit_limit BETWEEN startval AND endval;c.SELECT custname, gradeFROM customers, gradesWHERE cust_credit_limit IN (SELECT MAX(cust_credit_limit)FROM customers)AND MAX(cust_credit_limit) BETWEEN startval AND endval;d.SELECT custname, gradeFROM customers, gradesWHERE (SELECT MAX(cust_credit_limit)FROM customers) BETWEEN startval and endval;

Consider the table Employee given below: EmpId EmpName Salary DeptId200 Alex 30000 100201 Tom 20000 101202 Dick 40000 100202 Harry 15000 102205 Mary 50000 101206 Karl 40000 101SELECT EmpName FROM Employee WHERE Salary > ALL (SELECT Salary FROM Employee WHERE DeptId = 100);What will be the outcome of the query given above?

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

Consider the following table:Product TableColumn NameDataTypeConstraintprod_nameVarchar2(20) prod_idNumber(10)PK Customer TableColumn NameDataTypeConstraintcust_last_nameVarchar2(20) cust_idNumber(10)PKcust_cityVarchar2(20)  Sales TableColumn NameDataTypeConstraintprod_idNumber(10)FKcust_idNumber(10)FKquantity_soldNumber(10,2)  Generate a report that gives details of the customer's last name, name of the product and the quantity sold for all customers in 'Tokyo'.Which two queries give the required result? (Choose two.)Select one or more:a.SELECT c.cust_last_name,p.prod_name,s.quantity_soldFROM products p JOIN sales sON(p.prod_id=s.prod_id)JOIN customers cON(s.cust_id=c.cust_id)WHERE c.cust_city='Tokyo';b.SELECT c.cust_last_name,p.prod_name,s.quantity_soldFROM products p JOIN sales s JOIN customers cON(p.prod_id=s.prod_id)ON(s.cust_id=c.cust_id)WHERE c.cust_city='Tokyo';c.SELECT c.cust_last_name,p.prod_name,s.quantity_soldFROM sales s JOIN products pUSING (prod_id)JOIN customers cUSING (cust_id)WHERE c.cust_city='Tokyo';d.SELECT c.cust_last_name,p.prod_name,s.quantity_soldFROM products p JOIN sales sUSING (prod_id)ON(p.prod_id=s.prod_id)JOIN customers cUSING(cust_id)WHERE c.cust_city='Tokyo';

What does the following SQL code do?SELECT name, MAX(salary) FROM Employees WHERE salary < (SELECT MAX(salary) FROM employees);Returns the row with the second highest salaryReturns all the rows that are less than the max salaryReturns the row with the highest salary