DBMS interview questions

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?
sql project | dbms project topics | DBMS management mini project

sql project | dbms project topics | DBMS management mini project

  1. Development of an Online Course Portal for a campus  Dbms Project
  2. Real estate management system  
  3. Song/Video Scheduling Software
  4. Airline Reservation System
  5. Employee Management System
  6. University Management System
  7. Messaging Software
  8. Computer Shoppe Management System
  9. Airline Reservation System
  10. Railway Reservation System 
  11. College Database Project
  12. Railway database management system project
  13. Library Management Database Project
  14. Payroll Database management system project
  15. Health Care Organization Dbms Project
  17. Blood Donation System Database Project
  18. Art Gallery Database Project
  19. Hotel Management System Dbms Project
  20. School Management System Dbms Project
  21. DBMS for football tournament or any other sports
  22. Book Bank Management System
  23. Rental Shop Management System
  24. Automated Electricity bill generation
  25. Citizen Management System
  26. Any product’s shop management system
  27. Mall Management System
  28. Music/ Video Rental System or book/any product’s rental system
  29. Project Management System
  30. Teacher Monitoring System
  31. University Time-table generation System
  32. Gym Management System29. Movie ticket booking system (distributed database)
  33. Facebook/Orkut (single computer based)
  34. Virtual implementation of YouTube
  35. Computer Troubleshooting Intelligent System Dbms Project
  36. ATM Reporting system  Dbms Project
  37. Orkut Java  Dbms Project
  38. Ant Colony Optimization Technique For Manets  Dbms Project
  39. Image Steganography  Dbms Project
  40. J3ME and Bluetooth Enabled Mobile Based Full Duplex Automation System  Dbms Project
  41. DEMOS Online Quiz  Dbms Project
  42. Query Processing in Global Information Systems Dbms Project
  43. A Conceptual Graph Approach to Support Multiperspective Development Environments  Dbms Project
  44. Congestion control in ATM-based Broadband ISDNs  Dbms Project
  45. Collaboration Server Dbms Project
  46. Web based Applications for Insurance Services Dbms Project
  47. Virtual Class Rooms Dbms Project
  48. Audio Manager Dbms Project
  49. Secure Group Communication Dbms Project
  50. Low Cost Wireless Internet Dbms Project
  51. Comparison & Simulation of Different Queuing Models Dbms Project
  52. Employee Tracking System Dbms Project
  53. Empirical Model of HTTP Network Traffic Dbms Project
  54. Crypto Acceleration Using Asynchronous FPGAs Dbms Project
  55. Electronic Mail Server Dbms Project
  56. SUDOKU Dbms Project
  57. Bluetooth Home Automation Dbms Project
  58. Chat Server Dbms Project
  59. Virtual Shopping Dbms Project
  60. BLUETOOTH HOTSPOT Dbms Project
  61. Threshold-Multisignature in Distributed System Dbms Project
  62. Trackerz Dbms Project
  63. UA Portal Dbms Project
  64. Survey Logics Dbms Project
  65. Mingle Box Dbms Project
  66. Telephone Billing System Dbms Project
  67. Vehicle Management System Dbms Project
  68. Universal Web Based File Coordinator Dbms Project
  69. Value card - Smart card based Loyalty Dbms Project
  70. Web Enabled Interactive, Dynamic And Authenticated Work Order System Dbms Project
  71. Student Attendance Management System Dbms Project
  72. Training & Placement Cell Management Dbms Project
  73. Trade Service Engine Dbms Project
  74. Online Bus Reservation Dbms Project
  75. Implementation Of a Mini Search Engine Dbms Project
  76. Implementation of Security in WAN Dbms Project
  77. Securable Network in Three-Party Protocols Dbms Project
  78. Web Mining Dbms Project
  79. Security System For DNS Using Cryptography Dbms Project
  80. Student Information System Dbms Project
  81. Generic SQL Explorer Dbms Project
  82. E-Mail Campaign System Dbms Project
  83. Log Reader Based Code Analyzer Dbms Project
  84. Partial Face Recognition Using Core features Of The Face Dbms Project
  85. Multi-Tasking Sockets Dbms Project
  86. Bank Management System Dbms Project
  87. Hospital Management System Dbms Project
  88. Insurance Databas Dbms Projecte
  89. Sliding Window Protocol Dbms Project
  90. File Compression Dbms Project
  91. Device Switching Using PC's Parallel Port Dbms Project
  92. Enhancing an Application Server to Support Available Components Dbms Project
  93. Bluetooth Dbms Project
  94. Dynamic Flash Interface Dbms Project
  95. Face Recognition in e-attendance Dbms Project
  96. Customer Complaint Report Software Dbms Project
  97. Implementation of OSPF on IPV6 Dbms Project
  98. Accelerating Ranking System Using Webgraph Dbms Project
  99. Pro-net Communication Dbms Project
  100. Chat Server and Client Application Dbms Project
  101. An Intelligent Eye Dbms Project
  102. Result Alert System With E-mail and SMS Dbms Project
  103. Railway Route Optimization System Dbms Project
  104. Online Examination System Dbms Project
  105. Face Detection Using Epitomic Analysis Dbms Project
  106. Implementation of Software Management and Maintenance Dbms Project
  107. Portable Media Player Dbms Project
  108. Bug Tracking System Dbms Project
  109. Rich Internet Application for Weekly Automatic College Timetable Generation Dbms Project
  110. Design And Analysis Of Sense Amplifier Dbms Project
  111. Cold Boot Attack Dbms Project
  112. XML Enabled Wrapper Construction Dbms Project
  113. Digital Diary Dbms Project
  114. Intruder Detection System Over Abnormal Internet Sequence Dbms Project
  115. Digital System Architecture Dbms Project
  116. ER Diagram Maker Dbms Project
  117. Early Congestion Indication Dbms Project
  118. SMTP Mail Server Dbms Project
  119. Support Vector Machines For Face Recognition Dbms Project
  120. Inventory Management System Dbms Project
  121. Creepy Crawler System Dbms Project
  122. Bandwidth-Allocation-for-Distributed-Algorithm Dbms Project
  123. Network Monitoring for Remote Task Executor Dbms Project
  124. GPS Rover Dbms Project

