✅ Questions
Select a question from the left to see its answer.
All answers are based on the provided course modules.
What is a DBMS, its applications, file systems vs. DBMS, database architecture, users, and the role of the DBA.
E-R model components (Entity, Relationship, Attribute), constraints, weak entities, and extended E-R features.
DDL, DML, DCL, TCL commands. Creating tables, defining constraints, manipulating data, functions, joins, and subqueries.
Structure of relational databases, relational algebra, operators (selection, projection, join), and aggregate functions.
Functional Dependency (FD), Armstrong's axioms, normalization, and normal forms (1NF, 2NF, 3NF, BCNF).
Transactions, ACID properties, schedules, serializability, concurrency, deadlock, and recovery protocols.
PL/SQL block structure, datatypes, exception handling, cursors, stored procedures, functions, and triggers.