Answer the following problems.
problem 1) What is database trigger? Describe the need and the usage of trigger?
problem 2) Describe client server systems?
problem 3) What are the Database system Architectures?
problem 4) describe briefly about DDL, DML and DCL?
problem 5) What do you mean by Cross join? Give an ex?
problem 6) prepare a brief note on Shadow Paging?
problem 7) What are the features and benefits of SQL?
problem 8) Describe the three sections of PL/SQL Block?
problem 9) Describe the types of record based models?
problem 10) Describe the types of file organization?
problem 11) What do you mean by the term normalization? Describe 1st, 2nd and 3rd normal forms?
problem 12) What is deadlock? What are the FOUR necessary conditions for a deadlock occurrence? How deadlock can be prevented?
problem 13) Describe the Database system Architectures?
problem 14) Describe data modification in SQL with proper ex.
problem 15) Briefly describe what are the three levels of data abstraction? Describe about the two types of Data Independence?