OCP-1Z0-051-V9 02-96题

分享一下我老师大神的人工智能教程。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.youkuaiyun.com/jiangjunshow

               

96. Examine the structure of the INVOICE table.

name           Null        Type

INV_NO         NOT NULL    NUMBER(3)

INV_DATE                  DATE

INV_AMT                   NUMBER(10,2)

Which two SQL statements  would execute successfully?  (Choose two.)

A. SELECT inv_no,NVL2(inv_date,'Pending','Incomplete')

FROM invoice;

B. SELECT inv_no,NVL2(inv_amt,inv_date,'Not Available') 

FROM invoice;

C. SELECT inv_no,NVL2(inv_date,sysdate-inv_date,sysdate) 

FROM invoice;

D. SELECT inv_no,NVL2(inv_amt,inv_amt*.25,'Not Available')

FROM invoice;

Answer: A