You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit:
You issue the following SQL statement: Which statement is true regarding the execution of
the above query?
A.
It displays a bonus of 1000 for all customers whose AMT_SPENT is less than
CREDIT_LIMIT.
B.
It displays a bonus of 1000 for all customers whose AMT_SPENT equals
CREDIT_LIMIT, or AMT_SPENT is null.
C.
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.
D.
It produces an error because the AMT_SPENT column contains a null value.
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions102.htm
NULLIF compares expr1 and expr2. If they are equal, then the function returns null.
Cleared Oracle Database 11g 1Z0-051 exam last weekend!
Scored 90%! (The passing score is 60%)
There were 64 questions in my actual 1Z0-051 test.
Many questions on SQL statements (Examine, Evaluate…etc.), Manipulating Data (Insert, Update, Delete), Using DDL Statements to Create and Manage Tables.
Also, please pay close attention to questions on Reporting Aggregated Data Using the Group Functions, Using Subqueries to Solve Queries, Creating Schema Objects, a little difficult!
I mainly learned the PassLeader 1Z0-051 dumps (http://www.passleader.com/1z0-051.html) (303q VCE and PDF), all questions were from it, and many wrong answers have been corrected in it, the most valid 1Z0-051 dumps! DO RECOMMEND!!
By the way, part of that 303q 1Z0-051 dumps are available here:
http://www.oraclebraindump.com/?s=1z0-051
(
p.s. More 1Z0-051 exam questions on Google Drive: drive.google.com/open?id=0B-ob6L_QjGLpWXpBUEhyRnVXVlE
)
Good Luck!!!
B