Name:__________________________________________
CP207 - Quiz5

1- What does PL stand for and why is it good to use PL/SQL together?

2- What are sequences and give an example of sequence?

3- What are the two types of integrity constraints? (what does each one constraint?)

4- Write SQL to create a Phone table that has a phone number, a person id to whom it belongs, and the type of phone (fax, mobile, home, office, etc.)

5- What subset of SQL do we use to define the database schema?

6- List at least three SQL statements which cannot be rolled back.

7- What is the output for this loop?

DECLARE
    I NUMBER(6);
BEGIN
    I := 1;
    LOOP
        DBMS_OUTPUT.PUT_LINE('aI: ' || I);

        I := I + 1;
        IF I > 5 THEN
            EXIT;
        END IF;

        DBMS_OUTPUT.PUT_LINE('bI: ' || I);
    END LOOP;
END;

8- What is a procedure? Create a procedure that prints out "This is the Final Test" call this procedure and then drop the procedure.

9- Create a PL/SQL block trigger that contains an if statement inside.

10- Write an exception that handles a division by zero.