RDBMS FUNDAMENTALS Interview Questions and Answers

Database Management System (DBMS) : DBMS is a software that interfaces between applications and a database for all data processing activities.


Users of a DBMS : End Users, Application Programmers and Database Administrators use a DBMS, either directly or indirectly. How users interact with a Database :

1. End users send queries to the DBMS through applications.

2. The DBMS translates the queries.

3. The DBMS retrieves data from the database.

4. The DBMS sends data to the application, which present the data to the end users.





Functions of a DBMS :

Function of DBMS Description Provided by using
Defining the data structure Defining structure of data to be stored in database Data Definition Language (DDL)
Manipulating Data Retrieving, adding, modifying, deleting data. Data Manipulation Language (DML)
Data Security Preventing unauthorized access to data. User-ids and Passwords.

Control of Data Access Allowing users to use only relevant data Data Control Language (DCL)



Please click here for more