当前位置:1Z0-007题库

问题:

[多选] 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 parameter 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.

男性,38岁。因车祸发生脾破裂,除立即手术外需输人大量血液。在等待配血期间,静脉输液宜首选() 5%葡萄糖液。 5%葡萄糖等渗盐水。 平衡盐溶液。 林格液。 5%碳酸氢钠。 关于混凝土养护措施的说法,错误的是()。 应在混凝土浇筑完毕后的l2h以内对混凝土加以覆盖并保湿养护。 对于掺用缓凝外加剂或有抗渗要求的混凝土,浇水养护的时间不得少于21日。 混凝土养护应采用与拌制用水相同的水。 混凝土强度达到设计强度的1.2N/mm2前,不得在其上踩踏或安装模板及支架。 Over the course of a day,a department performed multiple DML statements (inserts, updates, deletes) on multiple rows of data in multiple tables. The manager would like a report showing the time, table name,and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list?()  Flashback Drop。  Flashback Query。  Flashback Transaction Query。  Flashback Versions Query。  Flashback Table。 体育教学模式由()、()、()三要素组成。 Which two statements are true regarding transactions in an Oracle database() Multiple transactions can use the same undo segment.。 A transaction is assigned an undo segment when it is started.。 More than one transaction cannot share the same extent in the undo tablespace.。 The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.。 Which two are true about aggregate functions?()
参考答案: A, E

  参考解析

本题暂无解析

在线 客服