Advanced DBMS

(b) Explain how complex data types are handled in SQL?

(c) Data definition language and Data manipulation language.

Differentiate between the following:

(d) A type x and a reference type ref(x). Under what circumstances would you choose to use a reference type? 

Differentiate between the following:

(c) Structured types and inheritance in SQL.

Differentiate between the following:

b) Current database and temporal database.

Differentiate between the following:

(a) Procedures and functions in PL/SQL.

(b) What is SOAP Web Service? What is the use of SOAP envelope?

(a) What is XQuery? What is XPath? 

(b) Briefly explain database management features supported by IBM DB2.

(a) How transactions are managed in PostgreSQL?

(a) Draw and describe architecture of distributed DBMS.

(a) Define the requirements of mobile databases. Discuss the basic issues relating to mobile databases.

(b) Explain real time transaction systems.

(a) What are transaction processing monitors? Explain their architecture.

(b) What are equivalence rules and equivalent expression? State with an example.

(a) Why query optimization is needed in DBMs? Write steps of query optimization.

(b) List different types of cursor. Write syntax of creation of cursor in PL/SQL.  

(a) Explain the difference between programming SQL, embedded SQL and dynamic SQL? 

(b) Explain why advanced database techniques are needed? List the impact of emerging database standards.