Question 1

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 2

Typing or inserting an actual SQL query or command as input (as opposed to a requested value, such as a user login name), gaining access to the tables, and then stealing or destroying data is an example of a(n) ____.

Accepted Answer

A)  SQL query error 
B)  SQL mistake 
C)  SQL security reference 
D)  SQL injection attack 
A)  SQL query error 
B)  SQL mistake 
C)  SQL security reference 
D)  SQL injection attack

Question 3

​After connecting to the database, one way to retrieve records programmatically from the database is to ____ ​

Accepted Answer

A)  ​connect to a CommandBuilder object. 
B)  ​use a DataAdapter object. 
C)  ​issue an SQL query. 
D)  ​use a DataReader object. 
A)  ​connect to a CommandBuilder object. 
B)  ​use a DataAdapter object. 
C)  ​issue an SQL query. 
D)  ​use a DataReader object.

Question 4

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 5

____________ provides a general purpose query facility  that can be used with not only relational data sources, but XML data, and any class of data that implemented the IEnumerable interface with IEnumerable supporting simple iteration over a collection.

Accepted Answer

The answer of ____________ provides a general purpose query facility  that...

Question 6

The SQL statement that retrieves every field from a database table includes ____ following the SELECT keyword.

Accepted Answer

A)  the first and last data field names 
B)  the special keyword 'ALL" 
C)  the first and last data field names separated by a hyphen 
D)  an asterisk (*) 
A)  the first and last data field names 
B)  the special keyword 'ALL" 
C)  the first and last data field names separated by a hyphen 
D)  an asterisk (*)

Question 7

To process the data using a data reader with an Access database, you declare an object of the OleDbDataReader class and then ____.

Accepted Answer

A)  move the data to the DataSet object 
B)  call the ExecuteReader( ) method. 
C)  declare an object of the CommandBuilder object 
D)  call the Update command 
A)  move the data to the DataSet object 
B)  call the ExecuteReader( ) method. 
C)  declare an object of the CommandBuilder object 
D)  call the Update command

Question 8

While the data reader object can hold just one record of the query result at a time, the dataset object stores an entire relational table like structure.

Accepted Answer

A) True 
 B)False

Question 9

Read-only forward retrieval of data from an Access database is possible using the ____ class.

Accepted Answer

A)  OleDbDataReader 
B)  ExecuteReader 
C)  SqlDataReader 
D)  DbReader 
A)  OleDbDataReader 
B)  ExecuteReader 
C)  SqlDataReader 
D)  DbReader

Question 10

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 11

Select * from memberTable retrieves all records from the memberTable table that do not have any blank fields.

Accepted Answer

A) True 
 B)False

Question 12

A ____ is used to perform a forward-only (sequential) access of the data in the data source while a ____ is used to populate a dataset and updates the database.

Accepted Answer

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

Question 13

One of the visual tools that provides a graphical representation of the dataset object and enables you to set relationships between tables is the ____.

Accepted Answer

A)  Data Sources Wizard 
B)  Data Designer 
C)  DataSet Designer 
D)  Configuration Designer 
A)  Data Sources Wizard 
B)  Data Designer 
C)  DataSet Designer 
D)  Configuration Designer

Question 14

The OleDbCommand class is used to hold the SQL statements used to access an Oracle database.

Accepted Answer

A) True 
 B)False

Question 15

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)

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

Typing or inserting an actual SQL query or command as input (as opposed to a requested value, such as a user login name), gaining access to the tables, and then stealing or destroying data is an example of a(n) ____.

After connecting to the database, one way to retrieve records programmatically from the database is to ____

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

____________ provides a general purpose query facility that can be used with not only relational data sources, but XML data, and any class of data that implemented the IEnumerable interface with IEnumerable supporting simple iteration over a collection.

The SQL statement that retrieves every field from a database table includes ____ following the SELECT keyword.

To process the data using a data reader with an Access database, you declare an object of the OleDbDataReader class and then ____.

While the data reader object can hold just one record of the query result at a time, the dataset object stores an entire relational table like structure.

Read-only forward retrieval of data from an Access database is possible using the ____ class.

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.

Select * from memberTable retrieves all records from the memberTable table that do not have any blank fields.

A is used to perform a forward-only (sequential) access of the data in the data source while a is used to populate a dataset and updates the database.

One of the visual tools that provides a graphical representation of the dataset object and enables you to set relationships between tables is the ____.

The OleDbCommand class is used to hold the SQL statements used to access an Oracle database.

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

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

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

Typing or inserting an actual SQL query or command as input (as opposed to a requested value, such as a user login name), gaining access to the tables, and then stealing or destroying data is an example of a(n) ____.

​After connecting to the database, one way to retrieve records programmatically from the database is to ____ ​

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

____________ provides a general purpose query facility that can be used with not only relational data sources, but XML data, and any class of data that implemented the IEnumerable interface with IEnumerable supporting simple iteration over a collection.

The SQL statement that retrieves every field from a database table includes ____ following the SELECT keyword.

To process the data using a data reader with an Access database, you declare an object of the OleDbDataReader class and then ____.

While the data reader object can hold just one record of the query result at a time, the dataset object stores an entire relational table like structure.

Read-only forward retrieval of data from an Access database is possible using the ____ class.

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.

Select * from memberTable retrieves all records from the memberTable table that do not have any blank fields.

A ____ is used to perform a forward-only (sequential) access of the data in the data source while a ____ is used to populate a dataset and updates the database.

One of the visual tools that provides a graphical representation of the dataset object and enables you to set relationships between tables is the ____.

The OleDbCommand class is used to hold the SQL statements used to access an Oracle database.

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

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

After connecting to the database, one way to retrieve records programmatically from the database is to ____

A is used to perform a forward-only (sequential) access of the data in the data source while a is used to populate a dataset and updates the database.