- New
- -10%


Unlock a world of knowledge with Vision Publications—where every page brings you closer to your educational goals!
Unlock a world of knowledge with Vision Publications—where every page brings you closer to your educational goals!
As per NEP w.e.f. 2024-25
Author: Gautam A. Kudale, Mahesh D. Pawar
ISBN: 978-93-94022-76-8
Book ID: 2136
Contents
1. Introduction to RDBMS and PL-SQL
1. Introduction
2. Introduction to Popular RDBMS Product and their Features
2.1 Difference between DBMS and RDBMS
2.2 Advantages and Disadvantages of RDBMS
3. Overview of PL/SQL
3.1 Data Types
3.2 PL/SQL Block
4. Operators, Functions, Comparison, Numeric, Character, Date
5. Control Statement
5.1 Conditional Control
5.2 Iterative Control
5.3 Sequential Control
6. Exceptional Handling
7. Functions, Procedures
8. Cursor
8.1 What is a Cursor?
8.2 Types of Cursors
8.3 Cursor Declaration
8.4 Cursor For Loops
8.5 Parameterized Cursors
9. Database Triggers
9.1 Types of Triggers
10. Oracle Packages
10.1 Components of an Oracle package
2. Transaction Management
1. Transaction Concept
1.1 Transaction Properties
1.2 Transaction States
2. Concurrent Execution
3. Schedule
4. Serializability
4.1 Conflict Serializability
4.2 Testing for Conflict Serializability
3. Concurrency Control and Recovery System
1. Concurrency Control
2. Lock Based Protocols
2.1 Locks
2.2 Granting of Locks
2.3 Two-Phase Locking Protocol
3. Timestamp-Based Protocols
3.1 Timestamp
3.2 Timestamp-Ordering Protocol
3.3 Thomas Write Rule
4. Validation-Based Protocols
5. Deadlock Handling
5.1 Deadlock Prevention
5.2 Deadlock Detection
5.3 Deadlock Recovery
6. Recovery System
7. Failure Classification
7.1 Transaction Failure
7.2 System Crash
7.3 Disk Failure
8. Storage Structure
8.1 Storage Types
8.2 Data Access
9. Recovery and Atomicity
9.1 Log-Based Recovery
9.2 Deferred Database Modification
9.3 Immediate Database Modification
9.4 Checkpoints
10. Recovery with Concurrent Transactions
10.1 Interaction with Concurrency Control
10.2 Transaction Rollback
10.3 Restart Recovery
11. Remote Backup Systems
No customer reviews for the moment.