Section 2 Lesson 4: Using Scalar Data Types

Using Scalar Data Types

 Section 1
   
  1.  If you use the %TYPE attribute, you can avoid hard-coding the column name. True or False?  (1) Points
   
    True
    False (*)

  2.  Code is easier to read if you declare one identifier per line. True or False? (1) Points
   
    True (*)
    False
   
  3.  Which of the following is NOT a good guideline for declaring variables?  (1) Points
   
    Declare one identifier per line
    Use column names as identifiers (*)
    Use NOT NULL when the variable must have a value

  4.  Which of the following variable declarations does NOT use a number data type?  (1) Points
   
    v_count PLS_INTEGER := 0;
    v_median_age NUMBER(6,2);
    v_students LONG; (*)
    v_count BINARY_INTEGER;

  5.  When declared using %TYPE, a variable will inherit ____ from the column on which it is based.  (1) Points
   
    The name of the column
    The value of the column
    The data type and size of the column (*)
   
  6.  Which of the following is NOT a character data type?  (1) Points
   
    VARCHAR2
    BOOLEAN (*)
    CHAR
    LONG