Question 1

Which of the following is a typed accessor method of the OleDbDataReader class?
A) GetBoolean( )
B) AccessInt( )
C) RetrieveDouble( )
D) ReadDecimal( )

Accepted Answer

The correct typed accessor method of the OleDbDataReader class is GetBoolean( ) which returns a Boolean value. AccessInt( ), RetrieveDouble( ), and ReadDecimal( ) are not valid methods of the OleDbDataReader class.

Question 2

When the connection string is saved with the application, it is stored in the ____.
A) App.config file
B) data.file
C) solutions.settings file
D) connection.String file

Accepted Answer

The connection string is typically saved in the App.config file in .NET applications. This configuration file is used to store various settings and configurations for the application. Storing the connection string in this file makes it easy to manage and update if necessary.

Question 3

To retrieve data from multiple tables use a(n) ____.
A) INNER JOIN
B) WHERE clause
C) BETWEEN statement
D) relational operator

Accepted Answer

INNER JOIN is used to retrieve data from multiple tables by combining rows based on a related column between the tables. WHERE clause, BETWEEN statement, and relational operators do not retrieve data from multiple tables.

Question 4

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) ____.
A) SQL query error
B) SQL mistake
C) SQL security reference
D) SQL injection attack

Accepted Answer

This scenario describes a SQL injection attack, where an attacker uses malicious SQL code to gain unauthorized access to a database and steal or destroy data. It is important to prevent SQL injection attacks by properly sanitizing user input and using parameterized queries.

Question 5

One of the visual tools that provides a graphical representation of the dataset object and enables you to set relationships between tables is the ____.
A) Data Sources Wizard
B) Data Designer
C) DataSet Designer
D) Configuration Designer

Accepted Answer

DataSet Designer is the visual tool that provides a graphical representation of the dataset object and enables you to set relationships between tables. The Data Sources Wizard is used to create a dataset, and the Configuration Designer is used to configure options such as database connections and application settings. The Data Designer is not a commonly used term in relation to working with datasets.

Question 6

Read-only forward retrieval of data from an Access database is possible using the ____ class.
A) OleDbDataReader
B) ExecuteReader
C) SqlDataReader
D) DbReader

Accepted Answer

The OleDbDataReader class is used for read-only forward retrieval of data from a data source. The ExecuteReader method is used to execute a SQL query and return a OleDbDataReader object. The SqlDataReader class is used with SQL Server, not Access. The DbReader is an abstract class and cannot be directly used to retrieve data.

Question 7

When finished processing the data, you should close the reader and connection objects. Doing so ____.
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

Accepted Answer

Closing the reader and connection objects unlocks the database so that other applications can access it. It does not create a log of the database activities, position the reader back to the beginning row, or flush the buffer.

Question 8

Which of the following SQL statements would retrieve just the first name of all records for Mr. and Mrs. Jones in the memberTable?
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';

Accepted Answer

Option B retrieves only the first names of all records where the last name is 'Jones'. Option A retrieves all columns for records where the last name is 'Jones'. Option C retrieves both first and last names for records where the last name is 'Jones'. Option D retrieves only the first names for records where the last name is either 'Mr. Jones' or 'Mrs. Jones', which may not include all records for just 'Jones'.

Question 9

You may not want to make a local copy of the database if ____.
A) updates or changes are being made to the database
B) it is a SQL Server database
C) this is the first time the database is accessed
D) you are not the database administrator

Accepted Answer

If updates or changes are being made to the database, making a local copy could result in outdated information. It is better to access the database directly to ensure up-to-date data. B, C, and D are not necessarily reasons to avoid making a local copy of the database.

Question 10

A cache of records retrieved from some data source that may contain one or more tables from the data source describes a(n) ____.
A) database
B) dataset
C) data adapter
D) data reader

Accepted Answer

A dataset is a collection of data that has been retrieved from a data source and may contain one or more tables. It can be used for data manipulation and is often used in conjunction with a database. While a database may also contain multiple tables, it is a larger and more complex system that includes management of the data and its organization. Data adapters and data readers are classes used in data access, but do not specifically refer to a cache of records.

Question 11

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 ____.
A) dataReader["lastName"]
B) dataReader[3]
C) lastName.dataReader
D) dataReader.get(lastName)

Accepted Answer

Option A is the correct syntax for accessing a specific field in a data record using the dataReader object. The square brackets should contain either the column name as a string or the column index as an integer, and in this case, we are looking for the third field, so dataReader["lastName"] is the correct syntax. Option B is incorrect because it would return the value in the fourth column (since the index starts at zero). Option C and D are both incorrect because they attempt to access the lastName property from either the dataReader object or the get() function, which aren't applicable in this scenario.

