DBMS Interview Questions - Part 1
What is Data ?
- Data refers to raw facts and figures that can be recorded
What is database?
- A database is a collection of information that is organized. So that it can easily be
accessed, managed, and updated.
What is DBMS?
- DBMS stands for Database Management System. It is a collection of programs that
enables user to create and maintain a database.
What is a Database system?
- The database and DBMS software together is called as Database system.
What are the advantages of DBMS?
- I. Redundancy is controlled.
- II. Providing multiple user interfaces.
- III. Providing backup and recovery
- IV. Unauthorized access is restricted.
- V. Enforcing integrity constraints.
What is normalization?
- It is a process of analyzing the given relation schemas based on their Functional
Dependencies (FDs) and primary key to achieve the properties
(1). Minimizing redundancy, (2). Minimizing insertion, deletion, and update anomalies.
Explain DBMS ?
- DBMS stands for Database Management System. It is a software
package designed to define, manipulate, retrieve and manage data in
database.
Why DBMS ?
- To make information easy to access and protected, we use database
management systems. DBMS is important because it manages the data
efficiently and allows users to perform multiple tasks on it with the ease.
- MySQL, Oracle, SQL Server, Amazon simple DB (Cloud-based), etc
-------------- Next Ques Will be in Next Part ------------------
