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 correct 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 correct 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 an ASP.NET Core Razor Pages application, how does a page's code-behind class normally receive a connection string stored in appsettings.json?
Please select the correct answer:
  A. By reading the appsettings.json file directly from disk with manual file-parsing code
  B. Through IConfiguration, supplied automatically by ASP.NET Core's dependency injection container
  C. By calling a Visual InterDev Data Environment object stored in Global.asa
  D. By creating a new ODBC Data Source Name through the Windows ODBC Data Source Administrator

4. Which statement best describes Microsoft data-access drivers and providers for SQL Server?
Please select the correct 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.

5. What is Entity Framework Core's primary role in a modern ASP.NET Core application?
Please select the correct answer:
  A. It replaces SQL Server as the database engine that stores application data
  B. It is an Object-Relational Mapper that lets C# code query and update the database using objects instead of writing SQL text by hand
  C. It is a Windows tool for creating and managing ODBC Data Source Names
  D. It is the COM-based predecessor to ADO.NET, accessed through Recordset objects in VBScript