Evaluate the following statement. INSERT ALL WHEN Order_total 10000 AND order_total 200000 AND order_total Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

Correct Answer is : They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.

The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true

Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 3 of 50

Marks: +1, -0

Evaluate the following statement.

 INSERT ALL  
   WHEN Order_total < 10000 THEN 
  INTO small_orders 
  WHEN order_total > 10000 AND order_total < 20000 THEN 
   INTO medium_orders 
  WHEN order_total > 200000 AND order_total < 20000 THEN  
  INTO large_orders  
  SELECT order_id, order_total, customer_id 
  FROM orders;

Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.
They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.
The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true

Validate

Go to Question:

Prev Question

Next Question