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.
第1题:
Which two statements are true about WHERE and HAVING clauses? ()
第2题:
Which two are true about aggregate functions? ()
第3题:
In which four clauses can a subquery be used? ()
第4题:
Which two statements about views are true?()
第5题:
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? ()
第6题:
Which two statements are true regarding the USING and ON clauses in table joins?()
第7题:
Immediately after the SELECT clause
Before the WHERE clause
Before the FROM clause
After the ORDER BY clause
After the WHERE clause
第8题:
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.
第9题:
A WHERE clause can be used to restrict both rows and groups.
A WHERE clause can be used to restrict rows only.
A HAVING clause can be used to restrict both rows and groups.
A HAVING clause can be used to restrict groups only.
A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
A HAVING clause CANNOT be used in subqueries.
第10题:
field names in the SELECT statement
the FROM clause in the SELECT statement
the HAVING clause in the SELECT statement
the GROUP BY clause in the SELECT statement
the WHERE clause in only the SELECT statement
the WHERE clause in SELECT as well as all DML statements
第11题:
It is executed first in the query execution
It must be the last clause in the SELECT statement
It cannot be used in a SELECT statement containing a HAVING clause
You cannot specify a column name followed by an expression in this clause
You can specify a combination of numeric positions and column names in this clause
第12题:
The SELECT statement is syntactically accurate.
The SELECT statement does not work because there is no HAVING clause.
The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
第13题:
Which two statements about subqueries are true? ()
第14题:
Which two statements are true regarding the ORDER BY clause? ()
第15题:
Which two statements are true regarding subqueries? ()
第16题:
Which three statements are true regarding single-row functions?()
第17题:
Where can subqueries be used?()
第18题:
A subquery can retrieve zero or more rows
Only two subqueries can be placed atone level
A subquery can be used only in SQL query statements
A subquery can appear on either side of a comparison operator
There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
第19题:
Both USING and ON clauses can be used for equijoins and nonequijoins
Amaximum of one pair of columns can be joined between two tables using the ON clause
The ON clause can be used to join tables on columns that have different names but compatible data types
The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
第20题:
A view can be created as read only.
A view can be created as a join on two or more tables.
A view cannot have an ORDER BY clause in the SELECT statement.
A view cannot be created with a GROUP BY clause in the SELECT statement.
A view must have aliases defined for the column names in the SELECT statement.
第21题:
in the INTO clause of an INSERT statement
in the FROM clause of a SELECT statement
in the GROUP BY clause of a SELECT statement
in the WHERE clause of a SELECT statement
in the SET clause of an UPDATE statement
in the VALUES clause of an INSERT statement
第22题:
A subquery should retrieve only one row.
A subquery can retrieve zero or more rows.
A subquery can be used only in SQL query statements.
Subqueries CANNOT be nested by more than two levels.
A subquery CANNOT be used in an SQL query statement that uses group functions.
When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
第23题:
They can accept only one argument.
They can be nested up to only two levels.
They can return multiple values of more than one data type.
They can be used in SELECT, WHERE, and ORDER BY clauses.
They can modify the data type of the argument that is referenced.
They can accept a column name, expression, variable name, or a user-supplied constant as arguments.