Advanced Database Management Systems
June 2018
Q1 What are Cursors,Stored Procedures and Triggers? Explain each with the help of an example code.
Q2 Differentiate between Logical and Physical Database design.
Q3 What is a View? Explain any two strategies for implementing the Views.
Q4 What is Hash join? How is Hash join between two relations computed? Explain the algorithm and cost calculation for simple hash join.
Q5 Differentiate between a database management system and a data warehouse.What is need for a data warehouse?
Q6 What is granularity of data ? How does granularity of data items affect the performance of concurrency control?
Q7 Differentiate between Centralized DBMS and Distributed DBMS.
Q8 What is Timestamp Ordering? Explain timestamp based protocol for serializable schedule.
Q9 What is Data Mining? How does Data Mining differ from OLTP? Discuss Classification as a technique for data Mining.
Q10 What are Data Marts? Briefly discuss the significance of data marts.
Q11 What is XML? How does XML differ from HTML? What are the advantages of XML? Create an XML schema for a list of students and their marks.
Q12 Differentiate between Two-phase commit protocol and Three-phase commit protocol in distributed databases. "The three-phase commit protocol increases the system's availability and does not allow transactions to remain blocked until a failure is repaired" Justify the statement.
Q13 What are Semantic Databases? List the features of semantic databases. Explain the process of searching the knowledge in semantic databases.
Q14 What is a Data Dictionary? List some features of a data dictionary. What are various approaches to implement a Distributed Database Catalogue?
Q15 What is Shadow Paging? Illustrate with an example. Give the advantages and disadvantages of shadow paging.
Q16 Define Multi-valued Dependency. What is Trivial Multi-valued Dependency? State the Fourth normal form.
Q17 Explain any one clustering technique for data mining.
Q18 What is Query Optimization? Briefly discuss the techniques of Query Optimization with suitable examples.
Q19 Explain the following
i) Temporal Databases
ii) Dynamic SQL
iii) OLAP
iv) Spatial Databases
Q20 Explain the process of Query optimization with suitable example.
Q21 What is the difference between Document Type Definition (DTD) and XML Schema ? Explain using an example.
Q22 Explain Data mining in the context of knowledge discovery in databases.
Q23 What is Join dependency ? Explain it with the help of an example. What is trivial join dependency?
Q24 Consider a small institute in which students register for programmes run by the
institute. A programme can be a full or part time programme or both. Every student
necessarily registers in at least one programme and at most three programmes,
Assuming suitable attributes, design an EER Diagram for the same.
Q25 Explain the reference architecture for distributed database management systems.
Q26 What are triggers ? Explain the utility of triggers in DBMS. Give suitable SQL code for triggers.
Q27 What is a System catalogue ? What is the information stored in catalogue of RDBMS ?
Q28 Compare and contrast the following :
(i) JDBC and ODBC
(ii) B-Tree Indexes and R-Tree Indexes used in PostgreSQL.
Q29 What is multiversion two-phase locking ? Explain with an example.
Q30 What are the different type of security features, needed for a multilevel security system ? Explain the encryption technique for a multilevel security system.
Q31 Describe the following with suitable example or a diagram :
(i) Data Grid
(ii) Data Mart
(iii) Deadlock
(iv) Checkpoint
(v) Referential Integrity Constraint
Q32 What are views ? What is their significance in DBMS ? How are views created in SQL ? Explain it with the help of an SQL statement.
Q33 Differentiate between the following
(i) Centralized and Distributed Databases
(ii) Clustering and Classification approaches in Data Mining
(iii) Star Schema and Snowflake Schema
Q34 What are deadlocks ? How are deadlocks detected ? Explain with the help of an example.
Q35 What is semi-structured data ? Explain with the help of an example. What is the difference between a well formed XML document and a valid XML document ?
Q36 What is data warehousing ? Discuss various characteristics of data warehousing ?
Q37 What are multimedia databases ? Discuss the challenges of designing multimedia databases.
Q38 What is multi-valued dependency ? State the fourth normal form.
Q21 What is the difference between Document Type Definition (DTD) and XML Schema ? Explain using an example.
Q22 Explain Data mining in the context of knowledge discovery in databases.
Q23 What is Join dependency ? Explain it with the help of an example. What is trivial join dependency?
Q24 Consider a small institute in which students register for programmes run by the
institute. A programme can be a full or part time programme or both. Every student
necessarily registers in at least one programme and at most three programmes,
Assuming suitable attributes, design an EER Diagram for the same.
Q25 Explain the reference architecture for distributed database management systems.
Q26 What are triggers ? Explain the utility of triggers in DBMS. Give suitable SQL code for triggers.
Q27 What is a System catalogue ? What is the information stored in catalogue of RDBMS ?
Q28 Compare and contrast the following :
(i) JDBC and ODBC
(ii) B-Tree Indexes and R-Tree Indexes used in PostgreSQL.
Q29 What is multiversion two-phase locking ? Explain with an example.
Q30 What are the different type of security features, needed for a multilevel security system ? Explain the encryption technique for a multilevel security system.
Q31 Describe the following with suitable example or a diagram :
(i) Data Grid
(ii) Data Mart
(iii) Deadlock
(iv) Checkpoint
(v) Referential Integrity Constraint
Q32 What are views ? What is their significance in DBMS ? How are views created in SQL ? Explain it with the help of an SQL statement.
Q33 Differentiate between the following
(i) Centralized and Distributed Databases
(ii) Clustering and Classification approaches in Data Mining
(iii) Star Schema and Snowflake Schema
Q34 What are deadlocks ? How are deadlocks detected ? Explain with the help of an example.
Q35 What is semi-structured data ? Explain with the help of an example. What is the difference between a well formed XML document and a valid XML document ?
Q36 What is data warehousing ? Discuss various characteristics of data warehousing ?
Q37 What are multimedia databases ? Discuss the challenges of designing multimedia databases.
Q38 What is multi-valued dependency ? State the fourth normal form.
No comments:
Post a Comment