3. þ D. The syntax is wrong: use either the VALUES keyword or a subquery, but
not both. Remove the VALUES keyword, and it will run. C3 and C4 would be
populated with NULLs.
ý A, B, C, and E. A is wrong because there is no need to provide values for
columns not listed. B and C are wrong because an INSERT can insert a set of
rows, so there is no need to restrict the number with a WHERE clause or by
using MAX or MIN to return only one row. E is wrong because the statement
is not syntactically correct.
Bạn đang xem 3. - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P41 POTX