problem 1) describe database system architecture in detail.

problem 2) prepare down the data anomalies in 1NF and 3NF.

problem 3) prepare down the advantages of normalized ER-Model.

problem 4) What are the various types of data constraints?

problem 5) Describe range searching and patterns searching.

problem 6) Distinguish between subquery and corelated query.

problem 7) describe how are indexed views created?

problem 8) What are the various control structures supported in PL/SQL?

problem 9) What are the various kinds of cursors available in PL/SQL?

problem 10) prepare suitable exs of

(a) Statement trigger.

(b) Before trigger.

problem 11) What do you mean by user defined data type? When do we require it?

problem 12) How can an administrator grant/revoke privileges?