• 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass