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:
Location: India

Comments

Post a Comment

Popular posts from this blog

Android Architecture Stack

Hello Everyone! In this article we are discussing about the android architecture. It is essential for all the android application developers to understand the android architecture to get a clearer idea about the structure on which the application is made. From the exam point of view, the android architecture stack question has been asked several times (sometimes along with the Dalvik Virtual Machine ). Android operating system is a stack of software components which is roughly divided into five sections and four layers. The five sections of android architecture are- Linux kernel Libraries Android Runtime Application Framework Applications This is a layered architecture with each section having a different functionality. A) Linux Kernel - It is the bottom most layer of the architecture. This is the kernel on which android is based. This layer provides a level of abstraction between the hardware devices. It also contains all the l...
Post a Comment
Read more

UML - Use Case Diagram for Vending Machine

Hello Everyone! Here is an example of an Use case Diagram of a Vending Machine System. Problem Statement - A vending machine accepts coins for variety of products. The user selects the drinks from products available through selection panel. If the drink is available the price of the product is 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 coin with price. If amount deposited is less than price then error message will be displayed and all deposited coin will be dispensed by the coin dispenser else the drink will be dispensed by the product dispenser. Check out other UML (Unified Modeling Language) Diagrams - Class Diagram   Object Diagram   Sequence Diagram Collaboration Diagram   Activity Diagram   State Diagram   Component Diagram   Deployment Diagram  
Post a Comment
Read more

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