Home |
Write |
179 members |

Join with Aptibook

RDBMS interview questions and answers - Page 1

1. What is a database ?

A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.

2. What is DBMS ?

DBMS consists of collection of interrelated files and programs.
It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.

Primary Goal is to provide a suitable and efficient way for storage, retrieval and modification of information

Services by DBMS:
Data management
Data definition
Transaction support
Concurrency control
Security and integrity

3. What is a Database system?

The database and DBMS software together is called as Database system.

4. Advantages of DBMS?

1. Redundancy is controlled.
 2. Unauthorised access is restricted.
 3. Providing multiple user interfaces.
 4. Enforcing integrity constraints.
 5. Providing backup and recovery.

5. Disadvantage in File Processing System?

1. Data redundancy & inconsistency.
 2. Difficult in accessing data.
 3. Data isolation.
 4. Data integrity.
 5. Concurrent access is not possible.
 6. Security Problems.