Comprehensive Notes on Java, OOPS, and DBMS for BCA Students

DBMS Interview Questions

Theory Based DBMS Interview Questions



Ques: What is database?

Ans: A information may be a logically coherent assortment of information with some
inherent that means, representing some facet of globe and that is meant, designed and
inhabited with information for a selected purpose.

Ques: What is DBMS?

Ans: It is a set of programs that permits user to form and maintain a info. In alternative
words its general computer code that has the users with the processes of shaping,
constructing and manipulating the info for numerous applications.

Ques: What is a Database system?

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

Ques: What are the advantages of DBMS?

Ans:

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

Ques: What are the disadvantages in File Processing System?

Ans:

 Data redundancy and inconsistency.
 Difficult in accessing data.
 Data isolation.
 Data integrity.
 Concurrent access is not possible.
 Security Problems.

Ques: Describe the three levels of data abstraction?

Ans: There are three levels of abstraction:

1. Physical level: The lowest level of abstraction describes how data are stored.
2. Logical level: The next higher level of abstraction, describes what data are stored in
database and what relationship among those data.
3. View level: The highest level of abstraction describes only part of entire database.

Ques: Define the "integrity rules"?