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

UML - Component Diagram for Intranet development of a college/school

Hello Everyone! Here is an example of an Component Diagram for Intranet development. Problem Statement - An intranet is a computer network for sharing information, collaboration tools, operational systems, and other computing services only within an organization. An Internet Service Provider (ISP) provides LAN services, Application services, Email services, Domain and Web hosting services to an organization. The LAN service is provided through Switch to the terminals using Ethernet and other cables. The firewall feature is provided for web applications through Application services. All the students and staff members are provided with an official email account through email services. The college has its own domain and web hosting package provided by the ISP. All these services maintain a database which is stored on server. The database server and all the services are controlled and handled by the Administrator of the college. Check out other UML (Unified Modeling Language)...
Post a Comment
Read more

Connecting GitHub with Jenkins - Step by step Tutorial

Hello Everyone, In this tutorial, we will learn how to create a New Item (Project), connect Git and GitHub to Jenkins and run the files from the Git repository on Jenkins. Jenkins is an open-source automation tool written in Java with plugins built for Continuous Integration purposes. Jenkins is used to build and test your software projects continuously making it easier for developers to integrate changes to the project, and making it easier for users to obtain a fresh build. Facing trouble with the installation of Jenkins? Click here to know more. NOTE: It is mandatory to install plugins for Git and GitHub before connecting your GitHub repository to Jenkins. If you're using Jenkins for the first time, you need to install the plugins. To know more about these plugins, check out Git and GitHub Plugins for Jenkins . This tutorial demonstrates executing python code which requires separate plugins. Know more about Python Plugi...
Post a Comment
Read more