20 Basic questions on DBMS for complete beginniners
DATA BASE MANAGEMENT SYSTEM
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
Question 11: Which model can be selected if user is involved in all the phases of SDLC?
Answer: Prototyping Model & RAD Model
Question 12: SRS stands for ……
Answer: Software Requirements Specifications
Question 13: If multiple copies of the same data do not match with each other then it is called …….
Answer: Inconsistency of Data
Question 14: File System manages data using files in …..
Answer: Hard disk
Question 15: System feasibility in spiral model is determined in ….
Answer: Second loop
Question 16: In a many-to-many relationship, ______ occurrences in an entity relate to many occurrences in another entity.
Answer: many
Question 17: First circuit around spiral model represents a …….
Answer: Product development
Question 18: Change in conceptual schema should not affect …….
Answer: External schema
Question 19: This waterfall model, which was derived from the “hardware world”, views the software development from a manufacturing perception where items are produced once and __________________
Answer: reproduced never
Question 20: The rule that a value of a foreign key must appear as a value of some specific table is called a …….
Answer: Referential constraint
Do let us know if you need more questions….