In which four clauses can a sub query be used? (Choose four.)
A.
in the INTO clause of an INSERT statement
B.
in the VALUES clause of an INSERT statement
C.
in the SET clause of an UPDATE statement
D.
in the FROM clause of a SELECT statement
E.
in the GROUP BY clause of a SELECT statement
F.
in the WHERE clause of a SELECT statement
Explanation:
B is also correct.
create table test_tab (a number, b number);
insert into test_tab values (1,2);
insert into (select a,b from test_tab) values ( (select a from test_tab), (select b from test_tab));