A Relation Database Management system (RDBMS) is a database management system that is based on the relational model. All modern database management systems like SQL, MS SQL Server, IBM DB2, ORACLE, My-SQL and Microsoft Access are based on RDBMS.
Mode Of Examination
Number Of Question: 100 (1 Marks Each)
Total Time: 120 Min
Introduction to Relational Model and Sql:
Relational model basics, sql data definition, basic and set operations, aggregrate functions, nested subqueries and database modifications.
Intermediate and Advanced Sql:
Join expressions, views and transactions, integrity constraints, sql data types, olap and relational algebra.
Database Design and The ER Model:
Entity relationship model and diagrams, relational schema and e-r features.
Relational Database Design:
Relational design features, functional dependency theory and decomposition, decomposition algorithms and normal forms.
Application Design and Development:
Web fundamentals, servlets and jsp, application architectures and security.
Storage and File Structure:
Magnetic disk, raid, file and record organization.
Indexing and Hashing:
Ordered indices, b+ trees, bitmap indices, static and dynamic hashing.
Query Processing and Optimization:
Query processing, join operations, expressions evaluation, relational expressions, evaluation plans and materialized views./p>
Transaction concept, serializability, transaction isolation and its levels.
Lock and timestamp based protocols, deadlock handling, multiversion schemes, validation based protocols, insert and delete operations.
Failure classification and storage, recovery and atomicity.
Sql data definition and sql queries.