Vinayaka Missions University 2008 B.E Information Technology data base management system bank - Question Paper

23. Illustrate dependency preservation with example?
24. Define Boyce-codd Normal form?
25. What is the 3rd Normal Form?

PART – B

1. Write a detailed note on basic structure of SQL.
2. Explain briefly about set operations with example.
3. Describe the Aggregate functions with examples?
4. Explain how modification can be done in the database?
5. Discuss briefly about the Joined relations in SQL?
6. Explain briefly about Data Definition languages?
7. Write a detailed note on security and integrity violations?
8. Discuss about Authorizations and granting of privileges?
9. Explain briefly about decomposition with example?
10. Describe the Boyce-codd Normal Form in detail with example?







UNIT – III

PART – A

1. What is flash memory?
2. Define optical storage?
3. What is meant by disk controller?
4. List the performance measures of disks?
5. Define RAID?
6. Write the 2 main goals of parallelism in a disk system?
7. Give the benefits of RAID level 3?
8. What are buffer-replacement policies?
9. Define byte-string representation?
10. List out the various ways of organizing records in the files?
11. Define data dictionary?
12. What are hash indices?
13. Write the kinds of ordered indices?
14. Give the structure of B+-Tree?
15. Define static hashing?
16. List out the reasons for bucket overflow?
17. What is meant by grid files?
18. Define query processing?
19. Write the steps involved in processing a query?
20. Illustrate an valuation plan with example?
21. How do you measure the query cost/
22. Define binary search?
23. What is meant by pipelining?
24. Illustrate materialization valuation with example?
25. State the equivalence rule?

PART – B

1. Describe briefly about physical storage media?
2. Write a detailed note on secondary storage devices?
3. Explain the various levels of RAID?
4. Discuss briefly about buffer manager?
5. Explain the fixed length records with example?
6. Write a detailed note on variable length records?
7. Explain the organization of records in files with example?
8. Explain briefly about primary index with example?
9. Discuss about B+-Tree index files?
10. Write a detailed note on query processing?








UNIT – IV

PART-A

1. What is meant by transaction?
2. List the ACID properties.
3. Draw the state diagram of a Transaction?
4. Define serializability?
5. What is meant by recoverability?
6. What is cascade less schedules?
7. Write the transaction definition in SQL?
8. Give the test for conflict serializability?
9. Define lock?
10. What is meant by granting of locks?
11. State two-phase locking protocol.
12. What is Graph-Based Protocol?
13. Define Timestamps?
14. List the timestamp-ordering protocol operation?
15. State the Thomas’ Write Rule?
16. Define Granularity?
17. What is deadlock handling?
18. How do you recover from deadlock?
19. List the kinds of failure?
20. Define stable storage?
21. What is log-based recovery?
22. What is deferred database modification?
23. Define checkpoints?
24. What is shadow paging?
25. Illustrate transaction rollback?

PART-B

1. Explain the concept of transaction in detail.
2. Illustrate the Transaction state with neat diagram and example.
3. Discuss briefly about concurrent executions.
4. Explain the serializability in detail with example?
5. Describe lock-based protocol in detail?
6. Explain the Two-Phase Locking Protocol in detail?
7. Discuss the Timestamp-based protocols with example?
8. Explain briefly about deadlock prevention?
9. Describe the deadlock detection with example?
10. Explain the shadow paging in detail?





UNIT-V

PART-A

1. What is Object-Oriented database?
2. Give a few applications of database?
3. Write the structure of object?
4. Define object classes?
5. What is meant by Inheritance? provide example.
6. What is object identity? Write the various forms of identity?
7. Define object containment with example?
8. How relations are stored in a distributed database?
9. Define data replication?
10. Give the advantages and disadvantages to replication?
11. What is data fragmentation?
12. Illustrate the vertical fragmentation with example?
13. Give the structure of XML?
14. Define Document kind Definition?
15. Define the terms XPath and XSLT?
16. Give a few XML application?
17. What is meant by data mining?
18. Give the association rule with example?
19. What are the applications of data mining?
20. State the Bayesian Classifier?
21. Define data warehousing?
22. Draw the architecture of Data Warehouse neatly?
23. State the characteristics of data warehouse?
24. What is regression with example?
25. List the functionality of data warehouse?


PART-B

1. Explain Object-Oriented data model in detail with example?
2. Describe the inheritance and multiple inheritances in detail?
3. Write a detailed note on Object-Oriented languages?
4. Discuss briefly about Data Fragmentation with example?
5. Illustrate the Distributed Query Processing in detail with example?
6. Explain briefly about the structure of XML data with example?
7. Describe the process of Data Mining with neat diagram?
8. Explain the applications of Data Mining in detail?
9. Describe the characteristics of Data warehousing?
10. Write a detailed note on Data Modeling in Data warehouse?

Earning:   Approval pending.