Database Reference
In-Depth Information
11.10 Why are conformance levels important?
11.11 Summarize the three ODBC API conformance levels.
11.12 Summarize the three SQL grammar conformance levels.
11.13 Explain how the three types of data sources differ.
11.14 Which data source type is recommended for Web servers?
11.15 What are the two tasks to be accomplished when setting up an ODBC data
source name?
11.16 What is the Microsoft .NET Framework? What basic elements does it include?
11.17 What is the current version of the .NET Framework, and what new features does
it include?
11.18 Why is OLE DB important?
11.19 What disadvantage of ODBC does OLE DB overcome?
11.20 Define abstraction , and explain how it relates to OLE DB.
11.21 Give an example of abstraction involving rowset.
11.22 Define object properties and methods .
11.23 What is the difference between an object class and an object?
11.24 Explain the role of data consumers and data providers.
11.25 What is an interface?
11.26 What is the difference between an interface and an implementation?
11.27 Explain why an implementation can be changed but an interface should not be changed.
11.28 Summarize the goals of OLE DB.
11.29 Explain the difference between a tabular data provider and a service provider. Which
transforms OLE DB data into XML documents?
11.30 In the context of OLE DB, what is the difference between a rowset and a cursor?
11.31 What is ADO.NET?
11.32 What is a data provider?
11.33 What is a data reader?
11.34 How can ADO.NET be used to process a database without using DataReaders or DataSets?
11.35 What is an ADO.NET DataSet?
11.36 How do ADO.Net DataSets differ conceptually from databases?
11.37 List the primary structures of an ADO.NET DataSet, as described in this chapter.
11.38 How do ADO.NET DataSets solve the problem of views with multivalued paths?
11.39 What is the chief disadvantage of ADO.NET DataSets? When is this likely to be a problem?
11.40 Why, in database processing, is it important to become an object-oriented programmer?
11.41 What is an ADO.NET Connection?
11.42 What is a DataAdapter?
11.43 What is the purpose of the SelectCommand property of a DataAdapter?
11.44 How is a data table relationship constructed in ADO.NET?
11.45 How is referential integrity defined in ADO.NET? What referential integrity actions are
possible?
11.46 Explain how original, current, and proposed values differ.
Search WWH ::




Custom Search