Demerits of ODBC
What demerits of ODBC does OLE DB overcome?
Expert
By breaking the characteristics and the functions of a DBMS into COM objects, OLE DB characteristic overcomes major demerits of ODBC. With ODBC, a vendor must make an ODBC driver for almost all DBMS characteristics and functions in order to participate in ODBC at all. This is a large task which requires a substantial initial investment. With OLE DB, but, a DBMS vendor can implement portions of their product.
Improvement in Automation: Cloud computing is designed and coded to perform a lot of operations by itself. It has been designed to operate in a completely automated fashion. It enhances the efficiency of the organization.
Explain three types of SQL database server architecture?
How can we do unit testing into the informatica? How to load data in the informatica?
Write down brief note on the issues for database performance?
How do I set a password to be null?
Explain the usage of the repository connectivity?
Explain the automated document scheduling and distribution?
Explain about a Cartesian product?
Give a brief introduction of the term Dimensional Modeling?
Explain what is meant by the term stored procedures?
18,76,764
1929054 Asked
3,689
Active Tutors
1413127
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!