Question 12

​ string sConnection =
"Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=member.accdb";
​
Using the segment of code above, what is member.accdb?
A) ​ the name of an Access Database
B) ​ the name of a SQL Server Database
C) ​ the name of an Access table
D) ​ the name of a SQL Server table

Accepted Answer

This connection string is used to connect to a Microsoft Access database (with file name member.accdb).

Question 13

string sConnection =
"Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=member.accdb";
​
The above connection string is associated with which type of database? ​
A) ​ Jet
B) ​ SQL Server
C) ​ Oracle
D) ​ Access

Accepted Answer

The connection string is associated with Microsoft Access database, as it refers to the ACE OLEDB provider for Access databases and specifies the data source as member.accdb, which is an Access database file.

Question 14

​After connecting to the database, one way to retrieve records programmatically from the database is to ____ ​
A) ​connect to a CommandBuilder object.
B) ​use a DataAdapter object.
C) ​issue an SQL query.
D) ​use a DataReader object.

Accepted Answer

To retrieve records programmatically from a database, you typically issue an SQL query, which is a standard way to request data from a database.

Question 15

To process the data using a data reader with an Access database, you declare an object of the OleDbDataReader class and then ____.
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

Accepted Answer

To process the data using a data reader with an Access database, you declare an object of the OleDbDataReader class and then call the ExecuteReader() method to read the data from the database. This method returns a forward-only, read-only data stream that provides sequential access to the data. The data reader can be used to retrieve data from a single table or to join data from multiple tables. The data reader must be closed when you are finished reading the data.

Question 16

Which class is automatically instantiated when a table from the Data Sources window is dragged onto the form?
A) TabControl
B) BindingNavigator
C) BindingStrip
D) MenuStrip

Accepted Answer

BindingNavigator is automatically instantiated when a table from the Data Sources window is dragged onto the form.

Question 17

The ____ base class is  used to hold the SQL statement or stored procedures. ​
A) Command
B) ​Adapter
C) ​Connection
D) ​SQL

Accepted Answer

The Command base class is used to hold the SQL statement or stored procedures. It allows the developer to execute SQL against the data source. The Command class provides methods for executing SQL statements, stored procedures, and manipulating parameters.

Question 18

ADO.NET does not require that you keep a continuous live connection to the database and process one retrieved record at a time. Additional classes are available that enable you to connect to the database long enough to retrieve records into memory. The primary class for this activity is ____.
A) DataReader
B) Connection
C) Command
D) DataSet

Accepted Answer

The primary class for retrieving records into memory and manipulating data disconnected from the database is the DataSet. The DataReader retrieves records one at a time in a forward-only, read-only manner and maintains an open connection to the database, while the Connection and Command classes are used to establish and execute queries against the database.

Question 19

All of the following are core classes that make up the ADO.NET data providers EXCEPT ____.
A) Connection
B) Command
C) DataReader
D) DataSet

Accepted Answer

The core classes that make up the ADO.NET data providers are Connection, Command, DataReader, and DataSet. Therefore, the correct choice is D, as it is the only option that does not belong to the core classes.

Question 20

​SELECT Address FROM member
WHERE FirstName = 'Bill' AND LastName = 'King';
Given the above SQL statement, which of the following statements is true? ​
A) ​Member is a record.
B) ​All rows in the table would be retrieved.
C) ​All columns in the table would be retrieved.
D) ​Address is a field.

Accepted Answer

This SQL statement is selecting the Address field from the member table where the FirstName is 'Bill' and LastName is 'King'. This means that only the Address field will be retrieved for the specific row(s) that satisfy the FirstName and LastName conditions. The table being queried is likely a list of members or customers and each row represents a single member/customer record. Therefore, A and B are incorrect because Member is likely the name of the table, not a single record, and not all rows in the table will be retrieved. C is also incorrect because only the Address column is being retrieved, not all columns.

Quiz 14: Working With Databases

Which of the following is a typed accessor method of the OleDbDataReader class?

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

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

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

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

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

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

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

You may not want to make a local copy of the database if ____.

A cache of records retrieved from some data source that may contain one or more tables from the data source describes a(n) ____.

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

string sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; Using the segment of code above, what is member.accdb?

string sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; The above connection string is associated with which type of database?

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

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

Which class is automatically instantiated when a table from the Data Sources window is dragged onto the form?

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

ADO.NET does not require that you keep a continuous live connection to the database and process one retrieved record at a time. Additional classes are available that enable you to connect to the database long enough to retrieve records into memory. The primary class for this activity is ____.

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

SELECT Address FROM member WHERE FirstName = 'Bill' AND LastName = 'King'; Given the above SQL statement, which of the following statements is true?