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
第1题:
A.A table referenced in the FROM clause has no indexed column.
B.The table referenced in the FROM clause has more than 200 columns.
C.Two or more tables in the FROM clause have identical column names.
D.The FROM clause contains two or more tables in the SELECT statement.
第2题:
对于满足SQL92标准的SQL语句: select foo,count(foo)from pokes where foo>10group by foo having count (*)>5 order by foo 其执行顺序应该是()。
第3题:
Which two statements are true about WHERE and HAVING clauses? ()
第4题:
Which two statements are true regarding the ORDER BY clause? ()
第5题:
Which two statements are true regarding subqueries? ()
第6题:
Which two statements about views are true?()
第7题:
Which two statements are true regarding the USING and ON clauses in table joins?()
第8题:
Immediately after the SELECT clause
Before the WHERE clause
Before the FROM clause
After the ORDER BY clause
After the WHERE clause
第9题:
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
第10题:
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.
第11题:
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
第12题:
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
第13题:
In which of the following situations should correlation names be used?()
第14题:
In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?()
第15题:
Which two are true about aggregate functions? ()
第16题:
In which four clauses can a subquery be used? ()
第17题:
Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?()
第18题:
Where can subqueries be used?()
第19题:
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
第20题:
remove the ORDER BY clause
remove the table alias prefix from the WHERE clause
remove the table alias from the SELECT clause
prefix the column in the USING clause with the table alias
prefix the column in the ORDER BY clause with the table alias
replace the condition d.department_id NOT IN (10,40) in the WHERE clause with d.department_id <> 10 AND d.department_id <> 40
第21题:
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.
第22题:
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.
第23题:
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
第24题:
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.