« previous next »

Author Question: Explain the relationships among native DBMS libraries, ODBC, OLE DB, ADO, and ADO.NET and why each ... (Read 71 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?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

Did you know?

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Dominance relationships among individuals play an important role in many primate societies. Dominance relationships among individuals play an important role in many primate societies.
Inverse Relation Between IQ and Disease. Could this explain the Flynn effect? Inverse Relation Between IQ and Disease. Could this explain the Flynn effect?
Percentage of Foreign-Born Whites and Native Whites of Foreign or Mixed Parentage in Total Populatio Percentage of Foreign-Born Whites and Native Whites of Foreign or Mixed Parentage in Total Populatio
Please explain the different Rf values for xanthophyll’s in paper chromatography compared to ... Please explain the different Rf values for xanthophyll’s in paper chromatography compared to ...
Standard base-pairing relationships Standard base-pairing relationships
Construction of cDNA libraries Construction of cDNA libraries
Video: How eudicots (true dicots) differ from monocots Animation

For a complete list of videos, visit our video library