Skip to main content

Important Questions for Interview - Database Management System

 

Database Management System is an important topic for aptitude as well as interview in the placement process. For CS/IT students, DBMS acts like a foundation and is used throughout the engineering career. Hence good DBMS knowledge plays an important role in getting placed in majority of the IT companies. Following is the list of important questions which must be done  before appearing for the interview process.

 

  1. What is Database Management System?
  2. List the different advantages of DBMS.
  3. What do you mean by abstraction and what are the different levels of abstraction?
  4. What do you mean by instance?
  5. What is a schema? List its types.
  6. What is data independence and its types?
  7. What are the different SQL languages and the commands associated with them?
  8. Explain the ER diagram. (Entity, Attributes, Relationships, Cardinality, Participation)
  9. Explain specialization, generalization and aggregation.
  10. Explain the different keys used in SQL.
  11. What is the difference between Char and Varchar?
  12. What are the various clauses in SQL?
  13. Explain the different types of joins.
  14. What is the difference between inner and outer join?
  15. Difference between delete, truncate and drop.
  16. Explain pattern matching. Which character is used for pattern matching?
  17. What is the use of ORDER BY keyword?
  18. What is the use of distinct keyword?
  19. Difference between “having” and “where” clause.
  20. Explain about grant and revoke.
  21. Difference between Union and Union all.
  22. What is view?
  23. What are the different integrity constraints?
  24. Explain triggers.
  25. What is stored procedures?
  26. What are cursors?
  27. What do you mean by implicit and explicit cursors? Also differentiate them.
  28. What is normalization of database? Explain its types.
  29. What do you mean by clustered and non-clustered index? Also differentiate them.
  30. How are sub queries executed?
  31. What do you mean by Object-Relational DBMS?
  32. What are the ACID properties?
  33. SQL query to find second/third highest/lowest value from database.
  34. Basic queries to insert/update/retrieve data.

Labels

Labels:
Location: India

Comments

Post a Comment

Popular posts from this blog

50 + Interview Questions/Experiences of TCS DCA April 2021

Hello Everyone! This post is dedicated to the Interview Questions asked in TCS DCA. DCA which is Digital Capability Assessment is usually conducted for the internal employees of TCS who are selected for the Ninja profile. If DCA is cleared successfully, then the candidates are offered Digital profile. That means the profile changes from Assistant System Engineer to System Engineer . This year i.e., in 2021, TCS conducted DCA for the candidates who have received offer letter but not joined TCS as an employee yet. The original DCA which is conducted for internal employees has a different pattern and is not discussed in this post. Rather this post is dedicated to the DCA conducted in March and April 2021 for 2021 recruits. The DCA was conducted on 19 th and 20 th March 2021. The test had two coding questions. To sucessfully clear DCA, all the test cases of both the codes must be passed. In March DCA, a lot of students faced compile...
Post a Comment
Read more

UML - Object Diagram for Hospital Management System

Hello Everyone! Here is an example of an Object Diagram for Hospital Management System. Problem Statement - The hospital wishes to maintain a database to assist with the administration of its wards and operating theatre and to maintain information related to its patients, surgeons and nurse. Most patients are assigned to a ward on admittance and each ward may contain many patients. However, consultants (senior surgeons) in the hospital may have private patients who are assigned to private room. A nurse may or may not be assigned to a ward and she cannot be assigned to more than one ward. A ward may have many nurses assigned to it. Each ward is dedicated to a particular type of patient. A nurse may or may not be assigned to a theatre and she cannot be assigned more than one theatre. Theatre may have many nurses assigned to it. A patient may have number of operations. The information to be recorded about the operation includes the type of operation, the patients, the surgeons involv...
Post a Comment
Read more

UML - Activity Diagram for Vending Machine

Hello Everyone! Here is an example of an Activity Diagram of a Vending Machine. Problem Statement - A vending machine accepts coins for a variety of products. The user selects the drink from products available through selection panel. If the drink is available the price of the product will be displayed. The user then deposits the coins depending on the price of the product. Coin collector collects coin after stipulated time. The controller will compare the deposited coins with the price. If amount is less than the price then an error message will be displayed and all deposited coins will be dispensed by the dispenser. Otherwise the drink will be displayed by the drink dispenser. Check out other UML (Unified Modeling Language) Diagrams - Use Case Diagram   Class Diagram   Object Diagram   Sequence Diagram Collaboration Diagram   State Diagram   Component Diagram   Deployment Diagram  
Post a Comment
Read more