Question 1 Which of the following variable declarations is illegal?
1) lv_junk NUMBER(3);
2) lv_junk NUMBER(3) NOT NULL;
3) lv_junk NUMBER(3) := 11;
4) lv_junk NUMBER(3) CONSTANT := 11;
Question 2 Which of the following is not a possible value for a Boolean variable?
1) TRUE
2) FALSE
3) BLANK
4) NULL
Question 3 What type of variable can store only one value?
1) local
2) scalar
3) simple
4) declared
Question 4 What keyword is used to check multiple conditions with an IF statement?
1) ELSE IF
2) ELSEIF
3) ELSIF
4) ELSIFS
Question 5 What type of loop can be used if the loop might not need to execute under certain circumstances?
1) FOR
2) WHILE
3) basic
4) All of the above
Question 6 How is the looping action of a basic loop stopped?
1) It's stopped when the condition in the LOOP statement is FALSE.
2) This type of loop has a predetermined number of loops to complete.
3) The condition in an EXIT WHEN statement is FALSE.
4) The condition in an EXIT WHEN statement is TRUE.
Question 7 When does a WHILE loop evaluate the condition that determines whether the looping action continues?
1) at the beginning of the loop
2) somewhere inside the loop
3) at the end of the loop
4) all of the above
Question 8 If you know the number of loop iterations ahead of time, what type of loop should be used?
1) FOR
2) WHILE
3) basic
4) None of the above
Question 9 What commands can be used to end loop execution? (Choose all that apply.)
1) CONTINUE
2) EXIT
3) EXIT WHEN
4) STOP
Question 10 Which programming constructs can use a CONTINUE statement?
1) IF/THEN statements
2) loops
3) CASE statements
4) All of the above
Question 11 What are variables, and why are they needed?
Question 12 Name the three main types of loop structures in PL/SQL, and explain the difference in how each determines how many times a loop iterates.
Question 13 What are the two types of decision structures in PL/SQL?
Question 14 How can flowcharts assist developers?
Question 15 What happens when a CONSTANT option is set in a variable declaration?