Evaluate the following SQL statement:
Which statement is true regarding the outcome of the above query?
A.
It executes successfully and displays rows in the descending order of PROMO_CATEGORY.
B.
It produces an error because positional notation cannot be used in the order by clause with set operators.
C.
It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.
D.
It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement.
Which three SQL statements would display the value 1890.55 as $1, 890.55?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table.
Which query will generate the required result?
A.
Option A
B.
Option B
C.
Option C
D.
Option D B
In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'.
Evaluate the following query:
What would be the outcome?
A.
Abigail PA
B.
Abigail Pa
C.
Abigail IS
D.
An error message
View the Exhibit and evaluate the structure and data in the CUST_STATUS table.
You issue the following SQL statement:
Which statement is true regarding the execution of the above query?
A.
It produces an error because the AMT_SPENT column contains a null value.
B.
It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT.
C.
It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is null.
D.
It produces an error because the TO_NUMBER function must be used to convert the result of the NULLIF function before it can be used by the NVL2 function.