What is ADONET ADONET is a new improved and greatly expanded version of ADO

What is adonet adonet is a new improved and greatly

This preview shows page 18 - 20 out of 27 pages.

64. What is ADO.NET? 65. What is a dataset? A dataset is an in-memory database that is disconnected from any regular database, but has all the important characteristics of a regular database. Datasets can have multiple tables, relationships, referential integrity rules, referential integrity actions, views and the equivalent of triggers. Datasets are needed to provide a standardized, non-proprietary means to process database views. They are especially important for the processing of views with multiple multivalued paths. 66. Briefly describe the four JDBC driver types that Sun defines. 67. What is the difference between a Java servlet and a Java applet? 68. What is the coding pattern for using a JDBC driver? 1. Load the driver. 2. Establish a connection to the database. 3. Create a statement. 4. Do something with the statement. 69. What is a Java bean? A Java bean is a Java class that has the following three properties. (1) There are no public instance variables. (2) All persistent values are accessed using methods named getxxx and setxxx. (3) The bean class must either have no constructors or it must have one explicitly defined zero-argument constructor. 70. How are surrogate keys and metadata handled in MySQL?
Image of page 18
named mysql. For example, this database maintains two tables named user and db. 71. What is a data mart? A data mart is a collection of data smaller in scope and size than a data warehouse. It is dedicated to data from a particular business component of business functional area. A data mart may function as a subset of a larger data warehouse. Users of a data mart are usually knowledgeable analysts in the business area using the data mart.
Image of page 19
Image of page 20

You've reached the end of your free preview.

Want to read all 27 pages?

  • Spring '15
  • Alexander
  • Relational model

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture