Database Management Systems (DBMS)

Question 1

DBMS

Answer 1

computer software that allows users to interact with databases (e.g. MySQL)

Question 2

Components of DBMS and SQL:

Answer 2

Application programs communicate with a relational DBMS using Structured Query Language (SQL) which is a special programming language designed to perform DBMS tasks. Application programs send data retrieval, data insert, or data changes requests to DBMS as SQL statements.

Question 3

SQL statements: DDL, DML, DCL, TCL
Data Definition Language (DDL): statements used for defining, organizing, and changing data structure in DBMS.

Answer 3

CREATE to define database objects, DROP to delete them, ALTER to modify them
Output of DDL statements is metadata (defines meaning and format of data stored in physical storage medium (hard drive))

Question 4

Data Manipulation Language (DML):

Answer 4

statements used for selecting, inserting, deleting, and updating data in a database

Question 5

Data Control Language (DCL):

Answer 5

statements used for controlling the access to the data

Question 6

Transaction Control Language (TCL):

Answer 6

statements used to manage the changes made by DML statements. They group DML statements together into logical transitions

Question 7

A database is a collection of programs that stores, manages, and uses data

False
True

Answer 7

False

Question 8

A DBMS can host multiple databases

True
False

Answer 8

True

Question 9

The REVOKE statement is used to remove user access rights or privileges to the database objects. REVOKE is an example of:

Answer 9

DCL

Question 10

The SQL ROLLBACK statement rolls back the current translation, canceling its changes. SQL ROLLBACK is an example of:

Answer 10

TCL

Question 11

A typical DBMS has many functions such as:

Answer 11

Creating databases
Data storage
Documenting the data organization
Defining data integrity and data validation rules
Creating user accounts
Providing access to databases
Data security and database administration
Database backup and recovery option