List at least 3 other database systems apart from Relational DBMS.

Write their purpose in 2-3 lines each.

OLAP databases are not necessarily in normalized form

What is a

Stored Procedure in DBMS? What advantages does it provide over a normal SQL query?

Query plan generation and optimization is an iterative process

Explain any 4 roles of a DBA   in one or two lines each

Explain the anomalies that could manifest in transaction processing with suitable example for each.

Explain any 4 reasons why you need Authorization in DBMS

Explain the concept of Transaction Processing in a DBMS 

- What is a transaction? Why do you need them?

- How does DBMS handle transactions?

- What is a Schedule ?

- What is 2-Phase Locking protocol

A Schema in 3NF means it is already in 2NF and there are no transitive dependencies

Role of a DBA ends when he/she sets up the database