Interview Questions on Database Management

1. How will you make your school-going brother understand the difference between the terms ‘Data Structure’ and ‘Database’?
2. Expand and explain SQL?
3. Can you write an SQL query for extracting all “name” of people in a table “T1” which contain the substring “sa” and having “age” between 35 and 45? (Students are advised to have a basic knowledge of SQL commands for various basic operations on tables)
4. Why do you say that normalization is needed? How many levels of normal forms exist?
5. What have you got to tell me about data warehousing?

6. What do you mean by a transaction?
7. Tell me something about ACID properties?
8. Differentiate between a ‘where’ clause and ‘having’ clause in SQL?
9. Can you suggest a situation in our day-to-day life where the concept of Transaction
Ordering Management is of utmost importance?
10. What do you mean by the statement ‘a transaction is committed’?

11. Why do we sometimes need to resort to denormalization?
12. What is atomicity?
13. Differentiate between a Candidate Key, a Foreign Key and a Primary Key?
14. What do you mean by concurrency control? Why is it needed?
15. Differentiate between DBMS and Database System?

16. Give me an example of popular Database System?
17. What is Functional Dependency?
18. Tell me something about “triggers” in data bases?
19. What are the different phases of transaction?
20. Tell me two advantages of using Data Bases?

21. Write an SQL query to return the name of the fourth topper among the students of a class? (Table Name = student ; Distinction Identifier = rank ; Name of the Student = student_name)
22. Give the SQL query to return the names of the customers who have bought both the items P1 and P2? (Table Name = customer ; Item Name = item_name ; Customer Name =customer_name)?

#interview