Question 1

OleDbDataReader class includes a number of typed accessor method members (i.e GetChar( ), GetString( ), GetDecimal( ))..

Accepted Answer

A) True 
 B)False

Question 2

Which of the following SQL statements would retrieve just the first name of all records for Mr. and Mrs. Jones in the memberTable?

Accepted Answer

A)  Select * from memberTable Where LastName = 'Jones'; 
B)  Select FirstName from memberTable Where LastName = 'Jones'; 
C)  Select FirstName, LastName from memberTable Where LastName = 'Jones'; 
D)  Select FirstName from memberTable Where LastName = 'Mr. Jones' OR LastName = 'Mrs. Jones'; 
A)  Select * from memberTable Where LastName = 'Jones'; 
B)  Select FirstName from memberTable Where LastName = 'Jones'; 
C)  Select FirstName, LastName from memberTable Where LastName = 'Jones'; 
D)  Select FirstName from memberTable Where LastName = 'Mr. Jones' OR LastName = 'Mrs. Jones';

Question 3

The ADO namespace includes a number of classes that allow you to interact with databases.

Accepted Answer

A) True 
 B)False

Question 4

You can use the ____________ to edit or write new SQL statements for each of the SelectCommand, InsertCommand, UpdateCommand, and DeleteCommand's CommandTexts.

Accepted Answer

The answer of You can use the ____________ to edit...

Question 5

The ____________ provides a visual representation of the dataset and table adapter. It can be used to create and modify data and table adapters and their queries.

Accepted Answer

The answer of The ____________ provides a visual representation of...

Question 6

The ____ base class is  used to hold the SQL statement or stored procedures. ​

Accepted Answer

A)  Command 
B)  ​Adapter 
C)  ​Connection 
D)  ​SQL 
A)  Command 
B)  ​Adapter 
C)  ​Connection 
D)  ​SQL

Question 7

Included as part of the ____________ namespaces are a number of classes that can be used to retrieve, manipulate, and update data in databases.

Accepted Answer

The answer of Included as part of the ____________ namespaces...

Question 8

The SELECT statement can also be used to retrieve results from multiple tables by joining them using a common field.

Accepted Answer

A) True 
 B)False

Question 9

sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; is an example of a(n) ____________.

Accepted Answer

The answer of sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; is...

Question 10

Typically when you are programming for database access, you use a(n) ____________.

Accepted Answer

The answer of Typically when you are programming for database...

Question 11

Classes that can be used to retrieve, manipulate, and update data in databases are part of ____.

Accepted Answer

A)  ACCESS.NET 
B)  ASP.NET 
C)  ODBC.NET 
D)  ADO.NET 
A)  ACCESS.NET 
B)  ASP.NET 
C)  ODBC.NET 
D)  ADO.NET

Question 12

For simple read-only access to the database, ADO.NET includes a(n) ____________ class that can be used to read rows of data from a database.

Accepted Answer

The answer of For simple read-only access to the database,...

Question 13

Which class is used to hold the SQL statement or stored procedures for Access databases?

Accepted Answer

A)  AccessCommand 
B)  command 
C)  OleDbCommand 
D)  ODBCCommand 
A)  AccessCommand 
B)  command 
C)  OleDbCommand 
D)  ODBCCommand

Question 14

To retrieve data from multiple tables use a(n) ____.

Accepted Answer

A)  INNER JOIN 
B)  WHERE clause 
C)  BETWEEN statement 
D)  relational operator 
A)  INNER JOIN 
B)  WHERE clause 
C)  BETWEEN statement 
D)  relational operator

Question 15

Data is stored in tabular format for a relational database. Each row in the table represents a(n) ____.

Accepted Answer

A)  table 
B)  field 
C)  key 
D)  record 
A)  table 
B)  field 
C)  key 
D)  record

Question 16

The Data Source Configuration Wizard simplifies connecting your application to a  data source by guiding you through the process, automatically generating the connection  string, creating dataset and table adapter objects, and bringing the data into your  application.

Accepted Answer

A) True 
 B)False

Question 17

When you place an @ in front of a string, the string becomes a(n) ____.

Accepted Answer

A)  comment 
B)  verbatim string 
C)  numeric value 
D)  argument 
A)  comment 
B)  verbatim string 
C)  numeric value 
D)  argument

Question 18

ADO.NET requires that you keep a continuous live connection to the database and process one retrieved record at a time.

Accepted Answer

A) True 
 B)False

Question 19

Connection strings are vendor specific.

Accepted Answer

A) True 
 B)False

