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.
Explain the power center repository?
Illustrates the third normal form?
Illustrates the applications of ASA?
Why recursive relationships are not good? How do you solve them?
Explain the designer objects?
Define the way of passing of variables to a SQL routine.
Why there is a need to create the user object?
Illustrates the difference between a user’s defined function and a stored procedure?
Explain three types of SQL database server architecture?
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
18,76,764
1926861 Asked
3,689
Active Tutors
1442107
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!