« previous next »

Author Question: Explain the relationships among native DBMS libraries, ODBC, OLE DB, ADO, and ADO.NET and why each ... (Read 76 times)

Pineappleeh

  • Hero Member
  • *****
  • Posts: 585
on: Jul 7, 2018
Explain the relationships among native DBMS libraries, ODBC, OLE DB, ADO, and ADO.NET and why each led to the development of the next.
 
  What will be an ideal response?

Question 2

Which of the following statements about Subtype objects is not true?
 
  A) Subtypes can be Inclusive (an object may be more than one subtype).
  B) Subtypes can be Exclusive (an object may only be one of the subtypes).
  C) Subtypes can be Nested.
  D) All relations between the parent and subtype are 1:N.


af

  • Sr. Member
  • ****
  • Posts: 356
Reply #1 on: Jul 7, 2018
Answer to Question 1

All of these provide means of data access. Native DBMS libraries are the least abstract and are DBMS-specific access methods. Due to the large numbers of data sources that developers have to deal with, learning that many DBMS libraries was cumbersome. ODBC developed as a more abstract means of data access that shielded developers from having to learn multiple native DBMS libraries. One shortcoming of ODBC, however, was that it can only access data from sources that have a table-like structure. Therefore, OLE DB was developed as a means of accessing data from a much broader range of data source types. OLE DB is an object-oriented interface that is suitable for use by many object-oriented languages. Many developers, however, use languages such as Visual Basic and scripting languages that cannot access OLE DB. ADO was therefore developed to further abstract OLE DB and provide access to OLE DB functionality to programming languages that cannot directly access OLE DB. ADO has been followed by ADO.NET, which is part of Microsoft's .NET initiative. It extends the functionality of ADO.

Answer to Question 2

D


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Relationships among the coding sequence of a gene, the codon sequence of an mRNA, the anticodons of Relationships among the coding sequence of a gene, the codon sequence of an mRNA, the anticodons of
Approach used to determine the evolutionary relationships among many animal species using molecular Approach used to determine the evolutionary relationships among many animal species using molecular
Three possible phylogenies for the australopithecines with Au. anamnesis as the stem ancestor and re Three possible phylogenies for the australopithecines with Au. anamnesis as the stem ancestor and re
This chart illustrates the four quadrants in which we can place the relationships between the state This chart illustrates the four quadrants in which we can place the relationships between the state
Standard base-pairing relationships Standard base-pairing relationships
Phylogenetic relationships among apes and monkeys Phylogenetic relationships among apes and monkeys
Video: Brain Anatomy Animation (Part 1 of 2)

For a complete list of videos, visit our video library