Question 1

All of the following are data providers included with .NET for accessing and manipulating data in databases,EXCEPT ____.

Accepted Answer

A)  OLE DB 
B)  ODBC 
C)  SQL Server 
D)  Access 
A)  OLE DB 
B)  ODBC 
C)  SQL Server 
D)  Access

Question 2

In order to test for a date value with Access tables,surround the date with single apostrophes.Surround the date with pound symbols for SQL Server data.

Accepted Answer

A) True 
 B)False

Question 3

The WSQL Designer in Visual Studio provides a visual representation of the objects contained in the dataset.It enables you to set relationships between objects and add additional queries to your application.

Accepted Answer

A) True 
 B)False

Question 4

All of the following are core classes that make up the ADO.NET data providers EXCEPT ____.

Accepted Answer

A)  Connection 
B)  Command 
C)  DataReader 
D)  DataSet 
A)  Connection 
B)  Command 
C)  DataReader 
D)  DataSet

Question 5

When accessing data from a database,select the records (and fields)from the database by executing a SQL Fill statement.

Accepted Answer

A) True 
 B)False

Question 6

The ____________ object stores an entire relational table like structure.More than one table,plus relationships and constraints on the database,can be stored with the ____________ object.The ____________ is considered a memory-resident representation of the data.

Accepted Answer

The answer of The ____________ object stores an entire relational...

Question 7

To position the OleDbDataReader object onto the row of the first retrieved query result,you use the ____________ method of the OleDbDataReader class.This method is also used to advance to the next record after the previous one is processed.

Accepted Answer

The answer of To position the OleDbDataReader object onto the...

Question 8

The four core classes that make up each data provider are ____________,Command,DataReader,and DataAdapter.

Accepted Answer

The answer of The four core classes that make up...

Question 9

The query language used to access,manipulate,and update data in a database is called Data Query Language.

Accepted Answer

A) True 
 B)False

Question 10

string sConnection =
"Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=member.accdb";
-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 11

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 an...

Question 12

A data reader class allows read-only forward retrieval of data from the database.

Accepted Answer

A) True 
 B)False

Question 13

____________ provide a communication link between the application and a database.____________ have a built-in connection object and enable you to configure the InsertCommand,UpdateCommand,and DeleteCommand SQL queries using the Properties window.

Accepted Answer

The answer of ____________ provide a communication link between the...

Question 14

In order to use the dataReader object to retrieve the lastName,which is located in the third field of a data record,you could write ____.

Accepted Answer

A)  dataReader["lastName"] 
B)  dataReader[3] 
C)  lastName.dataReader 
D)  dataReader.get(lastName) 
A)  dataReader["lastName"] 
B)  dataReader[3] 
C)  lastName.dataReader 
D)  dataReader.get(lastName)

Question 15

Connection strings are vendor specific.

Accepted Answer

A) True 
 B)False

Question 16

When the connection string is saved with the application,it is stored in the ____.

Accepted Answer

A)  App.config file 
B)  data.file 
C)  solutions.settings file 
D)  connection.String file 
A)  App.config file 
B)  data.file 
C)  solutions.settings file 
D)  connection.String file

Question 17

When accessing a database,it is not necessary to close the connection.This is done automatically for you.

Accepted Answer

A) True 
 B)False

Question 18

The ____________ class can be used to generate SQL statements automatically so that you do not have to do additional SQL programming beyond the initial SELECT statement used to retrieve the records.

Accepted Answer

OleDbComma

Question 19

The DataGridView is a customizable control that can be bound to a data source.

Accepted Answer

A) True 
 B)False

Question 20

When finished processing the data,you should close the reader and connection objects.Doing so ____.

Accepted Answer

A)  creates a log of the database activities 
B)  positions the reader back to the beginning row 
C)  unlocks the database so that other applications can access it 
D)  flushes the buffer and gets it ready for the next read 
A)  creates a log of the database activities 
B)  positions the reader back to the beginning row 
C)  unlocks the database so that other applications can access it 
D)  flushes the buffer and gets it ready for the next read

