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. It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN.
• B. It does not recover any of the tables because FLASHBACK is not possible in this case.
• C. It recovers only the second DEPT table.
• D. It recovers only the first DEPT table.

Evaluate the SQL statements:
CREATE TABLE new_order
(orderno NUMBER(4),
booking_date TIMESTAMP WITH LOCAL TIME ZONE);
The database is located in San Francisco where the time zone is -8:00.
The user is located in New York where the time zone is -5:00.
A New York user inserts the following record:
INSERT INTO new_order
VALUES(1, TIMESTAMP 007-05-10 6:00:00 -5:00");
Which statement is true?

• A. When the San Francisco user selects the row, booking_date is displayed as 007-05-10 3.00.00.000000'
• B. When the New York user selects the row, booking_date is displayed as 007-05-10 3.00.00.000000'
• C. When the New York user selects the row, booking_date is displayed as 2007-05-10 6.00.00.000000 -5:00'.
• D. When the San Francisco user selects the row, booking_date is displayed as 007-05-10 3.00.00.000000 -8:00'

View the Exhibit and examine the structure of the ORDERS table.
You have to display ORDER_ID, ORDER_DATE, and CUSTOMER_ID for all those orders that were placed after the last order placed by the customer whose CUSTOMER_ID is 101 Which query would give you the desired output?

• A. SELECT order_id, order_date FROM orders
  WHERE order_date > ALL (SELECT order_date
  FROM orders
  WHERE customer_id = 101);
• B. SELECT order_id, order_date FROM orders
  WHERE order_date > ALL (SELECT MAX(order_date) FROM orders) AND
  Customer_id = 101;
• C. SELECT order_id, order_date FROM orders
  WHERE order_date > ANY (SELECT order_date
  FROM orders
  WHERE customer_id = 101);
• D. SELECT order_id, order_date FROM orders
  WHERE order_date IN (SELECT order_date FROM orders
  WHERE customer id = 101);

View the Exhibit and examine the details of the EMPLOYEES table.
Evaluate the following SQL statements:
Statement 1:
SELECT employee_id, last_name, job_id, manager_id
FROM employees
START WITH employee_id = 101
CONNECT BY PRIOR employee_id = manager_id AND manager_id != 108 ;
Statement 2:
SELECT employee_id, last_name, job_id, manager_id
FROM employees
WHERE manager_id != 108
START WITH employee_id = 101
CONNECT BY PRIOR employee_id = manager_id;
Which two statements are true regarding the above SQL statements? (Choose two.)

• A. The output of statement 1 would neither display the employee with MANAGER_ID 108 nor any employee below him or her in the hierarchy.
• B. The output for statement 1 would display the employee with MANAGER_ID 108 and all the employees below him or her in the hierarchy.
• C. The output for statement 2 would not display the employee with MANAGER_ID 108 but it would display all the employees below him or her in the hierarchy.
• D. Statement 2 would not execute because the WHERE clause condition is not allowed in a statement that has the START WITH clause.

View the Exhibit and examine the table structure of DEPARTMENTS and LOCATIONS tables.
You want to display all the cities that have no departments and the departments that have not been allocated cities.
Which type of join between DEPARTMENTS and LOCATIONS tables would produce this information as part of its output?

• A. LEFT OUTER JOIN
• B. NATURAL JOIN
• C. RIGHT OUTER JOIN
• D. FULL OUTER JOIN