DBMS Interview Questions and Answers

DBMS Interview Questions and Answers

DBMS stands for Database Management system. It is system software for creating and managing databases system. It is manipulates the data itself, the data format, field names, record structure and file structure. It is mainly used for ability to store related data across multiple tables. Since there are so many database management systems available, it is important for there to be a way for them to communicate with each other.

Their main database organizations are:

Relational DBMS

Flat Database

Hierarchical Database

Object oriented Database

What is database?

What is DBMS?

What are main users of DBMS?

What are the advantages of DBMS?

What are the important components of DBMS?

What are the uses of DBMS?

How many types of database languages are?

What is DML (Data Manipulation Language)?

What is normalization?

What are the advantages of normalizing a database?

What is Denormalization?

Describe the levels of data abstraction?

What is RDBMS?

What is a database transaction?

Define the integrity rules?

What is Data Independence?

What is a view? How it is related to data independence?

What is extension and intension?

What is Data Warehousing?

What do you mean by Index hunting?

How does Index hunting help in improving query performance?

What is Data Model?

What is Object Oriented model?

Can you define Fragmentation.

What is Database partitioning?

What is the importance of partitioning?

What is Atomicity and Aggregation?

No Comments

Post a Reply