题目内容

Excel计算参数的平均数函数是()。

A. COUNT
B. AVERAGE
C. MAX
D. SUM

查看答案
更多问题

Given: What is the result?()

A. test
C. An exception is thrown at runtime.
D. Compilation fails because of an error in line 1.
E. Compilation fails because of an error in line 4.
F. Compilation fails because of an error in line 5.

Given: What is the result?()

A. 0.0
B. Compilation fails.
C. A ParseException is thrown by the parse method at runtime.
D. A NumberFormatException is thrown by the parse method at runtime.

ClicktheExhibitbuttontoexaminethedataoftheEMPLOYEEStable. WhichstatementliststheID,name,andsalaryoftheemployee,andtheIDandnameoftheemployee'smanager,foralltheemployeeswhohaveamanagerandearnmorethan4000?()

A. SELECTemployee_id"Emp_id",emp_name"Employee",salary,employee_id"Mgr_id",emp_name"Manager"FROMemployeesWHEREsalary>4000;
B. SELECTe.employee_id"Emp_id",e.emp_name"Employee",e.salary,m.employee_id"Mgr_id",m.emp_name"Manager"FROMemployeeseJOINemployeesmWHEREe.mgr_id=m.mgr_idANDe.salary>4000;
C. SELECTe.employee_id"Emp_id",e.emp_name"Employee",e.salary,m.employee_id"Mgr_id",m.emp_name"Manager"FROMemployeeseJOINemployeesmON(e.mgr_id=m.employee_id)ANDe.salary>4000;
D. SELECTe.employee_id"Emp_id",e.emp_name"Employee",e.salary,m.mgr_id"Mgr_id",m.emp_name"Manager"FROMemployeeseSELFJOINemployeesmWHEREe.mgr_id=m.employee_idANDe.salary>4000;
E. SELECTe.employee_id"Emp_id",e.emp_name"Employee",e.salary,m.mgr_id"Mgr_id"m.emp_name"Manager"FROMemployeeseJOINemployeesmUSING(e.employee_id=m.employee_id)ANDe.salary>4000;

Which two statements are true?()

A. Line 35 will not compile.
B. Line 36 will not compile.
C. Line 37 will not compile.
D. Line 38 will not compile.

答案查题题库