Lab 3.1 Self-Review Questions

In order to test your progress, you should be able to answer the following questions.

1)	If a variable is declared as follows , what are the results? v_fixed_amount CONSTANT NUMBER; _____ A NUMBER variable called v_fixed_amount has been declared (it will remain as a constant once initialized ). _____ A NUMBER variable called v_fixed_amount has been declared (it will remain as null). _____ An error message will result because constant initialization must be done in the executable section of the block. _____ An error message will result because the declaration for the CONSTANT is missing an assignment to a NUMBER.
2)	Which of the following are valid character types for PL/SQL? _____ Numbers _____ English letters _____ Paragraph returns _____ Arithmetic symbols _____ Japanese Kanji
3)	A variable may be used for which of the following? _____ To hold a constant, such as the value of p _____ To hold the value of a counter that keeps changing _____ To place a value that will be inserted into the database _____ To hold onto the function of an operand _____ To hold any value as long as you declare it
4)	Which of the following will declare a variable that is of the identical data type as the student_id in the database table STUDENT in the CTA database? _____ v_id student_id := 123; _____ v_id binary integer; _____ v_id number NUMBER := 24; _____ v_id student_id%type;
5)	The value of a variable is set to null after the 'end;' of the block is issued. _____ True _____ False

Answers appear in Appendix A, Section 3.1 .