Which two statements are true regarding the USING and ON clauses in table joins?（）A、Both USING and ON clauses can be used for equijoins and nonequijoins B、Amaximum of one pair of columns can be joined between two tables using the ON clause C、The ON clause

题目

Which two statements are true regarding the USING and ON clauses in table joins?（）

A、Both USING and ON clauses can be used for equijoins and nonequijoins
B、Amaximum of one pair of columns can be joined between two tables using the ON clause
C、The ON clause can be used to join tables on columns that have different names but compatible data types
D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

In which of the following situations should correlation names be used?()

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.

参考答案：C

第2题：

In which of the following situations should correlation names be used?（）

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.

正确答案:C

第3题：

Which two statements regarding a SQL profile are true?()

A. It is built by Automatic Tuning Optimizer.

B. It cannot be stored persistently in the data dictionary.

C. It can be used by the query optimizer automatically.

D. It can be created manually by using the CREATE PROFILE command.

参考答案：A, C

第4题：

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

第5题：

Which three statements are true regarding subqueries?（）

A、Subqueries can contain GROUP BY and ORDER BY clauses
B、Main query and subquery can get data from different tables
C、Main query and subquery must get data from the same tables
D、Subqueries can contain ORDER BY but not the GROUP BY clause
E、Only one column or expression can be compared between the main query and subquery
F、 Multiple columns or expressions can be compared between the main query and subquery

正确答案:A,B,E

第6题：

Which two statements are true regarding the USING clause in table joins?（）

A、It can be used to join a maximum of three tables
B、It can be used to restrict the number of columns used in a NATURAL join
C、It can be used to access data from tables through equijoins as well as nonequijoins
D、It can be used to join tables that have columns with the same name and compatible data types

正确答案:B,D

第7题：

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

第8题：

In which four clauses can a subquery be used? ()

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

参考答案：B, D, E, F

第9题：

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

第10题：

Which two are true about aggregate functions? （）

A、You can use aggregate functions in any clause of a SELECT statement.
B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
F、You cannot group the rows of a table by more than one column while using aggregate functions.

正确答案:A,D

Which two statements are true regarding the USING and ON clauses in table joins?（）A、Both USING and ON clauses can be used for equijoins and nonequijoins B、Amaximum of one pair of columns can be joined between two tables using the ON clause C、The ON clause

题目

相似问题和答案

更多相关问题

相关内容