View the Exhibit and examine the structure of the PRODUCT, COMPONENT, and PDT_COMP tables. In PRODUCT table, PDTNO is the primary key. In COMPONENT table, COMPNO is the primary key. In PDT_COMP table, (PDTNO,COMPNO) is the primary key, PDTNO is…

View the Exhibit and examine the data in the EMPLOYEES table: You want to display all the employee names and their corresponding manager names. Evaluate the following query: SQL> SELECT e.employee_name "EMP NAME", m.employee_name "MGR NAME" FROM employees e ______________…

View the Exhibits and examine the structures of the CUSTOMERS, SALES, and COUNTRIES tables. You need to generate a report that shows all country names, with corresponding customers (if any) and sales details (if any), for all customers. Which FROM…

Examine the data in the CUSTOMERS table: You want to list all cities that have more than one customer along with the customer details. Evaluate the following query: SQL>SELECT c1.custname, c1.city FROM Customers c1 __________________ Customers c2 ON (c1.city=c2.city AND…

View the Exhibit and examine the data in the PROJ_TASK_DETAILS table. The PROJ_TASK_DETAILS table stores information about tasks involved in a project and the relation between them. The BASED_ON column indicates dependencies between tasks. Some tasks do not depend on…

Examine the structure of the CUSTOMERS table: CUSTNO is the PRIMARY KEY in the table. You want to find out if any customers’ details have been entered more than once using different CUSTNO, by listing all the duplicate names. Which…

Examine the data in the ORD_ITEMS table: Evaluate the following query: SQL>SELECT item_no, AVG(qty) FROM ord_items HAVING AVG(qty) > MIN(qty) * 2 GROUP BY item_no; Which statement is true regarding the outcome of the above query? A. It gives an…

Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose all that apply.) A. The HAVING clause can be used with aggregate functions in subqueries. B. The WHERE clause can be used to exclude rows…

You issue the following query: SQL> SELECT AVG(MAX(qty)) FROM ord_items GROUP BY item_no HAVING AVG(MAX(qty))>50; Which statement is true regarding the outcome of this query? A. It executes successfully and gives the correct output. B. It gives an error because…

Examine the structure of the ORDERS table: You want to find the total value of all the orders for each year and issue the following command: SQL>SELECT TO_CHAR(order_date,’rr’), SUM(order_total) FROM orders GROUP BY TO_CHAR(order_date,’yyyy’); Which statement is true regarding the…