20 Basic questions on DBMS for complete beginniners
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.
Question 5: What is a primary key?
Answer: A primary key is a column or combination of columns in a table that uniquely identifies each row in the table. It is used to enforce the integrity of the data and to enable efficient retrieval of specific rows in the table.
Question 6: The requirements of database can be captured using high level ……
Answer: Conceptual Design
Question 7: Database design is part of ……
Answer: System development
Question 8: Data becomes information when it is ……..
Answer: processed
Question 9: Which of the following is the first step in SDLC framework?
Answer: Requirement Gathering
Question 10: SDLC stands for …….
Answer: Software Development Life Cycle