OCP-1Z0-新051-61题版本-53

狂欢‰一夜

　　QUESTION NO: 53
　　The PRODUCTS table has the following structure:


　　Which statement is true regarding the outcome?
　　A. Both the statements execute and give the same result
　　B. Both the statements execute and give different results
　　C. Only the second SQL statement executes successfully
　　D. Only the first SQL statement executes successfully
　　Answer: B
　　答案解析：
　　参考：95：http://blog.iyunv.com/rlhua/article/details/11808291
　　Explanation:
　　Using the NVL2 Function
　　The NVL2 function examines the first expression. If the first expression is not null, the NVL2
　　function returns the second expression. If the first expression is null, the third expression is
　　returned.
　　Syntax
　　NVL2(expr1, expr2, expr3)
　　In the syntax:
　　expr1 is the source value or expression that may contain a null
　　expr2 is the value that is returned if expr1 is not null
　　expr3 is the value that is returned if expr1 is null
　　Oracle 1z0-051 Exam
　　"Pass Any Exam. Any Time." - 100% Pass Guarantee 45
         版权声明：本文为博主原创文章，未经博主允许不得转载。