The following are the steps for a correlated subquery, listed in random order:
1. The WHEREclause of the outer query is evaluated.
2. The candidate row is fetched from the table specified in the outer query.
3. The procedure is repeated for the subsequent rows of the table, till all the rows are processed.
4. Rows are returned by the inner query, after being evaluated with the value from the candidate row in the outer query.
Identify the option that contains the steps in the correct sequence in which the Oracle server evaluates a correlated subquery.

• A.2, 1, 4, 3
• B.4, 1, 2, 3
• C.4, 2, 1, 3
• D.2, 4, 1, 3

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the MARKS table:
Which two statements would execute successfully? (Choose two.)

• A.SELECT student_name subject1FROM marksWHERE subject1 > AVG(subject1);
• B.SELECT SUM(subject1+subject2+subject3)FROM marksWHERE student_name IS NULL;
• C.SELECT student_name,SUM(subject1)FROM marksWHERE student_name LIKE 'R%';
• D.SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1)FROM marksWHERE
  subject1 > subject2;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the DUAL table? (Choose two.)

• A.It can be accessed only by the SYS user.
• B.It can be used to display only constants or pseudo columns.
• C.It can be accessed by any user who has the SELECT privilege in any schema.
• D.It can display multiple rows but only a single column.
• E.It consists of a single row and single column of VARCHAR2data type.
• F.It can display multiple rows and columns.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the ORDERS table.

You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101.
Which query would give you the desired result?

• A.SELECT order_id, order_date FROM orders
  WHERE order_date > ALL
  (SELECT MAX(order_date) FROM orders ) AND customer_id = 101;
• B.SELECT order_id, order_date FROM orders
  WHERE order_date > ALL
  (SELECT order_date FROM orders WHERE 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);

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the EMPLOYEES table.
NameNull?Type
---------------------- ------------
EMPLOYEE_IDNOT NULLNUMBER(6)
FIRST_NAMEVARCHAR2(20)
LAST_NAMENOT NULLVARCHAR2(25)
EMAILNOT NULLVARCHAR2(25)
PHONE NUMBERVARCHAR2(20)
HIRE_DATENOT NULLDATE
JOB_IDNOT NULLVARCHAR2(10)
SALARYNUMBER(8,2)
COMMISSION_PCTNUMBER(2,2)
MANAGER_IDNUMBER(6)
DEPARTMENT_IDNUMBER(4)
There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_ID is 123.
Which query provides the correct output?

• A.SELECT e.last_name, m.manager_idFROM employees e RIGHT OUTER JOIN
  employees mon (e.manager_id = m.employee_id)AND e.employee_id = 123;
• B.SELECT e.last_name, m.manager_idFROM employees e RIGHT OUTER JOIN
  employees mon (e.employee_id = m.manager_id)WHERE e.employee_id = 123;
• C.SELECT e.last_name, e.manager_idFROM employees e RIGHT OUTER JOIN
  employees mon (e.employee_id = m.employee_id)WHERE e.employee_id = 123;
• D.SELECT m.last_name, e.manager_idFROM employees e LEFT OUTER JOIN
  employees mon (e.manager_id = m.manager_id)WHERE e.employee_id = 123;

Comment: *

Name: *

Email: *

Verification: *