Which statement is true regarding the default behavior of the ORDER BYclause? (Choose two.)

• A.Column aliases can be used in the ORDER BY clause.
• B.In a character sort, the values are case-sensitive.
• C.Only columns that are specified in the SELECTlist can be used in the ORDER BYclause.
• D.NULLs are not included in the sort operation.
• E.Numeric values are displayed in descending order if they have decimal positions.

Comment: *

Name: *

Email: *

Verification: *

Table ORDER_ITEMS contains columns ORDER_TO, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:

Statement 2:

Which two statements are true? (Choose two.)

• A.Statement 2 may return multiple rows of output.
• B.Both statements will return NULLif either UNIT_PRICEor QUANTITYcontains NULL.
• C.Statement 2 returns only one row of output.
• D.Both the statements give the same output.
• E.Statement 1 returns only one row of output.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding group functions? (Choose three.)

• A.They can be used on columns or expressions.
• B.They can be passed as an argument to another group function.
• C.They can be used with a SQL statement that has a GROUP BY clause.
• D.They can be used only on one column in the SELECT clause.
• E.They can be used together with the single-row functions in the SELECT clause.

Comment: *

Name: *

Email: *

Verification: *

View the exhibits and examine the structures of the COSTS and PROMOTIONS tables.


Evaluate the following SQL statement:
SQL> SELECT prod_id FROM costs
WHERE promo_id IN (SELECT promo_id FROM promotions
WHERE promo_cost < ALL
(SELECT MAX(promo_cost) FROM promotions
GROUP BY (promo_end_date-
promo_begin_date)));
What would be the outcome of the above SQL statement?

• A.It displays prod IDs in the promos with the lowest cost in the same time interval.
• B.It displays prod IDs in the promos with the highest cost in the same time interval.
• C.It displays prod IDs in the promos which cost less than the highest cost in the same time interval.
• D.It displays prod IDs in the promo with the lowest cost.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the description of the EMPLOYEES table.

Evaluate the following SQL statement:
SELECT first_name, employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) "Review" FROM employees; The query was written to retrieve the FIRST_NAME, EMPLOYEE_ID, and review date for employees. The review date is the firsts Monday after the completion of six months of the hiring. The NLS_TERRITORY parameter is set to AMERICA in the session.
Which statement is true regarding this query?

• A.The query would not execute because date functions cannot be nested.
• B.The query would not execute because the NEXT_DAY function accepts a string as argument.
• C.The query would execute but the output would give review dates that are Sundays.
• D.The query would execute to give the desired output.

Comment: *

Name: *

Email: *

Verification: *