DBMS Tutorial – Database Management System

1. SQL | Tutorials
2. Quiz on SQL

DBMS practices questions :

1. Database Management Systems | Set 1
2. Database Management Systems | Set 2
3. Database Management Systems | Set 3
4. Database Management Systems | Set 4
5. Database Management Systems | Set 5
6. Database Management Systems | Set 6
7. Database Management Systems | Set 7
8. Database Management Systems | Set 8
9. Database Management Systems | Set 9
10. Database Management Systems | Set 10
11. Database Management Systems | Set 11

Advantages of DBMS

There are some following reasons to learn DBMS:

1. Organizing and management of data: DBMS helps in managing large amounts of data in an organized manner. It provides features like create, edit, delete, and read.
2. Data Security: DBMS provides Security to the data from the unauthorized person.
3. Improved decision-making: From stored data in the database we can generate graphs, reports, and many visualizations which helps in decision-making.
4. Consistency: In a traditional database model all things are manual or inconsistent, but DBMS enables to automation of the operations by queries.

FAQs on 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.

Quick Links :