单选题Evaluate the following statement： Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）A They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.B They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.C They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.D The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
单选题
Evaluate the following statement： Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）
A
They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
B
They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.
C
They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.
D
The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
参考解析
解析：
暂无解析
相关考题：
Evaluate the following function code:Which statement is true regarding the above function? () A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.B. If the function execution results in an unhandled exception, the exception result is also stored in the cache.C. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.D. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.
Evaluate the following command:Which statement is true regarding the above command?() A. The LOB matically compressed.B. The LOB values are cached bvalues are autoy default in the buffer cache.C. The LOB values are automatically stored in encrypted mode.D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? () A. It releases the storage space used by the table.B. It does not release the storage space used by the table.C. You can roll back the deletion of rows after the statement executes.D. You can NOT roll back the deletion of rows after the statement executes.E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
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 routing policy processing?() A. The Junos OS verifies the match criteria of each policy in order and performs the associated action when a match occurs.B. Policies are evaluated from right to left as displayed in the Junos OS configuration file.C. Polices are evaluated based on the order in which they are applied to a routing protocol.D. Policy processing stops once the last statement in the policy is evaluated.
Which of the following statement（s）is/are TRUE regarding a twin pedestal crane set ________．A.The cranes may be operated independentlyB.The cranes may be interconnected for twin operationC.When twinned，the crane rotation on the foundation assembly is unlimitedD.All of the above
Which two statements are true regarding routing policy processing?（）A、The Junos OS verifies the match criteria of each policy in order and performs the associated action when a match occurs.B、Policies are evaluated from right to left as displayed in the Junos OS configuration file.C、Polices are evaluated based on the order in which they are applied to a routing protocol.D、Policy processing stops once the last statement in the policy is evaluated.
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.
Which three are true?（）A、A MERGE statement is used to merge the data of one table with data from another.B、A MERGE statement replaces the data of one table with that of another.C、A MERGE statement can be used to insert new rows into a table.D、A MERGE statement can be used to update existing rows in a table.
Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）A、It releases the storage space used by the table.B、It does not release the storage space used by the table.C、You can roll back the deletion of rows after the statement executes.D、You can NOT roll back the deletion of rows after the statement executes.E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
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
Evaluate the following command： SQL CREATE TABLE design_data （id NUMBER， doc CLOB） LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）； Which statement is true regarding the above command？（） A、 The LOB values are automatically compressed.B、 The LOB values are cached by default in the buffer cache.C、 The LOB values are automatically stored in encrypted mode.D、 All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
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
Which statement is true regarding the COALESCE function?（）A、It can have a maximum of five expressions in a list B、It returns the highest NOT NULL value in the list for all rows C、It requires that all expressions in the list must be of the same data type D、It requires that at least one of the expressions in the list must have a NOT NULL value
Which two statements about subqueries are true? （）A、A single row subquery can retrieve data from only one table.B、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.C、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.D、A single row subquery can retrieve data from more than one table.E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.F、A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
Which statement is true regarding Flashback Version Query？ （）A、 It returns versions of rows only within a transaction.B、 It can be used in subqueries contained only in a SELECT statement.C、 It will return an error if the undo retention time is less than the lower bound time or SCN specified.D、 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.
Which statement is true regarding subqueries?（）A、The LIKE operator cannot be used with single-row subqueries B、The NOT IN operator is equivalent to IS NULL with single-row subqueries C、=ANY and =ALL operators have the same functionality in multiple-row subqueries D、The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries
单选题Which statement is true regarding Flashback Version Query？（）A It returns versions of rows only within a transaction.B It can be used in subqueries contained only in a SELECT statement.C It will return an error if the undo retention time is less than the lower bound time or SCN specified.D It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.
多选题Which two statements are true regarding subqueries? （）AA subquery can retrieve zero or more rowsBOnly two subqueries can be placed atone levelCA subquery can be used only in SQL query statementsDA subquery can appear on either side of a comparison operatorEThere is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
单选题Which statement is true regarding the COALESCE function?（）AIt can have a maximum of five expressions in a list BIt returns the highest NOT NULL value in the list for all rows CIt requires that all expressions in the list must be of the same data type DIt requires that at least one of the expressions in the list must have a NOT NULL value
单选题Evaluate the following command： SQL CREATE TABLE design_data （id NUMBER， doc CLOB） LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）； Which statement is true regarding the above command？（）A The LOB values are automatically compressed.B The LOB values are cached by default in the buffer cache.C The LOB values are automatically stored in encrypted mode.D All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
单选题View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. Evaluate the following SQL statement： SELECT oi.order_id， product_jd， order_date FROM order_items oi JOIN orders o USING （order_id）； Which statement is true regarding the execution of this SQL statement？（）A The statement would not execute because table aliases are not allowed in the JOIN clause.B The statement would not execute because the table alias prefix is not used in the USING clause.C The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.D The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.
多选题In which four clauses can a subquery be used? （）Ain the INTO clause of an INSERT statementBin the FROM clause of a SELECT statementCin the GROUP BY clause of a SELECT statementDin the WHERE clause of a SELECT statementEin the SET clause of an UPDATE statementFin the VALUES clause of an INSERT statement
多选题Which two statements about subqueries are true? （）AA single row subquery can retrieve data from only one table.BA 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.CA SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.DA single row subquery can retrieve data from more than one table.EA single row subquery cannot be used in a condition where the LIKE operator is used for comparison.FA multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
多选题Which three are true? （）AA MERGE statement is used to merge the data of one table with data from another.BA MERGE statement replaces the data of one table with that of another.CA MERGE statement can be used to insert new rows into a table.DA MERGE statement can be used to update existing rows in a table.
多选题Which two statements about subqueries are true? （）AA subquery should retrieve only one row.BA subquery can retrieve zero or more rows.CA subquery can be used only in SQL query statements.DSubqueries CANNOT be nested by more than two levels.EA subquery CANNOT be used in an SQL query statement that uses group functions.FWhen 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.
单选题Evaluate the following command: Which statement is true regarding the above command?（）A The LOB matically compressed.B The LOB values are cached bvalues are autoy default in the buffer cache.C The LOB values are automatically stored in encrypted mode.D All LOB data that is identical in two or more rows in a LOB column share the same data blocks.