View the Exhibit and examine the structure of the EMPLOYEES table. Evaluate the following SQL statement: SELECT employee_id, last_name, job_id, manager_id FROM employees START WITH employee_id = 101 CONNECT BY PRIOR employee_id=manager_id; Which statement is true regarding the output for…

View the Exhibit button and examine the structures of ORDERS and ORDER_ITEMS tables. In the ORDERS table, ORDER_ID is the PRIMARY KEY and in the ORDER_ITEMS table, ORDER_ID and LINE_ITEM_ID form the composite primary key. Which view can have all…

Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement? (Choose three.) A. The HAVING clause conditions can have aggregate functions. B. The HAVING clause conditions can use aliases for the columns. C. WHERE and…

View the Exhibit and examine the description of the ORDER_ITEMS and PRODUCT_INFORMATION tables. The ORDER_ITEM table has records pertaining to details for each product in an order. The PRODUCT_INFORMATION table has records for all the products available for ordering. Evaluate…

View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables. You are asked to retrieve the ORDER_ID, PRODUCT_ID, and total price (UNIT_PRICE multiplied by QUANTITY), where the total price is greater than 50,000. You executed the following…

View the Exhibit and examine the data in the LOCATIONS table. Evaluate the following SOL statement: SELECT street_address FROM locations WHERE REGEXP_INSTR(street_address,'[^[: alpha:]]’) = 1; Which statement is true regarding the output of this SOL statement? A. It would display…

Evaluate the following SQL statements in the given order: DROP TABLE dept; CREATE TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10)); DROP TABLE dept; FLASHBACK TABLE dept TO BEFORE DROP; Which statement is true regarding the above FLASHBACK operation? A.…

Which two statements are true regarding the GROUP BY clause in a SQL statement? (Choose two.) A. You can use column alias in the GROUP BY clause. B. Using the WHERE clause after the GROUP BY clause excludes the rows…

Which CREATE TABLE statement is valid? A. CREATE TABLE ord_details (ord_no NUMBER(2) PRIMARY KEY, item_no NUMBER(3) PRIMARY KEY, ord_date date NOT NULL); B. CREATE TABLE ord_details(ord_no NUMBER(2) UNIQUE, NOT NULL,item_no NUMBER(3),ord_date date DEFAULT SYSDATE NOT NULL); C. CREATE TABLE ord_details…

In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause? A. to find the groups forming the subtotal in a row B. to create group-wise grand totals for the groups specified within…