DBMS interview questions

DBMS interview questions collection :

SQL DBMS Interview Questions for Freshers, Experienced for viva exams, company interview. List of DBMS Interview Questions for beginners and professionals asked in various exams but before we start, lets understand what is DBMS ? 

DBMS (database management system) is a system software application that interacts with the user, other applications, and the database itself to capture and analyze data. A database management system (DBMS) is a collection of programs that enables you to store, modify, and extract information from a database.

  1. What is RDBMS ?
  2. What is cardinality?
  3. Describe the differences in the first through fifth normalization forms?
  4. When might someone denormalize their data?
  5. What are the elements of an ERD?
  6. Which SQL command is used to add a row?
  7. What are advantages of DBMS over traditional file based systems?
  8. What are super, primary, candidate and foreign keys?
  9. What is the difference between primary key and unique constraints?
  10. What is database normalization?
  11. What is SQL?
  12. What are the Advantages of SQL ?
  13. What are the differences between DDL, DML and DCL in SQL?
  14. What is the difference between having and where clause?
  15. What is order by clause?
  16. How to print duplicate rows in a table
  17. What is Join? 
  18. What is Identity?
  19. What is a view in SQL? How to create one
  20. What are the uses of view?
  21. What is a Trigger?
  22. What is a stored procedure?
  23. What is the difference between Trigger and Stored Procedure?
  24. What is a transaction? What are ACID (Atomicity, Consistency, Isolation, Durability) properties?
  25. What are clustered and non-clustered Indexes?
  26. What is the difference between having and where clause?
  27. what is the exact difference between DDl and DML in DBMS?
  28. What are the differences between primary and foreign keys?
  29. What does SQL stand for?
  30. What is the difference between an inner and outer join?
  31. What port does SQL server run on?
  32. What is NoSQL?
  33. what is a field in a database ?
  34. What is a Record in a database ?
  35. What is a Table in a database ?
  36. What is a Composite Key ?
  37. What is a Composite Primary Key ?
  38. What are the advantages of DBMS?
  39. What is Query evaluation engine?
  40. What is Functional Dependency?
  41. What is Fully  and Partial Functional dependency?
  42. What is BCNF (Boyce-Codd Normal Form)?
  43. What is query and meant by query optimization?
  44. What is an attribute?
  45. What is extension and intension?
  46. What do you mean by atomicity and aggregation?
  47. Name the sub-systems of a RDBMS?
  48. How do you communicate with an RDBMS?
  49. Describe concurrency control?
  50. Explain the difference between two and three-tier architectures?
  51. Describe the three levels of data abstraction?
  52. What is Data Independence?
  53. ow many types of relationship exist in database designing?
  54. What is a database transaction?
  55. What are properties of a transaction?
  56. What is a Database Lock ?
  57. What are the type of locks ? Explain
  58. What are the different type of normalization? Explain with example
  59. What is difference between DELETE & TRUNCATE commands?
  60. What are the different phases of Transaction?
  61. What is difference between SQL and SQL SERVER?
  62. What is Specialization?
  63. What is generalization?
  64. What is schema?
  65. What is the difference between ORDERBY and GROUPBY?

Related Posts