Mode Of Examination
Number Of Question: 100 (1 Marks Each)
Total Time: 120 Min
The Relational Model:
Dealing with the concept of Relational Model. These include relational and database schema, keys and relational query operators.
SQL : Queries, Constraints and Triggers:
SQL basics, set and null value operations, database modifications, views and transactions, different types of integrity constraints, joins, nested subqueries and aggregate functions, schemas and data types, triggers, functions and procedures and different queries and aggregation features.
Different concepts of relational algebra. These include domain and tuple relational calculus.
Database Systems Design and Implementation:
E-R model, E-R design, constraints, atomic domains and querying databases like DDL and DML.
Different normal forms, multivalued dependencies and decomposition algorithms, user interfaces and different application programs.
Database Programming Techniques:
Fundamentals of web programming, JSP and servlets, application performance and security, application encryption and architecture.
Storage and File Structures:
Different storage structures like physical, flash, tertiary, data-dictionary and file structures like RAID, file record organisation and database buffers.
Indexing and Hashing:
Index definition, bitmap and ordered indices and various hashing techniques.
Query Processing Techniques:
Query processing and optimization techniques, selection, sort and join operations, relational expressions and materialized views.
Transaction, storage structures, properties of transaction like atomicity, durability, isolation and their implementations and different querying databases.
Deadlocks, lock based protocols, granularity, types of reads like insertion, deletion and predicate and the concept of concurrency in index structures.
Classification of failures, backup systems, buffer management and recovery and different lock releases.