All of the following are data providers included with .NET for accessing and manipulating data in databases,EXCEPT ____.

In order to test for a date value with Access tables,surround the date with single apostrophes.Surround the date with pound symbols for SQL Server data.

The WSQL Designer in Visual Studio provides a visual representation of the objects contained in the dataset.It enables you to set relationships between objects and add additional queries to your application.

All of the following are core classes that make up the ADO.NET data providers EXCEPT ____.

When accessing data from a database,select the records (and fields)from the database by executing a SQL Fill statement.

The object stores an entire relational table like structure.More than one table,plus relationships and constraints on the database,can be stored with the object.The is considered a memory-resident representation of the data.

To position the OleDbDataReader object onto the row of the first retrieved query result,you use the ____________ method of the OleDbDataReader class.This method is also used to advance to the next record after the previous one is processed.

The four core classes that make up each data provider are ____________,Command,DataReader,and DataAdapter.

The query language used to access,manipulate,and update data in a database is called Data Query Language.

string sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; -Which of the following SQL statements would retrieve just the first name of all records for Mr.and Mrs.Jones in the memberTable?

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

A data reader class allows read-only forward retrieval of data from the database.

provide a communication link between the application and a database. have a built-in connection object and enable you to configure the InsertCommand,UpdateCommand,and DeleteCommand SQL queries using the Properties window.

In order to use the dataReader object to retrieve the lastName,which is located in the third field of a data record,you could write ____.

Connection strings are vendor specific.

When the connection string is saved with the application,it is stored in the ____.

When accessing a database,it is not necessary to close the connection.This is done automatically for you.

The ____________ class can be used to generate SQL statements automatically so that you do not have to do additional SQL programming beyond the initial SELECT statement used to retrieve the records.

The DataGridView is a customizable control that can be bound to a data source.

When finished processing the data,you should close the reader and connection objects.Doing so ____.

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

All of the following are data providers included with .NET for accessing and manipulating data in databases,EXCEPT ____.

In order to test for a date value with Access tables,surround the date with single apostrophes.Surround the date with pound symbols for SQL Server data.

The WSQL Designer in Visual Studio provides a visual representation of the objects contained in the dataset.It enables you to set relationships between objects and add additional queries to your application.

All of the following are core classes that make up the ADO.NET data providers EXCEPT ____.

When accessing data from a database,select the records (and fields)from the database by executing a SQL Fill statement.

The ____________ object stores an entire relational table like structure.More than one table,plus relationships and constraints on the database,can be stored with the ____________ object.The ____________ is considered a memory-resident representation of the data.

To position the OleDbDataReader object onto the row of the first retrieved query result,you use the ____________ method of the OleDbDataReader class.This method is also used to advance to the next record after the previous one is processed.

The four core classes that make up each data provider are ____________,Command,DataReader,and DataAdapter.

The query language used to access,manipulate,and update data in a database is called Data Query Language.

string sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; -Which of the following SQL statements would retrieve just the first name of all records for Mr.and Mrs.Jones in the memberTable?

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

A data reader class allows read-only forward retrieval of data from the database.

____________ provide a communication link between the application and a database.____________ have a built-in connection object and enable you to configure the InsertCommand,UpdateCommand,and DeleteCommand SQL queries using the Properties window.

In order to use the dataReader object to retrieve the lastName,which is located in the third field of a data record,you could write ____.

Connection strings are vendor specific.

When the connection string is saved with the application,it is stored in the ____.

When accessing a database,it is not necessary to close the connection.This is done automatically for you.

The ____________ class can be used to generate SQL statements automatically so that you do not have to do additional SQL programming beyond the initial SELECT statement used to retrieve the records.

The DataGridView is a customizable control that can be bound to a data source.

When finished processing the data,you should close the reader and connection objects.Doing so ____.

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 object stores an entire relational table like structure.More than one table,plus relationships and constraints on the database,can be stored with the object.The is considered a memory-resident representation of the data.

provide a communication link between the application and a database. have a built-in connection object and enable you to configure the InsertCommand,UpdateCommand,and DeleteCommand SQL queries using the Properties window.