TOP 50 MOSTLY ASKED DBMS Interview Questions
DBMS Interview Questions 1) What is DBMS? DBMS is a collection of programs that facilitates users to create and m aintain a database. 2) What is a database? Database is a logical, consistent and organized collection of data that it can easily be accessed, managed and updated
3) What is a database system? The collection of database and DBMS software together is known as database system 4) What are the advantages of DBMS? Redundancy control Restriction for unauthorized access Provides multiple user interfaces Provides backup and recovery Enforces integrity constraints
5) What is checkpoint in DBMS? A Checkpoint is like a snapshot of the DBMS state. 6) When does checkpoint occur in DBMS? By taking checkpoints, the DBMS can reduce the amount of work to be done during restart in the event of subsequent crashes ) What do you mean by transparent DBMS? The transparent DBMS is a type of DBMS w hich keeps its physical structure hidden from users. 8) What are the unary operations in Relational Algebra? PROJECTI ON and SELECTI ON are the unary operations in relational algebra 9) How do you communicate with an RDBMS? You have to use Structured Query Language (SQL) to communicate with RDBMS. 10) How many types of database languages are?
There are four types of database languages: Data Definition Language (DDL) e.g. CREATE, ALTER, DROP etc. Data Manipulation Language (DML) e.g. SELECT, UPDATE, INSERT etc. DATA Control Language (DCL) e.g. GRANT and REVOKE. Transaction Control Language (TCL) e.g. COMMIT and ROLLBACK
Verified Educator | Software Engineer |Selected in 2 IT MNC(Java) |Research Paper (NCCCS) |Quora Writer |2 yr Teaching Exp.