isosceles triangle | right | obtuse | acute isosceles triangle

Definition of An isosceles triangle(समद्विबाहु त्रिकोण):
A Triangle with two equal side is an Isosceles Triangle(if two side of triangle equal in length then two angles of triangle also equal), So now Defintion is like "A Triangle with two equal side and Two equal Angles" is an isosceles triangl.lenght a=b and angle α is equal(see in below picture/image)

isosceles triangle theorem
if angles, then sides: If two angles of a triangle are congruent, then the sides opposite those angles are congruent.
If sides, then angles: If two sides of a triangle are congruent, then the angles opposite those sides are congruent.

Area and Perimeter of isosceles Triangle
perimeter of isosceles triangle=2a+b
Area of isosceles Triangle=1/2*b*h
here h=height of isosceles Triangle,b=base of isosceles Triangle

Types Of isosceles Triangles
acute isosceles triangle:
An ACUTE isosceles(all angles are acute) triangle contains three acute angles (each angle of an acute triangle is less than 90 degrees).sum of the angles of a triangle is always 180 degrees. An acute triangle may be isosceles, equilateral, or scalene.

obtuse isosceles triangle:
Obtuse isosceles triangles have one angle that is greater than 90° degrees.(Obtuse triangles have one obtuse angle).sum of the angles of a triangle is always 180 degrees.An obtuse triangle may be scalene or isosceles.

right isosceles triangle:
The right isosceles triangle has one 90 degree angle and two acute (< 90 degree) angles.sum of the angles of a triangle is always 180 degrees.A right triangle may be scalene or isosceles.

Obtuse triangles | Obtuse Angle

Obtuse triangles have one angle that is greater than 90° degrees.(Obtuse triangles have one obtuse angle).
sum of the angles of an obtuse triangle is always 180 degrees.
An obtuse triangle will have one and only one obtuse angle. The other two angles are acute angles. 
The sum of the two angles other than the obtuse angle is less than 90º. 
An obtuse triangle may be scalene or isosceles.
Figure:Obtuse triangle
Obtuse Angle Defintion

An Obtuse Angle is more than 90° but less than 180°.