DBMS mid Sem -2 Syllabus

Transaction Management :
 
         Transaction concepts

         properties of transactions

         serializability of transactions

         testing for serializability

         System recovery

         Two- Phase Commit protocol

         Recovery and Atomicity

         Log-based recovery

         concurrent executions of transactions and related problems, Locking mechanism

         solution to concurrency related problems, deadlock

         two-phase locking protocol

         Isolation

         Intent locking
   
Security:

 
        Introduction

        Discretionary access control

        Mandatory Access Control

        Data Encryption

SQL Concepts:
      
     structure – creation, alteration


       defining constraints – Primary key, foreign key, unique, not null, check, IN  operator

       aggregate functions

       Built-in functions* –numeric, date, string functions, set operations, sub-queries, 

       

       correlated 

       sub-queries

       Join

        view and its types.

*Explanation Requires




Download In PDF