OCP 11G认证考试
多选题Which two statements are true regarding the ORDER BY clause? （）AIt is executed first in the query executionBIt must be the last clause in the SELECT statementCIt cannot be used in a SELECT statement containing a HAVING clauseDYou cannot specify a colum
题目
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
相似问题和答案
第1题：
Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）
- A、 The VERSIONS BETWEEN clause may be used in DML statements.
- B、 The VERSIONS BETWEEN clause may be used in DDL statements.
- C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
- D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
正确答案:C
第2题：
Which two statements are true regarding the ORDER BY clause? （）
- A、The sort is in ascending by order by default.
- B、The sort is in descending order by default.
- C、The ORDER BY clause must precede the WHERE clause.
- D、The ORDER BY clause is executed on the client side.
- E、The ORDER BY clause comes last in the SELECT statement.
- F、The ORDER BY clause is executed first in the query execution.
正确答案:A,E
第3题：
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.
第4题：
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 clause
- D、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
正确答案:B,E
第5题：
Which two statements are true about WHERE and HAVING clauses? （）
- A、A WHERE clause can be used to restrict both rows and groups.
- B、A WHERE clause can be used to restrict rows only.
- C、A HAVING clause can be used to restrict both rows and groups.
- D、A HAVING clause can be used to restrict groups only.
- E、A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
- F、A HAVING clause CANNOT be used in subqueries.
正确答案:B,D
第6题：
Which statement is true regarding the INTERSECT operator?（）
- A、It ignores NULL values
- B、Reversing the order of the intersected tables alters the result
- C、The names of columns in all SELECT statements must be identical
- D、The number of columns and data types must be identical for all SELECT statements in the query
正确答案:D
第7题：
Which two statements are true regarding views?（）
- A、A subquery that defines a view cannot include the GROUP BY clause
- B、A view that is created with the subquery having the DISTINCT keyword can be updated
- C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated
- D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table
正确答案:C,D
第8题：
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.
第9题：
Which two statements about subqueries are true? （）
- A、A subquery should retrieve only one row.
- B、A subquery can retrieve zero or more rows.
- C、A subquery can be used only in SQL query statements.
- D、Subqueries CANNOT be nested by more than two levels.
- E、A subquery CANNOT be used in an SQL query statement that uses group functions.
- F、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.
正确答案:B,F
第10题：
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
正确答案:A,D