CHAPTER 6 PL/SQL

A PL/SQL block can contain other blocks. True or False?
1. True
2. False
Relational systems cannot store behaviour. True or False?
1. True
2. False
Any SQL statement can be included in a PL/SQL program. True or False?
1. True
2. False
The select into statement in a PL/SQL block only returns one row of a table. True or False?
1. True
2. False
PL/SQL provides packages for when more than one row of a table is required to be returned. True or False?
1. True
2. False
To use a cursor the open, get and close statements are used. True or False?
1. True
2. False
Loops and branching in PL/SQL include three variations. Which one is not legal?
1. loop
2. do…while
3. for loop
4. while loop
Examine the PL/SQL function:

Which of the following statements is not true?
1. The function getCleanersDepot returns the value of the depot name to the function call
2. The function getCleanersDepot returns the value of the cleaner name to the function call
3. The key word in defines an input variable and its type (cname%type which is characters)
4. A function may be called from within another function or procedure
A trigger is associated with one or more tables. True or False?
1. True
2. False
VTriggers should only be used to supplement database integrity constraints. When enforcing standard entity integrity rules do not use triggers: instead use the FOREIGN KEY constraint in the CREATE TABLE statement. True or False?
1. True
2. False