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

更多“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”相关问题

第1题

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

点击查看答案
第2题

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.

点击查看答案
第3题

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.

点击查看答案
第4题

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?（）A、The valid time columns employee_time_start and employee_time_end are automatically created.B、The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.C、The valid time columns are not populated by the Oracle Server automatically.D、The valid time columns are visible by default when the table is described.E、Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio

点击查看答案
第5题

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 clauseD、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

点击查看答案
第6题

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.

点击查看答案
第7题

In which four clauses can a subquery be used? （）A、in the INTO clause of an INSERT statementB、in the FROM clause of a SELECT statementC、in the GROUP BY clause of a SELECT statementD、in the WHERE clause of a SELECT statementE、in the SET clause of an UPDATE statementF、in the VALUES clause of an INSERT statement

点击查看答案

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”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容