What is the Database transaction? 2.Define Database Lock and its types. 3.What is Data Warehousing?

Database
1.What is the Database transaction?
2.Define Database Lock and its types.
3.What is Data Warehousing?
4.What do you understand by Join?
5.What do you understand by Index hunting?
6.How to improve query performance using Index hunting?