Which two are true about aggregate functions? （）

A

You can use aggregate functions in any clause of a SELECT statement.

B

You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.

C

You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.

D

You can pass column names, expressions, constants, or functions as parameters to an aggregate function.

E

You can use aggregate functions on a table, only by grouping the whole table as one single group.

F

You cannot group the rows of a table by more than one column while using aggregate functions.

相关问题推荐

• Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?（）

  A、SELECT last_name, 12*salary* commission_pct FROM emp;

  B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;

  C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;

  D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

  查看答案

• 患儿，男，13岁，因"高热2天"于当年7月20日收治入院，入院后第3天确诊为流行性乙型脑炎，下列对病人的做法正确的是（）

  A、严密隔离

  B、呼吸道隔离

  C、消化道隔离

  D、接触隔离

  E、虫媒隔离

  查看答案

• 一个子网网段地址为10.32.0.0掩码为255.224.0.0的网络，它允许的最大主机地址是（）。

  A、10.32.254.254

  B、10.32.255.254

  C、10.63.255.254

  D、10.63.255.255

  查看答案

• 患儿，男性，6岁，突然发热、腹痛、腹泻2天，每天排便15次以上，粪便为黏液脓血便。入院查体：体温39.9℃，BP110／70mmHg，神清，双侧瞳孔等大等圆，左下腹压痛。入院诊断为"细菌性痢疾"。确诊前，为该病人采集便标本时，下列注意事项不需要的是（）

  A、采集脓血部分

  B、可连续多次取样

  C、标本应立即送检

  D、注意标本保温

  E、不要被尿液污染

  查看答案

• 在PowerPoint2010中，幻灯片的放映类型有（）。

  A、演讲者放映

  B、观众自行浏览

  C、在展台浏览

  D、循环放映

  查看答案