Unit – I
- What are the limitations of File System.
- What is Data base? What are the functions of DBMS
- Explain about the advantages of DBMS.
- Explain about the components of DBMS.
- Explain about the Roll of DBA.
- Explain about various Data Models
- What is key? Explain about different types of Keys in DBMS.
- Explain about the data types in DBMS.
- Explain about the Integrity constraints in DBMS.
- What is ER – Model explain in detail.
- Explain about super type and sub type relationships.
Unit – II
- Define Normalization and types of Normal Forms.
- What is redundancy? What are the problems with redundancy.
- Explain about 1NF, 2NF, 3NF and BCNF normal forms in detail.
- What is file organization?
- Explain about the multi key file organization.
Unit – III
- What is SQL and explain about the features of SQL.
- Explain about DDL, DML, DCL commands.
- Explain about Orderby, group-by, Having and where clause in SQL.
- Explain about the nested query.
- Explain about Joins in SQL.
- Explain about the sequences in SQL.
- Explain about how to drop a table?
Unit – IV
- Define Database security and lock, explain types of locks.
- Explain about ACID properties.
- Explain about Two – Phase locking protocol.
- Explain about dead lock and its prevention.
- What is data base recovery and recovery techniques?
- Explain about database security authorization.
Unit – V
- What is the need of Distributed DataBase?
- Explain about the features of Distributed DataBase.
- Explain about Distributed Database System design.
- What is data replication explain in detail.
- Explain about client server architecture.
- Differentiate between Distributed Database and Client server architecture.
- Explain about Two – Tier and Three – Tier client server architecture.