prakashr.r7 (5/5/2014)
1.What is the difference between OLEDB and OLAP and OLTP ?
I suspect you either misheard or that was a trick question. OLEDB is something completely, totally different from OLAP and OLTP. Like asking "What's the difference between an airplane, an apple and an orange?"
Regardless, a google search for each of the three acronyms will give you their definitions, from their definitions you can get the differences.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability