Section 2 Lesson 3: Recognizing Data Types

Recognizing Data Types

 Section 1
 
  1.  Which of the folowing are scalar data types? (Choose three.)  (1) Points (Choose all correct answers)
   
    Array
    Character (*)
    Table
    Date (*)
    Boolean (*)

  2.  Which of the following is a composite data type? (1) Points
   
    CLOB
    VARCHAR2
    RECORD (*)
    DATE

 3.  What are the data types of the variables in the following declaration?
DECLARE
fname VARCHAR2(20);
fname VARCHAR2(15) DEFAULT 'fernandez';
BEGIN
...
(1) Points
   
    Scalar (*)
    Composite
    LOB
   
  4.  A datatype may specify a valid range of values. True or False?  (1) Points
   
    True (*)
    False
   
  5.  A Scalar data type holds a ____ value.  (1) Points
   
    Multi
    Large
    Single (*)
   
  6.  A datatype specifies and restricts the possible data values that can be assigned to a variable. True or False? (1) Points
   
    True (*)
    False

   
  7.  Which of the following are PL/SQL data types? (Choose three.)  (1) Points (Choose all correct answers)
   
    Large Objects (LOB) (*)
    Lexical
    Scalar (*)
    Delimiter
    Composite (*)