READ Free Dumps For Oracle- 1z0-061

Question ID 21006	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?
Option A	Abigail PA
Option B	Abigail Pa
Option C	Abigail IS
Option D	An error message
Correct Answer	B

Explanation

Question ID 21007	View the Exhibit and evaluate the structure and data in the CUST_STATUS table. Which statement is true regarding the execution of the above query?
Option A	It produces an error because the AMT_SPENT column contains a null value.
Option B	It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT.
Option C	It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is null.
Option 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.
Correct Answer	C

Explanation Explanation: The NULLIF Function The NULLIF function tests two terms for equality. If they are equal the function returns a null, else it returns the first of the two terms tested. The NULLIF function takes two mandatory parameters of any data type. The syntax is NULLIF(ifunequal, comparison_term), where the parameters ifunequal and comparison_term are compared. If they are identical, then NULL is returned. If they differ, the ifunequal parameter is returned.

Previous-Page 1 2. . . 35 36 37 38 39 40 41. . . 58 59 Next-Page

Send email to admin@getfreedumps for new dumps request!!!