Introduction

Question 1

What is RDBMS?

Answer 1

RDBMS: Relational Database Management System

We use RDBMS to make changes to database that store information in the form of tables.

Question 2

Give examples of RDBMS.

Answer 2

MySQL, SQL Server, Oracle

Question 3

What is ACID?

Answer 3

ACID - Atomicity, Consistency, Integrity, Durability
Atomicity: The property by which the transaction either completes or fails in entirety.
Consistency: The property by which the database is consistent before and after a transaction.
Isolation: Multiple transaction can take place simultaneously.
Durability: The changes made to the database are saved, even if the system fails.

Question 4

What are the types of command in MySQL?

Answer 4

Types of commands:

1. DML (Data Manipulation Language)
2. DDL (Data Definition Language)
3. DCL (Data Control Language)

Question 5

What’s DDL?

Answer 5

DDL commands are used to deal with the structure of tables/database objects.
Ex - CREATE, ALTER

Question 6

What’s DML?

Answer 6

DML are used to change the information stored inside tables.

Ex - INSERT, UPDATE

Question 7

What’s DCL?

Answer 7

DCL are used to control the access to the database.

Ex - GRANT, REVOKE