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.
- What is the difference between SQL and MySQL or SQL Server?
- What are Hadoop & Hive?
- What is Data Warehouse?
- What is NoSQL?
- What is normalization?
- What is the differences in the first through fifth normalization forms?
- When we need to de-normalize their data?
- What are the elements of an ERD?
- What is the differences between primary & foreign key?
- What is a unique key?
- What is a join?
- What are the types of join and explain each?
- What is the difference between cross joins and natural joins?
- What is the use of views
- What is the use of SPs
- What is recursive stored procedure?
- What is an Index? And what are all the different types of indexes?
- How to maintain database integrity where deleting from one table will automatically cause deletions in another table?
- On which Port SQL server run?
- What is Hibernate?
- What are the risks of storing a hibernate managed object in cache and how to resolve this problem?
- What is a Cursor?
- What is a relationship and what are they?
- What is a trigger?
- What is user defined functions?
- What are aggregate and scalar functions?
- What is collation?
- What is a query?
- What is sub query? And what are the types of sub query?
- What are local and global variables and their differences?
- What is a constraint?
- What is data Integrity?
- What is Auto Increment?
- Can you sort a column using a column alias?
- Is a NULL value same as zero or a blank space? If not then what is the difference?
- 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?
- 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