FB

PLSQL Chapter 6 Quiz

Welcome to your PLSQL Chapter 6 Quiz

1. 
What does %TYPE let you do?

2. 
What's one difference between Index By Table and Nested Table?

3. 
What's wrong with this code (assuming the emp_list exists and the employee table exists)?

FORALL i IN 1 .. emp_list.count LOOP
UPDATE employee
SET years = years + 1
WHERE emp_name = emp_list.emp_name;
END LOOP;

4. 
Why should you use BULK COLLECT?

1 thought on “PLSQL Chapter 6 Quiz”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.