Home Interview Questions and AnswersTechnical Interview Questions and AnswersDBMS DBMS Technical Interview Questions and Answers For Graduates Part-1

dbms-image1. What is database?

A database is a collection of information that is organized. So that it can easily be accessed, managed, and updated.

 2. What is DBMS?

DBMS stands for Database Management System. It is a collection of programs that enables user to create and maintain a database.

3. What is a Database system?

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

4.   What are the advantages of DBMS?

I.  Redundancy is controlled.

II.  Providing multiple user interfaces.

III. Providing backup and recovery

IV. Unauthorized access is restricted.

V.  Enforcing integrity constraints.

5. What is normalization?

It is a process of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the properties
(1).Minimizing redundancy, (2). Minimizing insertion, deletion and update anomalies.

6. What is Data Model?
A collection of conceptual tools for describing data, data relationships data semantics and constraints.

7. What is E-R model?

This data model is based on real world that consists of basic objects  called entities and of relationship among these objects. Entities are described in a database by a set of attributes.

8. What is Object Oriented model?

This model is based on collection of objects. An object contains values stored in instance variables with in the object. An object also contains bodies of code that operate on the object. These bodies of code are called methods. Objects that contain same types of values and the same methods are grouped together into classes.

9. What is an Entity?
An entity is a thing or object of importance about which data must be captured.

10. What is DDL (Data Definition Language)?

A data base schema is specifies by a set of definitions expressed by a special language called DDL.

You may also like

Leave a Comment