Explain the term Serializability with the help of an example. Explain the two-phase locking protocol in the context of concurrent transactions. Also, explain the timestamp-based protocols for concurrent transactions.

Briefly explain the architecture of the Oracle Database Management System

Design a generalization /specialization hierarchy for a University Admission System. The University has many programmes, each programme has a specific duration. Registration into a programme requires students to register for many subjects of that Programme. The eligible students can take fresh admission or can re-register in the courses by paying the requisite fee.

Justify your placement of attributes at each level of the hierarchy. Convert the diagram into tables with integrity constraints for each table.

What is access control in the context of DBMS? What are the different access permissions that can be granted using SQL? Explain with the help of an example of each. Explain the concept of Statistical database security with the help of an example.

Explain the multi-valued dependency and Join-Dependency with the help of an example of each. Explain the 4th Normal Form and 5th Normal Form with the help of an example of each.

Explain the characteristics of a data warehouse. What are the components of a data warehouse? Explain. Also, explain the multi-dimensional data, star schema and snowflake schema in the context of a data warehouse with the help of an example. How is a data warehouse related to data mining?

Explain the transaction management and indexing in PostgreSQL.

Explain the following with the help of an example. 
(a) Stored Procedures and Triggers
(b) Embedded SQL