Question 1) Explain database system architecture in detail.
Question 2) Write down the data anomalies in 1NF and 3NF.
Question 3) Write down the advantages of normalized ER-Model.
Question 4) What are the various types of data constraints?
Question 5) Describe range searching and patterns searching.
Question 6) Distinguish between subquery and corelated query.
Question 7) Explain how are indexed views created?
Question 8) What are the various control structures supported in PL/SQL?
Question 9) What are the various kinds of cursors available in PL/SQL?
Question 10) Write suitable examples of
(a) Statement trigger.
(b) Before trigger.
Question 11) What do you mean by user defined data type? When do we require it?
Question 12) How can an administrator grant/revoke privileges?