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

How to Download and Install Jenkins on Windows Operating System.

Hello Everyone, This is a tutorial about how to download and install Jenkins on Windows Operating System. 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. PREREQUISITE- Java Development Kit (JDK) and Java Runtime Environment (JRE). Currently 1.8 and 1.11 versions are supported by Jenkins. If other versions are installed, kindly reinstall 1.8 or 1.11. DOWNLOADING JENKINS- Step 1) Go to the website https://www.jenkins.io/ and click on the download option. Step 2) In the Downloading Jenkins section, select the LTS (Long Term Support) version for Windows. It is a more stable version with new updates every 2 or 3 months. Step 3) The Jenkins windows installer will be dow...
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

IoE (Internet of Everything) Question Paper Solution (MCQs) for 2020 Mumbai University Examination Information Technology Semester 8

Hello Everyone! This article is based on the Multiple Choice Questions asked in the University Exam for the subject Internet of Everything. These MCQs were asked in the 2020 Mumbai University-BE-Information Technology-Semester 8 Exam for the subject- Internet of Everything. The question paper for each cluster is different. These MCQs were asked in the examination of one cluster. The question paper had 25 MCQs of 2 marks each. Q 1) ________ involves making smaller and smaller things with the ability to connect and interact. a. Smart Tech b. Micro Tech c. RFID Tech d. Nano Tech Solution: d) Nano Tech Q 2) RFID stands for? a. Radio frequency identification b. Random frequency identification c. Random frequen...
Post a Comment
Read more