Sign up now
to enroll in courses, follow best educators, interact with the community and track your progress.
Download
Part 1: 10 Interview Questions of DBMS (in Hindi)
1,870 plays

More
This lesson covers some of the important Interview Questions of DBMS.

Sweta Kumari
Verified Educator | Software Engineer |Selected in 2 IT MNC(Java) |Research Paper (NCCCS) |Quora Writer |2 yr Teaching Exp.

U
Unacademy user
maam,i think rename is another unary operator in relational algebra.... please correct me if I'm wrong
Sweta Kumari
3 days ago
Jyotsana lists are already created subject wise...pls check on Unacademy learning app
Sweta Kumari
3 days ago
Sorry this comment is not for you
Sweta Kumari
3 days ago
Yes you are right
hllo sweta mam,,,agr exam k liye dbms ka padna ho..kaha se study kre.IT ka
Sweta Kumari
a year ago
hello akanksha....Kindly let me know what topics you want to get in DBMS apart from what you know....I 'll make the lessons for you...you don't have to worry..
very usefull ....thanks a lot mam
Sweta Kumari
a year ago
Thank you so much for your motivation
  1. TOP 50 MOSTLY ASKED DBMS Interview Questions


  2. 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. 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


  4. 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?


  5. 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