Database Concepts  «Prev  Next»

Quiz

Each question is worth one point. Select the best answer for each question.
1. In a modern Microsoft application that connects to SQL Server, which technology is the preferred .NET data-access library?
Please select the best answer.
  A. Visual InterDev
  B. Microsoft.Data.SqlClient
  C. Global.asa
  D. Classic ADO

2. Which component normally stores the information an application needs in order to connect to SQL Server?
Please select the best answer.
  A. A connection string or configured data source
  B. The SQL Server query optimizer
  C. A table or view in the user database
  D. The old Visual InterDev Data Environment

3. In Windows, which tool is commonly used to create or manage an ODBC Data Source Name for SQL Server?
Please select the best answer.
  A. SQL Server Management Studio Object Explorer
  B. The Microsoft ODBC Driver installer only
  C. ODBC Data Sources / ODBC Data Source Administrator
  D. The SQL Server Database Engine Tuning Advisor

4. Which statement best describes Microsoft data-access drivers and providers for SQL Server?
Please select the best answer.
  A. ODBC, OLE DB, JDBC, and .NET providers are connection technologies used by different application platforms.
  B. SQL is a driver technology used to connect applications to SQL Server.
  C. OLE DB is the same thing as ODBC and always uses an ODBC driver internally.
  D. Modern SQL Server applications must use Visual InterDev to connect to a database.