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.
State the difference between OLTP and OLAP?
What is meant by the User Objects? Specify some of its restrictions?
Write a short note on an ERD?
Database Requirements Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: • Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classifie
Describe the main three stages of transaction isolation supported by Oracle?
Explain about a Cartesian product?
Illustrates storing of data in stored procedures increase the access time?
Explain the term Enterprise and Workgroup modes?
Define the term filter?
Illustrates the term explain and how does this work?
18,76,764
1948673 Asked
3,689
Active Tutors
1415782
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!