Section 1 Lesson 2: Benefits of PL/SQL

Section 1
   
  1.  When multiple SQL statements are combined into PL/SQL blocks, performance improves. True or False? (1) Points
    True (*)
    False
   
  2.  Procedural constructs give you better control of your SQL statements and their execution. True or False?  (1) Points
   True (*)
   False
   
  3.  PL/SQL differs from C and Java in which of the following ways? (Choose two.)  (1) Points (Choose all correct answers)
    It requires an Oracle database or tool. (*)
    It does not support object-oriented programming.
    It is the most efficient language to use with an Oracle database. (*)
    It is the most complex programming language to learn.
    It is not portable to other operating systems.

 4.  Which of the following can be compiled as a standalone program outside the database?  (1) Points
    A program developed in PL/SQL
    A program developed in Java
    A program developed in C
    All the above
    Programs developed in Java or C, but not in PL/SQL. (*)
     
  5.  Which of the following can be done using PL/SQL?  (1) Points
    Create complex applications.
    Retrieve and modify data in Oracle database tables.
    Manage database tasks such as security.
    Create custom reports.
    All of the above (*)
   
  6.  You can create a Web site application written entirely in PL/SQL. True or False?  (1) Points
   True (*)
   False