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