a schema object
a subquery that can contain an ORDER BY clause
another name for a view that contains group functions
a subquery that is part of the FROM clause of another query
第1题:
A. The SELECT statement is syntactically accurate.
B. The SELECT statement does not work because there is no HAVING clause.
C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
第2题:
Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?()
A.The SELECT statement is syntactically accurate.
B.The SELECT statement does not work because there is no HAVING clause.
C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
第3题:
A. a schema object
B. a subquery that can contain an ORDER BY clause
C. another name for a view that contains group functions
D. a subquery that is part of the FROM clause of another query
第4题:
Which two statements about subqueries are true? ()
第5题:
Which of the following abilities does a view NOT provide?()
第6题:
A. the use of rowid
B. a GROUP BY clause
C. an ORDER BY clause
D. only an inline view
E. an inline view and an outer query
第7题:
Which three statements are true regarding subqueries?()
第8题:
A. in the INTO clause of an INSERT statement
B. in the FROM clause of a SELECT statement
C. in the GROUP BY clause of a SELECT statement
D. in the WHERE clause of a SELECT statement
E. in the SET clause of an UPDATE statement
F. in the VALUES clause of an INSERT statement
第9题:
Which two statements are true regarding views?()
第10题:
Which three statements about subqueries are true? ()