Section 2 Lesson 2: Recognizing PL/SQL Lexical Units

Recognizing PL/SQL Lexical Units

Section 1
   
  1.  What is a lexical unit?  (1) Points
   
    A data type for a column
    A building block of a PL/SQL block (*)
    A type of variable
   
  2.  What characters must enclose non-numeric literal values?  (1) Points
   
    Double quotes: " "
    Parentheses: ()
    Single quotes: ' ' (*)

  3.  The name of a variable is an example of an identifier. True or False?  (1) Points
   
    True (*)
    False
   
  4.  Which of the following symbols can be used to enclose a comment in PL/SQL?  (1) Points
   
    ? ?
    */ / *
    :: ::
    /* */ (*)
   
  5.  Which of the following are lexical units? (Choose two.) (1) Points (Choose all correct answers)
   
    Data types
    PL/SQL blocks
    Identifiers (*)
    Literals (*)
   
  6.  Which of the following is a valid naming convention for an identifier? (Choose two.)  (1) Points (Choose all correct answers)
   
    Can include letters or numbers (*)
    Cannot contain a reserved word (*)
    Can be over 30 characters
    Can start with a number or special character