Case Statements

Test:Quiz:ConditionalControl:CaseStatements 1. E x a mi n e t h e fo l l ow i n g c o d e : DECLARE v_scoreNUMBER(3); v_gradeCHAR(1); BEGIN v_grade:=CASEv_score --LineA .... TheCASEexpressionmustconvertanumericscoretoalettergrade:90 TheCASEexpressionmustconvertanumericsco retoalettergrade:90->A,80 ->A,80 ->B,70->Candsoon.WhatshouldbecodedatLineA? MarkforReview (1)Points WHEN90THENgrade:='A' WHEN90THENv_grade:='A'; WHEN90THEN'A'(*) WHEN90THEN'A';

Correct 2. How Howmu must sty you ou end enda aCA CASE SEe exp xpre ress ssio ion? n? (1)Points END;(*) ENDIF; ENDCASE; ENDCASE;

Correct 3. Ex a m i n e th e f ol l o wi n g c o d e: DECLARE v_scoreNUMBER(3); v_gradeCHAR(1); BEGIN CASEv_score --LineA ....

Mark Markf for orR Rev evie iew w

TheCASEstatementmustconvertanumericscoretoalettergrade:90TheCASEstatementmustconvertanumericscor etoalettergrade:90->A,80>A,80>B,70->Candsoon. WhatshouldbecodedatLineA? MarkforReview (1)Points WHEN90THENv_grade:='A' WHEN90THENv_grade:='A';(*) WHEN90THEN'A' WHEN90THEN'A';

Correct 4. Wha What twi will llb be edi disp spla laye yed dwh when ent the hef fol ollo lowi wing ngb blo lock cki is sex exec ecut uted ed? ? DECLARE v_ageNUMBER(3); v_genderVARCHAR2(6):='Female'; v_statusVARCHAR2(20); BEGIN CASE WHENv_age>=18ANDv_gender='Male'THE WHENv_age>=18A NDv_gender='Male'THENv_status:='AdultMale Nv_status:='AdultMale'; '; WHENv_age>=18ANDv_gender='Female'T WHENv_age>=18A NDv_gender='Female'THENv_status:='AdultFe HENv_status:='AdultFemale'; male'; WHENv_age<18ANDv_gender='Male'THEN WHENv_age<18AN Dv_gender='Male'THENv_status:='JuniorMale v_status:='JuniorMale'; '; WHENv_age<18ANDv_gender='Female'T WHENv_age<18A NDv_gender='Female'THENv_status:='JuniorF HENv_status:='JuniorFemale';< emale';< br/>ELSEv_status:='OtherValue'; ENDCASE; DBMS_OUTPUT.PUT_LINE(v_status); END; MarkforReview (1)Points AdultMale JuniorFemale OtherValue(*) NothingwillbedisplayedbecauseV_STATUSissettoNULL.

Correct 5.

L o o k a t t h e f ol l o wi n g c o d e:

DECLARE xBOOLEAN:=FALSE; yBOOLEAN:=FALSE; zBOOLEAN; BEGIN z:=(xORNOTy); --LineA .... END; WhatisthevalueofZatLineA? MarkforReview (1)Points True(*) False NULL AnerrorwilloccurbecauseyoucannotcombinetwoBooleanvariablesus Anerrorwilloccurbecauseyoucannotcombine twoBooleanvariablesusi i ng"NOT".

Correct 6. What Whatw wil ill lbe bed dis ispl play ayed edw whe hen nth the efo foll llow owin ing gbl bloc ock kis ise exe xecu cute ted? d? DECLARE v_age1NUMBER(3); v_age2NUMBER(3); v_messageVARCHAR2(20); BEGIN CASE WHENv_age1=v_age2THENv_message:='Equal'; WHENv_age1<>v_age2THENv_message:='Unequal'; ELSEv_message:='Undefined'; ENDCASE; DBMS_OUTPUT.PUT_LINE(v_message); END; MarkforReview (1)Points Equal Undefined(*) Unequal NothingwillbedisplayedbecauseV_MESSAGEissettoNULL.

Correct 7. Ex a m i n e th e f ol l o wi n g c o d e: DECLARE v_aBOOLEAN; v_bBOOLEAN:=FALSE; v_cBOOLEAN; BEGIN v_c:=(v_aANDv_b); --LineA .... END; Whatisthevalueofv_catLineA? MarkforReview (1)Points True False(*) NULL Undefined

Correct 8. H o w m u s t y o u e n d a C A S E s t a t e m e n t? (1)Points END; ENDCASE;(*) ENDIF; ENDCASE;

Correct

M a r k fo r R e v i e w