Question 6 In order to use the dataReader object to retrieve the lastName, which

Question

Question 6

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

Select one:

a. dataReader["lastName"]

b. dataReader[3]

c. lastName.dataReader

d. dataReader.get(lastName)

Question 7

In relational databases, data is stored ____.

Select one:

a. as a string of numeric characters separated by spaces

b. in a tabular format

c. in compressed format

d. as a set of relations

Question 8

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

Select one:

a. Data Sources Wizard

b. Data Designer

c. DataSet Designer

d. Configuration Designer

Question 9

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

Select one:

a. OleDbDataReader

b. ExecuteReader

c. SqlDataReader

d. dbReader

Question 10

The above connection string is associated with which type of database?

Select one:

a. Jet

b. SQL Server

c. Oracle

d. Access

Question 11

The ADO.NET architecture encapsulates the details of differing database structures such as

Oracle, as opposed to Access, in the form of: ____.

Select one:

a. data providers

b. databases

c. data adapters

d. data tables

Question 12

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

Select one:

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 13

To retrieve data from multiple tables use a

Select one:

a. INNER JOIN

b. WHERE clause

c. BETWEEN statement

d. relational operator

Question 14

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:

Select one:

a. SQL query error

b. SQL mistake

c. SQL security reference

d. SQL injection attack

Question 15

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

Select one:

a. app.config file

b. data file

c. solutions folder

d. connectionString file

Question 16

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

Select one:

a. comment

b. verbatim string

c. numeric value

d. argument

Question 17

Which class is automatically instantiated when the DataGridView object is dragged on the form includes buttons to move first, move backward, move forward, and move to the last records?

Select one:

a. DataGridView

b. BindingNavigator

c. BindingSource

d. MenuStrip

Question 18

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

Select one:

a. AccessCommand

b. command

c. OleDbCommand

d. ODBCCommand

Question 19

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

Select one:

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 20

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

Select one:

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

Explanation / Answer

Answer:

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"]
Question 7
In relational databases, data is stored ____.
b. in a tabular format
Question 8
One of the visual tools that provides a graphical representation of the dataset object and enables you to set relationships between tables is the
c. DataSet Designer
Question 9
Read-only forward retrieval of data from an Access database is possible using the ____ class.
c. SqlDataReader
Question 10
The above connection string is associated with which type of database?
b. SQL Server
Question 11
The ADO.NET architecture encapsulates the details of differing database structures such as
Oracle, as opposed to Access, in the form of: ____.
a. data providers
Question 12
The SQL statement that retrieves every field from a database table includes ____ following the Select keyword.
d. an asterisk (*)
Question 13
To retrieve data from multiple tables use a
a. INNER JOIN
Question 14
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:
d. SQL injection attack
Question 15
When the connection string is saved with the application, it is stored in the: ____.
a. app.config file
Question 16
When you place an @ in front of a string, the string becomes a ____.
b. verbatim string
Question 17
Which class is automatically instantiated when the DataGridView object is dragged on the form includes buttons to move first, move backward, move forward, and move to the last records?
a. DataGridView
Question 18
Which class is used to hold the SQL statement or stored procedures for Access databases?
c. OleDbCommand
Question 19
Which of the following SQL statements would retrieve just the first name of all records for Mr. and Mrs. Jones in the memberTable?
b. Select FirstName from memberTable Where LastName = ‘Jones';
Question 20
You may not want to make a local copy of the database if ____.
d. you are not the database administrator

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.