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"?
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"?
