Answer the following questions.
Question 1) What is Data base Model? Explain in brief the advantages of relational model.
Question 2) What do you mean by Data independence and its need? How it is achieved in the RDBMS?
Question 3) What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Question 4) Write down the different operations supported by Relational algebra.
Question 5) What do you mean by stored procedure? How it is different from query? Can you instantiate a COM object by using T-SQL?
Question 6)(a) Explain the terms: Attribute, Domain, Relation with the help of suitable example.
b) Distinguish between the following:
(i) Public and Private packages.
(ii) Recovery and Backup.
Question 7) What is Normalization and its need? Explain in brief the different steps used to normalize any data base.
Question 8) Write brief notes on the following:
(a) Oracle Server.
(b) Data base Security.