你需要为每个客户的信息额度增加$1000。在输出时,客户的lastname列头应为()
A: SELEC
B: cust_last_name.Name,cust_credit_limit+1000"New.Credit.Limit"FRO
C: customers
D: SELEC
E: cust_last_name.ASName,cust_credit_limit+1000A
F: New.Credit.Limit.FRO
G: customers
H: SELEC
I: cust_last_name.AS"Name",cust_credit_limit+1000AS"New.Credit.Limit"FRO
J: customers
K: SELEC
L: INITCAP(cust_last_name)"Name",cust_credit_limit+1000INITCAP("NEWCREDITLIMIT")FRO
M: customers
A: SELEC
B: cust_last_name.Name,cust_credit_limit+1000"New.Credit.Limit"FRO
C: customers
D: SELEC
E: cust_last_name.ASName,cust_credit_limit+1000A
F: New.Credit.Limit.FRO
G: customers
H: SELEC
I: cust_last_name.AS"Name",cust_credit_limit+1000AS"New.Credit.Limit"FRO
J: customers
K: SELEC
L: INITCAP(cust_last_name)"Name",cust_credit_limit+1000INITCAP("NEWCREDITLIMIT")FRO
M: customers
举一反三
- 查看表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
- John has just paid off the full balance of his credit card. What happens to the debt? ( ) A: John will be paid an interest. B: His credit limit will be increased. C: It is added back to his credit limit to be used again. D: It remains a debt.
- 查看表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
- please translate the following into Chinese according to hotel management rules.House credit limit
- 查看表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