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 this command?

• A. It would return a hierarchical output starting with the employee whose EMPLOYEE_ID is101, followed by employees up to one level below him or her in the hierarchy.
• B. It would return a hierarchical output starting with the employee whose EMPLOYEE_ID is 101, followed by employees below him or her in the hierarchy.
• C. It would return a hierarchical output starting with the employee whose EMPLOYEE_ID is 101, followed by the employee to whom he or she reports.
• D. It would return a hierarchical output starting with the employee whose EMPLOYEE_ID is 101, followed by his or her peers.

The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR. Which statement would create a synonym ORD so that HR can execute the following query successfully? SELECT'FROM ord;

• A. CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator.
• B. CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator.
• C. CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE.
• D. CREATE SYNONYM ord FOR orders; This command is issued by OE.

View the Exhibit and examine the description of the ORDERS table.
Evaluate the following SQL statement:
SELECT order_id, customer_id FROM orders WHERE order_date > 'June 30 2001';
Which statement is true regarding the execution of this SQL statement?

• A. It would not execute because 'June 30 2001' in the WHERE condition is not enclosed within double quotation marks.
• B. It would not execute because 'June 30 2001' in the WHERE condition cannot be converted implicitly and needs the use of the TO_DATE conversion function for proper execution.
• C. It would not execute because 'June 30 2001' in the WHERE condition cannot be converted implicitly and needs the use of the TO_CHAR conversion function for proper execution.
• D. It would execute and would return ORDER_ID and CUSTOMER_ID for all records having ORDER_DATE greater than 'June 30 2001'.

Which CREATE TABLE statement is valid?

• A. CREATE TABLE ord_details
  (ord_no NUMBER(2),
  item_no NUMBER(3),
  ord_date date DEFAULT SYSDATE NOT NULL,
  CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no));
• 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
  (ord_no NUMBER(2) ,
  item_no NUMBER(3),
  ord_date date DEFAULT NOT NULL,
  CONSTRAINT ord_uq UNIQUE (ord_no),
  CONSTRAINT ord_pk PRIMARY KEY (ord_no));
• D. CREATE TABLE ord_details
  (ord_no NUMBER(2) PRIMARY KEY,
  item_no NUMBER(3) PRIMARY KEY,
  ord_date date NOT NULL);

View the Exhibit and examine the structure of the ORDER_ITEMS table.
You need to display the ORDER_ID of the order that has the highest total value among all the
orders in the ORDER_ITEMS table.
Which query would produce the desired output?

• A. SELECT order_id
  FROM order_items
  WHERE (unit_price*quantity) = (SELECT MAX(unit_price*quantity) FROM order_items
  GROUP BY order_id);
• B. SELECT order_id
  FROM order_items
  WHERE(unit_price*quantity) = (SELECT MAX(unit_price*quantity) FROM order_items)
  GROUP BY order_id;
• C. SELECT order_id
  FROM order_items
  WHERE(unit_price*quantity) = MAX(unit_price*quantity)
  GROUP BY order_id;
• D. SELECT order_id
  FROM order_items
  GROUP BY order_id
  HAVING SUM(unit_price*quantity) =(SELECT MAX(SUM(unit_price*quantity))
  FROM order_items GROUP BY order_id);