DB Design – Technical Interview Questions

Please visit http://www.sharereviews.info for updated answers

Here is list of questions you may be asked during the technical interview of Data Base Designing and Development Job.

  1. What is the difference between SQL and MySQL or SQL Server?
  2. What are Hadoop & Hive?
  3. What is Data Warehouse?
  4. What is NoSQL?
  5. What is normalization?
  6. What is the differences in the first through fifth normalization forms?
  7. When we need to de-normalize their data?
  8. What are the elements of an ERD?
  9. What is the differences between primary & foreign key?
  10. What is a unique key?
  11. What is a join?
  12. What are the types of join and explain each?
  13. What is the difference between cross joins and natural joins?
  14. What is the use of views
  15. What is the use of SPs
  16. What is recursive stored procedure?
  17. What is an Index?  And what are all the different types of indexes?
  18. How to maintain database integrity where deleting from one table will automatically cause deletions in another table?
  19. On which Port SQL server run?
  20. What is Hibernate?
  21.  What are the risks of storing a hibernate managed object in  cache and how to resolve this problem?
  22. What is a Cursor?
  23. What is a relationship and what are they?
  24. What is a trigger?
  25. What is user defined functions?
  26. What are aggregate and scalar functions?
  27. What is collation?
  28. What is a query?
  29. What is sub query?  And what are the types of sub query?
  30. What are local and global variables and their differences?
  31. What is a constraint?
  32. What is data Integrity?
  33. What is Auto Increment?
  34. Can you sort a column using a column alias?
  35. Is a NULL value same as zero or a blank space? If not then what is the difference?
  36. If a table contains duplicate rows, does a query result display the duplicate values by default? How can you eliminate duplicate rows from a query result?
  37. What is the purpose of the condition operators BETWEEN and IN?

Keep visiting  for more updated answers 🙂

Also Please visit http://www.sharereviews.info for updated answers as well

Advertisements

Blog at WordPress.com.

Up ↑

%d bloggers like this: