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

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

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

Mumbai University/BE IT/User Interaction Design/Process of Designing, Prototyping and Construction/Multiple Choice Questions - Part 3

Hello Everyone! This article is based on the common Multiple Choice Questions related to User Interface Design. The MCQs are based on the Module 4 of the syllabus- Process of Designing, Prototyping and Construction. From the University Exam point of view, these MCQs were given as question bank in the 2020 Mumbai University-BE-Information Technology Exam for the subject- User Interface Design. The MCQs set is prepared from taking different cluster data. Q 1) The use of touch in the interface is known as _______. a. Haptic Interfaces b. Multimedia Interface c. Multimodal Interface d. Gesture Interface Solution: a) Haptic Interfaces ...
Post a Comment
Read more