12:09
vishal pandya
Most Important Question List for DBMS-II.
1) | What is Transaction? Explain Transaction property in detail? |
2) | Discuss transition execution state with state transition diagram and related problem? |
OR | |
2) | Transaction Execution and problems? |
3) | What is Concurrency Control? Explain different problem of Concurrency control with and example? |
4) | What is Serializability? Explain View serializability in detail? |
5) | What is locking? What are the Different types of Lock? Explain different level of locking? How does Locking Protocol work? |
6) | Explain Two Phase Locking? Strict Two Phase Locking? |
7) | What is Timestamp Ordering protocol? Explain with types and working? |
8) | How does validation based concurrency technique work? (Optimistic Technique) |
9) | Explain the following terms : Lock Point, Starvation, Cascading Rollback |
10) | What is Deadlock? Explain deadlock prevention technique with an Example? |
11) | What is Log Based Recovery? Explain all Log based Recovery technique with Example? |
OR | |
11) | Deferred Update, Immediate Update and Checkpoint |
12) | Describe Shadow Paging Recovery Technique? Under what circumstances does it not require a transaction log? List advantages and disadvantage of shadow paging? |
13) | Explain Roll forward and Roll Backward of Recovery? |
OR | |
13) | Explain types of Recovery? |
14) | What is Security? Explain Goals of Database Security? |
OR | |
14) | What is Security? Explain the different threats of database security? List the types of Security Issues. Authorization and Authentication? |
15) | Explain Granting and Revoking with Syntax and example? |
OR | |
15) | Explain Discretionary Access Control in detail? |
16) | Explain Defense mechanism in Database Security? |
OR | |
16) | Discretionary Access Control,Mandatory Access Control Firewall, Data Encryption |
17) | Explain SELECTION, PROJECTION, NATURAL JOIN, DIVISION operators of Relational Algebra? |
18) | What is query processing? What are its objectives? Explain with neat sketch diagram? |
19) | Explain the query decomposer with different phases in detail? |
20) | Describe the query optimization with block diagram? |
21) | Explain how heuristic query optimization is performed with an example? |
22) | Explain heuristic query optimization algorithm? |
23) | Describe the Transformation rules for query optimizer? |
OR | |
23) | Explain Equivalence expression of query optimizer? |
24) | What are basic query optimization strategies? List out the different technique for SELECT and JOIN. |
OR | |
24) | Explain Cost based Optimization in detail? |
25) | Explain Advantage, Disadvantage and Key element of Parallel Database? |
26) | Explain Architecture of parallel Database with advantage and disadvantage? |
27) | What is Distributed DBMS? Explain Types of Distributed Database? |
28) | Explain Architecture of Distributed Database System? |
29) | Explain Two Phase commit? |
30) | Explain features, Advantage and Disadvantage of OODBMS? |
31) | Difference between Parallel Database System and Distributed DBMS. |
32) | Explain Transaction Control Language? |
OR | |
32) | Explain Commit, Rollback and Savepoint? |
33) | Explain Importance of Backup? Explain Types of Backup? |
34) | List the types of Database Failure in Detail? |
35) | Explain Buffer Management technique in detail? |
0 comments:
Post a Comment