Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Practice InterviewNew Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

DBMS Interview Questions and Answers

  Difficulty Level: AllBeginnerIntermediateExpert

Ques 1. What is database or database management systems (DBMS)?

Ques 2. What's the difference between file and database? Can files qualify as a database?

Ques 3. What is SQL?

Ques 4. What’s difference between DBMS and RDBMS?

Ques 5. What are E-R diagrams?

Ques 6. How many types of relationship exist in database designing?

Ques 7. What are DML and DDL statements?

Ques 8. How do we select distinct values from a table?

Ques 9. What is Like operator for and what are wild cards in DMBS?

Ques 10. Can you explain Insert, Update and Delete query in DBMS?

Ques 11. What is order by clause in DMBS?

Ques 12. What is the SQL " IN " clause?

Ques 13. Can you explain the between clause in DBMS?

Ques 14. How to select the first record in a given set of rows?

Ques 15. What is the default “-SORT ” order for a SQL?

Ques 16. What is a self-join?

Ques 17. What’s the difference between “UNION” and “UNION ALL”?

Ques 18. What are cursors and what are the situations you will use them?

Ques 19. What is " Group by " clause?

Ques 20. What is a Sub-Query?

Ques 21. What is Data Model?

Ques 22. What is Weak Entity set?

Ques 23. What is an Entity?

Ques 24. What is an attribute?

Ques 25. What is degree of a Relation?

Ques 26. What is Relationship?

Ques 27. What is 1 NF (Normal Form)?

Ques 28. What is 2NF?

Ques 29. What is a foreign key, and what is it used for?

©2020 WithoutBook