SQL ORACLE ACADEMY SECTION 1 (BENEFIT OF PL/SQL)

> SECTION1

1) When multiple SQL statements are combined into PL/SQL blocks, performance improves. True or False?
* TRUE

2) Procedural constructs give you better control of your SQL statements and their execution. True or False?

*TRUE

3) PL/SQL differs from C and Java in which of the following ways? (Choose two.)
     * It is the most efficient language to use with an Oracle database
     * It requires an Oracle database or tool

4) Which of the following can be compiled as a standalone program outside the database?
   * Programs developed in Java or C, but not in PL/SQL (*)

5) Which of the following can be done using PL/SQL? 
    *All of the above 

6) You can create a Web site application written entirely in PL/SQL. True or False? 
  *true   

Comments