20 Basic questions on DBMS for complete beginniners


Rahul S



Question 1: What is a database?

Answer: A database is a structured collection of data that is organized in a way that enables efficient storage, retrieval, and manipulation of the data.

Question 2: What is DBMS?

Answer: DBMS stands for Database Management System. It is software that is used to manage databases and provides a set of tools and functions for users to perform various operations on the data stored in the database.

Question 3: What is SQL?

Answer: SQL stands for Structured Query Language. It is a programming language that is used to manage and manipulate data stored in a database. SQL is used to perform operations like retrieving, inserting, updating, and deleting data from a database.

Question 4: What is normalization in database design?

Answer: Normalization is the process of organizing data in a database in such a way that data redundancy is minimized and data integrity is maximized. It involves dividing large tables into smaller tables and defining relationships between them to ensure that each piece of data is stored in only one place.