查看表INVOICE结构,下列哪个SQL语句能执行成功()
A: SELEC
B: inv_no,NVL2(inv_date,’Pending’,’Incomplete’)FRO
C: invoice
D: SELEC
E: inv_no,NVL2(inv_amt,inv_date,’NotAvailable’)FRO
F: invoice
G: SELEC
H: inv_no,NVL2(inv_date,sysdate-inv_date,sysdate)FRO
I: invoice
J: SELEC
K: inv_no,NVL2(inv_amt,inv_amt*.25,’NotAvailable’)FRO
L: invoice
A: SELEC
B: inv_no,NVL2(inv_date,’Pending’,’Incomplete’)FRO
C: invoice
D: SELEC
E: inv_no,NVL2(inv_amt,inv_date,’NotAvailable’)FRO
F: invoice
G: SELEC
H: inv_no,NVL2(inv_date,sysdate-inv_date,sysdate)FRO
I: invoice
J: SELEC
K: inv_no,NVL2(inv_amt,inv_amt*.25,’NotAvailable’)FRO
L: invoice
举一反三
- 查看表INVOICE的结果,哪两个SQL语句能执行成功() A: SELEC B: AVG(inv_date)FRO C: invoice D: SELEC E: MAX(inv_date),MIN(cust_id)FRO F: invoice G: SELEC H: MAX(AVG(SYSDATE-inv_date))FRO I: invoice J: SELEC K: AVG(inv_date-SYSDATE),AVG(inv_amt)FRO L: invoice
- 查看表MARKS结构,哪个SQL语句能执行成功() A: SELEC B: student_name,subject1.FRO C: marks.WHERE-subject1>AVG(subject1) D: SELEC E: student_name,SUM(subject1)FRO F: marks.WHERE-student_name-LIKE’R%’ G: SELEC H: SUM(subject1+subject2+subject3)FRO I: marks.WHERE-student_name-ISNULL J: SELEC K: SUM(DISTINC L: NVL(subject1,0)),MAX(subject1)FRO M: mark.sWHERE-subject1>subject2
- 在矩阵除法运算符中,A\B等价于();A/B等价于() A: inv(A)*B;A*inv(B) B: B*inv(A);A*inv(B) C: A*inv(B);inv(A)*B D: inv(A)*B;inv(B)*A
- A*X=B,则X=( ). A: inv(A)*B B: B*inv(A) C: inv(B)*A D: A*inv(B)
- A*X=B,则X=( )(A的行列式值不等于零) A: inv(A)*B B: B*inv(A) C: inv(B)*A D: A*inv(B)