1) Mark the candidate keys in the relations of your choice.
2) What do you mean by functional dependency?
3) Write down the example of one-to-one relationship.
4) Write down the advantage of defining view?
5) Demonstrate an equi Join operation with suitable example.
6) Write down the two advantages of indexes.
7) Write down the general structure of PL/SQL procedure.
8) Write down two suitable examples of user internal exceptions.
9) What are sequences used for?
10) How is a trigger different from procedure?
11) Why do we use varying arrays?
12) Write down the difference between systems and object privileges.
13) What do you mean by a schema? Explain in detail.
14) How do we use implicit cursors?
15) What do you mean by a package?