Database Concepts - Quiz Explanation

The correct answers are indicated below, along with text that explains the correct answers.
 
1. Which technology is used to access relational and non-relational databases?
Please select the best answer.
  A. VisualInterDev
  B. OLE DB
  C. ADO
  D. ODBC
  B is the correct answer because
OLE DB uses a set of reusable objects that allow applications to access data as objects. Answer A is incorrect because Visual InterDev doesn't access databases. Answer C is incorrect because ADO uses OLE DB to access databases. Answer D is incorrect because ODBC accesses only relational databases.

2. The Data Environment contains…
Please select the best answer.
  A. The databases used by the project
  B. Global.asa
  C. Information needed to assess data
  D. Tables and views
  Answer C is correct
because the Data Environment contains information such as logical connections to connect to the data source and possibly command objects to execute queries. Answer A is incorrect because the databases are stored on the database server. Answer B is incorrect because the Data Environment is actually defined by the information in the Global.asa file. Answer D is incorrect because tables and views are part of Visual InterDev's Data View window.

3. DSNs are setup using…
Please select the best answer.
  A. the Data Environment
  B. ODBC drivers
  C. ODBC Setup
  D. The New Data Source Wizard
  Answer C is correct
Because the ODBC manager is used to setup data source names. Answer A is incorrect because the Data Environment is simply a container of information used to access a data source. Answer B is incorrect because ODBC drivers are used to provide an interface to the data source. Answer D is incorrect because the New Data Source Wizard uses the ODMC Setup manager.

4. Which of the following technologies use vendor-specific drivers?
Please select the best answer.
  A. ODBC
  B. ADO
  C. OLE DB
  D. SQL
  Answer A is correct .
ODBC drivers are produced by relational database system developers to provide a standard programming interface to their specific database system. Answer B is incorrect because ADO uses OLE DB to access databases. Answer C is incorrect because OLE DB uses objects to access vendor-specific databases, and also uses ODBC drivers. D is incorrect because SQL is used to query, modify, and control data in a relational database system.