Database Management System(DBMS)
Q.1 What is Database?
Answer:
A database is a collection of organized data which can easily be created, updated, accessed, and managed. Records are kept maintained in tables or objects. A tuple (row) represents a single entry in a table. DBMS manipulates data from the database in the form of queries given by the user.
Q.2 What are different languages present in DBMS?
Answer:
- DDL (Data Definition Language): These are the collection of commands which are required to define the database.
E.g., CREATE, ALTER, RENAME, TRUNCATE, DROP, etc.- DML (Data Manipulation Language): These are the collection of commands which are required to manipulate the data stored in a database.
E.g., SELECT, UPDATE, INSERT, DELETE, etc.- DCL (Data Control Language): These are the collection of commands which are dealt with the user permissions and controls of the database system.
E.g, GRANT, and REVOKE.- TCL (Transaction Control Language): These are the collection of commands which are required to deal with the transaction of the database.
E.g., COMMIT, ROLLBACK, and SAVEPOINT.
Q.3 What are the ACID properties in DBMS?
Answer:
The full form of ACID is Atomicity, Consistency, Isolation, and Durability these are the properties of DBMS that ensure a safe and secure way of sharing data among multiple users.
A – Atomic: All changes to the data must be performed successfully or not at all.
C – Consistent: Data must be in a consistent state before and after the transaction.
I – Isolated: No other process can change the data while the transaction is going on.
D – Durable: The changes made by a transaction must persist.
Q.4 What are the Advantages of DBMS?
Answer:
The followings are the few advantages of DBMS :
- Data Sharing: Data from the same database can be shared by multiple users at the same time.
- Integrity: It allows the data stored in an organized and refined manner.
- Data Independence: It allows changing the data structure without changing the composition of executing programs.
- Data Security: DBMS comes with the tools to make the storage and transfer of databases secure and reliable. Authentication and encryption are the tools used in DBMS for data security.
DBMS Tutorial – Database Management System
Database Management System is a software or technology used to manage data from a database. Some popular databases are MySQL, Oracle, MongoDB, etc. DBMS provides many operations e.g. creating a database, Storing in the database, updating an existing database, delete from the database. DBMS is a system that enables you to store, modify and retrieve data in an organized way. It also provides security to the database.
In this Database Management System tutorial you’ll learn basic to advanced topics like ER model, Relational Model, Relation Algebra, Normalization, File Organization, etc.
Table of Content
- Introduction
- Entity Relationship Model
- Relational Model
- Relational Algebra
- Functional Dependencies
- Normalisation
- Transactions and Concurrency Control
- Indexing, B and B+ trees
- File Organization
- Advanced Topics
- SQL Tutorial
- Advantages of DBMS
- Quick Links
Introduction :
- DBMS Introduction | Set 1
- DBMS Introduction | Set 2 (3-Tier Architecture)
- DBMS Architecture 2-level 3-level
- Need For DBMS
- Data Abstraction and Data Independence
- Database Objects
- Multimedia Database
- Interfaces
- Categories of End Users
- Use of DBMS in System Software
- Choice of DBMS | Economic factors
- Disadvantages of DBMS
Contact Us