Dbms 2 imp Questions
DBMS 2 IMP questions (click on read more)
1. Relational Database Design
- What is a view ? Explain with example how views can be used or created.
- How triggers are declared and implemented. Explain with example.
- What is cursors and it's types ? How to declare it ? Explain with example.
- What is exception? How to handle error exception in postgresql
2. Transaction Concept
- Explain the State of Transaction with Diagram?
- State the properties of a transaction or list the ACID properties and explain the use.
- What is Schedule? And explain its type like complete, cascadless schedule.
- What is serializablity? Explain types with example like view & conflict serializablity?
3. Concurrency Control
- Explain the basic timestamp ordering method for concurrency Control.
- Explain deadlock handling methods . Deadlock detection and recovery?
- What are the different deadlock prevention algorithms ? Explain any one wound -wait.
- State the Thomas write rule?
- Define terms. Strict 2pl , rigorous 2pl, conservative 2pl , shared lock , lock,2pl, concurrency Control.
4. Crash Recovery
- Write a short note on buffer management?
- What is system crash. explain in detail.
- What are checkpoints ? How are they useful in crash Recovery with example.
- Explain different types of failure in detail.
- Write a short note on log based recovery? Explain techniques like immediate modification for log based recovery?
- Explain shadow paging ? State advantage and disadvantage of shadow paging.
5. Database Security
- Explain statistical database security with example.
- What is database security? Discuss encryption techniques for database security.
- Explain methods of database security.
6. Database System Architectures
- Discuss Benefits of client server system.
- Explain classification & types of client server architecture
- Explain parallel system. with parameters .
- Explain two- tire client server architecture. Also state advantage and disadvantage.
No comments:
Post a Comment