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

Statistics - MCQs

STATISTICS  This article contains few statistics MCQs related to mean, median, mode and standard deviation, asked in TCS Freshers placements. Q 1) The mean of the median, the mode and the range of the following data: 15, 10, 17, 13, 25, 17, 11, 18, 14, 19, 12, 20 a. 15 b. 16(2/3) c. 16 d. 15(1/3) Solution: c) 16 Arrange the data in increasing order- 10,11,12,13,14,15,17,17,18,19,20,25 Median = (Sum of the middle two terms)/2 = (15+17) /2 = 16 Mode = Number repeating the most number of times = 17 Range =10 to 25 = 15 Mean of median, mode and range = (16+17+15) /3 =16 Q 2) What is the mean of the mode and the median on the following data? 12, 28, 26, 27, 17, 16, 22, 25, 15, 16,...
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

MIS MCQs on Information System, Data-Information-Knowledge and Knowledge Management System

Hello Everyone! This is another article based on MCQs, related to Management Information System . These are the general MCQs which are commonly asked in exams and include topics like the basic introduction to Information System and its types, Data-Information-Knowledge and Knowledge Management System. Learn more about the " Information system and its types ". Also check out the First Part   and Second Part of Social Computing MCQs . Q 1) A ______ is an attempt to provide the same judgmental advice that human experts such as doctors provide. a. ES b. AI c. DSS d. KMS Solution: a) Expert System (ES) Q 2) A _________ expressly designed for the support of individual and collective decision making. a. TPS b. OIS c. MIS d. DSS Solution: d) DSS Q 3) A _______ is an...
Post a Comment
Read more