Evaluatethefollowingstatement:WhichstatementistrueregardingtheevaluationofrowsreturnedbythesubqueryintheINSERTstatement?()
A.TheyareevaluatedbyallthethreeWHENclausesregardlessoftheresultsoftheevaluationofanyotherWHENclause.
B.TheyareevaluatedbythefirstWHENclause.Iftheconditionistrue,thentherowwouldbeevaluatedbythesubsequentWHENclauses.
C.TheyareevaluatedbythefirstWHENclause.Iftheconditionisfalse,thentherowwouldbeevaluatedbythesubsequentWHENclauses.
D.TheINSERTstatementwouldgiveanerrorbecausetheELSEclauseisnotpresentforsupportincasenoneoftheWHENclausesaretrue.