多选题Which two are true about aggregate functions?（）AYou can use aggregate functions in any clause of a SELECT statement.BYou can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.CYou can mix

题目

多选题

Which two are true about aggregate functions?（）

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

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

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

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

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

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

更多“多选题Which two are true about aggregate functions?（）AYou can use aggregate functions in any clause of a SELECT statement.BYou can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.CYou can mix”相关问题

第1题

Which two statements are true regarding the ORDER BY clause? （）A、It is executed first in the query execution B、It must be the last clause in the SELECT statement C、It cannot be used in a SELECT statement containing a HAVING clauseD、You cannot specify a column name followed by an expression in this clause E、You can specify a combination of numeric positions and column names in this clause

点击查看答案
第2题

In which four clauses can a subquery be used? （）A、in the INTO clause of an INSERT statementB、in the FROM clause of a SELECT statementC、in the GROUP BY clause of a SELECT statementD、in the WHERE clause of a SELECT statementE、in the SET clause of an UPDATE statementF、in the VALUES clause of an INSERT statement

点击查看答案
第3题

Which two statements are true regarding subqueries? （）A、A subquery can retrieve zero or more rows B、Only two subqueries can be placed atone level C、A subquery can be used only in SQL query statements D、A subquery can appear on either side of a comparison operator E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement

点击查看答案
第4题

Which two statements about views are true?（）A、A view can be created as read only.B、A view can be created as a join on two or more tables.C、A view cannot have an ORDER BY clause in the SELECT statement.D、A view cannot be created with a GROUP BY clause in the SELECT statement.E、A view must have aliases defined for the column names in the SELECT statement.

点击查看答案
第5题

Which three statements are true regarding single-row functions？（）A、 They can accept only one argument.B、 They can be nested up to only two levels.C、 They can return multiple values of more than one data type.D、 They can be used in SELECT， WHERE， and ORDER BY clauses. E、 They can modify the data type of the argument that is referenced.F、 They can accept a column name， expression， variable name， or a user-supplied constant as arguments.

点击查看答案
第6题

The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement? （）A、The SQL statement displays the desired results.B、The column in the WHERE clause should be changed to display the desired results.C、The operator in the WHERE clause should be changed to display the desired results.D、The WHERE clause should be changed to use an outer join to display the desired results.

点击查看答案
第7题

Where can subqueries be used?（）A、field names in the SELECT statement B、the FROM clause in the SELECT statement C、the HAVING clause in the SELECT statementD、the GROUP BY clause in the SELECT statement E、the WHERE clause in only the SELECT statement F、the WHERE clause in SELECT as well as all DML statements

点击查看答案

多选题Which two are true about aggregate functions?（）AYou can use aggregate functions in any clause of a SELECT statement.BYou can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.CYou can mix

题目

更多“多选题Which two are true about aggregate functions?（）AYou can use aggregate functions in any clause of a SELECT statement.BYou can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.CYou can mix”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容