A对
B错
第1题:
第2题:
In which four clauses can a subquery be used?()
第3题:
Which two statements about subqueries are true? ()
第4题:
One of the is sues that have to be resolved in an export transaction is the currency to()in the payment clause.
第5题:
Which two statements are true about WHERE and HAVING clauses? ()
第6题:
Which two statements are true regarding the USING and ON clauses in table joins?()
第7题:
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
第8题:
The sort is in ascending by order by default.
The sort is in descending order by default.
The ORDER BY clause must precede the WHERE clause.
The ORDER BY clause is executed on the client side.
The ORDER BY clause comes last in the SELECT statement.
The ORDER BY clause is executed first in the query execution.
第9题:
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
第10题:
A single row subquery can retrieve data from only one table.
A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.
A single row subquery can retrieve data from more than one table.
A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
第11题:
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.
第12题:
In
On
With
At
第13题:
第14题:
The relationship between the embedded clause and its matrix clause is one of a part to the whole.
第15题:
Which of the following statements is true regarding the VERSIONS BETWEEN clause?()
第16题:
Which two statements are true regarding the ORDER BY clause? ()
第17题:
Where can subqueries be used?()
第18题:
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
第19题:
The statement would not execute because table aliases are not allowed in the JOIN clause.
The statement would not execute because the table alias prefix is not used in the USING clause.
The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.
The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.
第20题:
对
错
第21题:
The VERSIONS BETWEEN clause may be used in DML statements.
The VERSIONS BETWEEN clause may be used in DDL statements.
The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
第22题:
Immediately after the SELECT clause
Before the WHERE clause
Before the FROM clause
After the ORDER BY clause
After the WHERE clause
第23题:
the appositive clause
the attributive clause
the object clause
the subject clause