Question 20

A ____ object is instantiated based on the type of database or type of database provider.

Accepted Answer

A)  command 
B)  connection 
C)  data reader 
D)  data adapter 
A)  command 
B)  connection 
C)  data reader 
D)  data adapter

OleDbDataReader class includes a number of typed accessor method members (i.e GetChar( ), GetString( ), GetDecimal( ))..

Which of the following SQL statements would retrieve just the first name of all records for Mr. and Mrs. Jones in the memberTable?

The ADO namespace includes a number of classes that allow you to interact with databases.

You can use the ____________ to edit or write new SQL statements for each of the SelectCommand, InsertCommand, UpdateCommand, and DeleteCommand's CommandTexts.

The ____________ provides a visual representation of the dataset and table adapter. It can be used to create and modify data and table adapters and their queries.

The ____ base class is used to hold the SQL statement or stored procedures.

Included as part of the ____________ namespaces are a number of classes that can be used to retrieve, manipulate, and update data in databases.

The SELECT statement can also be used to retrieve results from multiple tables by joining them using a common field.

sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; is an example of a(n) ____________.

Typically when you are programming for database access, you use a(n) ____________.

Classes that can be used to retrieve, manipulate, and update data in databases are part of ____.

For simple read-only access to the database, ADO.NET includes a(n) ____________ class that can be used to read rows of data from a database.

Which class is used to hold the SQL statement or stored procedures for Access databases?

To retrieve data from multiple tables use a(n) ____.

Data is stored in tabular format for a relational database. Each row in the table represents a(n) ____.

The Data Source Configuration Wizard simplifies connecting your application to a data source by guiding you through the process, automatically generating the connection string, creating dataset and table adapter objects, and bringing the data into your application.

When you place an @ in front of a string, the string becomes a(n) ____.

ADO.NET requires that you keep a continuous live connection to the database and process one retrieved record at a time.

Connection strings are vendor specific.

A ____ object is instantiated based on the type of database or type of database provider.

Introduction to Computing and Programming

Data Types and Expressions

Methods and Behaviors

Creating Your Own Classes

Making Decisions

Repeating Instructions

Arrays

Advanced Collections

Introduction to Windows Programming

Programming Based on Events

Advanced Object-Oriented Programming Features

Debugging and Handling Exceptions

Working With Files

Web-Based Applications

Filters

Exam 14: Working With Databases

OleDbDataReader class includes a number of typed accessor method members (i.e GetChar( ), GetString( ), GetDecimal( ))..

Which of the following SQL statements would retrieve just the first name of all records for Mr. and Mrs. Jones in the memberTable?

The ADO namespace includes a number of classes that allow you to interact with databases.

You can use the ____________ to edit or write new SQL statements for each of the SelectCommand, InsertCommand, UpdateCommand, and DeleteCommand's CommandTexts.

The ____________ provides a visual representation of the dataset and table adapter. It can be used to create and modify data and table adapters and their queries.

The ____ base class is used to hold the SQL statement or stored procedures. ​

Included as part of the ____________ namespaces are a number of classes that can be used to retrieve, manipulate, and update data in databases.

The SELECT statement can also be used to retrieve results from multiple tables by joining them using a common field.

sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; is an example of a(n) ____________.

Typically when you are programming for database access, you use a(n) ____________.

Classes that can be used to retrieve, manipulate, and update data in databases are part of ____.

For simple read-only access to the database, ADO.NET includes a(n) ____________ class that can be used to read rows of data from a database.

Which class is used to hold the SQL statement or stored procedures for Access databases?

To retrieve data from multiple tables use a(n) ____.

Data is stored in tabular format for a relational database. Each row in the table represents a(n) ____.

The Data Source Configuration Wizard simplifies connecting your application to a data source by guiding you through the process, automatically generating the connection string, creating dataset and table adapter objects, and bringing the data into your application.

When you place an @ in front of a string, the string becomes a(n) ____.

ADO.NET requires that you keep a continuous live connection to the database and process one retrieved record at a time.

Connection strings are vendor specific.

A ____ object is instantiated based on the type of database or type of database provider.

Introduction to Computing and Programming

Data Types and Expressions

Methods and Behaviors

Creating Your Own Classes

Making Decisions

Repeating Instructions

Arrays

Advanced Collections

Introduction to Windows Programming

Programming Based on Events

Advanced Object-Oriented Programming Features

Debugging and Handling Exceptions

Working With Files

Web-Based Applications

Filters

The ____ base class is used to hold the SQL statement or stored procedures.