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?

Leave a Reply

Your email address will not be published.

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