DBA > Job Interview Questions > RDBMS FUNDAMENTALS Interview Questions and Answers

RDBMS FUNDAMENTALS - Database Management System

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

RDBMS FUNDAMENTALS - Database Management System (DBMS)

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)

(Continued on next question...)

Other Job Interview Questions