View the exhibit and examine the description of the EMPLOYEES table. (Choose two.)

You executed this SQL statement:
SELECT first_name, department_id, salary
FROM employees
ORDER BY department_id, first_name, salary desc;
Which two statements are true regarding the result?

• A.The values in the FIRST_NAME column would be returned in ascending order for all employees having the same value in the DEPARTMENT_ID column.
• B.The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID and FIRST_NAME column.
• C.The values in the FIRST_NAME column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.
• D.The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.
• E.The values in the all columns would be returned in descending order.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the description of the ORDERS table. (Choose two.) Which two WHERE clause conditions demonstrate the correct usage of conversion functions?

• A.WHERE Order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
• B.WHERE TO_CHAR(Order_date, 'MON DD YYYY') = 'JAN 20 2003'
• C.WHERE Order_date > ( TO_DATE('JUL 10 2006', 'MON DD YYYY')
• D.WHERE Order_date_IN ( TO_DATE('OCT 21 2003', 'MON DD YYYY'), TO_CHAR('NOV
  21 2003', 'MON DD YYYY') )

Comment: *

Name: *

Email: *

Verification: *

Examine this SQL statement:

Identify three order by clauses, any one of which can complete the query successfully.

• A.ORDER BY "Last Name"
• B.ORDER BY 2, 1
• C.ORDER BY 2, cust_id
• D.ORDER BY "CUST NO"
• E.ORDER BY CUST_NO

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding subqueries? (Choose three.)

• A.Multiple columns or expressions can be compared between the main query and subquery.
• B.Subqueries can contain ORDER BYbut not the GROUP BYclause.
• C.Main query and subquery can get data from different tables.
• D.Subqueries can contain GROUP BY and ORDER BYclauses.
• E.Main query and subquery must get data from the same tables.
• F.Only one column or expression can be compared between the main query and subquery.

Comment: *

Name: *

Email: *

Verification: *

You execute the following commands:
SQL > DEFINE hiredate = '01-APR-2011'
SQL >SELECT employee_id, first_name, salary
FROM employees
WHERE hire_date > '&hiredate'
AND manager_id > &mgr_id;
For which substitution variables are you prompted for the input?

• A.only hiredate'
• B.both the substitution variables ''hiredate' and 'mgr_id'.
• C.none, because no input required
• D.only 'mgr_id'

Comment: *

Name: *

Email: *

Verification: *