Relational Database Management System MCQ
|
1. Relational Database Design |
1. Relational Database Design
1. Preliminaries
Functional Dependencies Basic concepts : Closure of a set of functional dependencies, Closure of attribute set, Canonical cover, Decomposition. 2. PL/PgSqL: Datatypes, Language structure
3. Controlling the program flow, conditional statements, loops
4. Views
5. Stored Functions, Stored Procedures
6. Handling errors and exceptions
7. Cursors
8. Triggers
|
MCQ Link1 MCQ Link2 MCQ Link3 MCQ Link4 |
|---|---|---|
|
2. Transaction Concepts and concurrency control |
2. Transaction Concepts and concurrency control 1. Describe a transaction, properties of transaction, state of the transaction.
2. Executing transactions concurrently associated problem in concurrent
execution.
3. Schedules, types of schedules, concept of Serializability,
precedencegraph for Serializability.
4. Ensuring Serializability by locks, different lock modes, 2PL and its
variations.
5. Basic timestamp method for concurrency, Thomas Write Rule.
6. Locks with multiple granularity, dynamic database concurrency
(Phantom Problem).
7. Timestamps versus locking.
8. Deadlock handling methods
Detection and Recovery (Wait for graph). Prevention algorithms (Wound-wait, Wait-die) |
MCQ Link2 |
|
3. Database Integrity and Security Concepts |
3. Database Integrity and Security Concepts
1. Domain constraints
2. Referential Integrity
3. Introduction to database security concepts
4. Methods for database security
i)Discretionary access control method ii)Mandatory access control and role base access control for multilevel security.
5. Use of views in security enforcement.
6. Overview of encryption technique for security.
7. Statistical database security.
|
MCQ Link1 |
|
4. Crash Recovery |
4. Crash Recovery
1. Failure classification
2. Recovery concepts
3. Log base recovery techniques (Deferred and Immediate update)
4. Checkpoints
5. Recovery with concurrent transactions (Rollback, checkpoints, commit)
6. Database backup and recovery from catastrophic failure.
|
MCQ Link1 |
|
5. Crash Recovery |
5. Client-Server Technology
1. Describe client-server computing.
2. Evolution of Client - Server information systems.
3. Client – Server Architecture benefits.
4. Client Server Architecture
Components, Principles, Client Components Communication middleware components Database middleware components Client Server Databases |
MCQ Link1 |
