A cache of records retrieved from some data source that may contain one or more

Question

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

Select one:

a. database

b. dataset

c. data adapter

d. data reader

Question 2

A new SQL Server database can be created from the ____ Explorer Window.

Select one:

a. Data

b. Data Sources

c. Solutions

d. Server

Question 3

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

Select one:

a. command

b. connection

c. data reader

d. data adapter

Question 4

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

Select one:

a. OLE DB

b. ODBC

c. SQL Server

d. Access

Question 5

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

Select one:

a. table

b. field

c. key

d. record

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

Question 1:

The correct answer is option b.

A dataset is defined as a collection of records that are retrieved from some data source, which may contain one or more tables from the data source.

Question 2:

The correct answer is option d.

A new SQL Server Database can be created using Server Explorer window. SQL Server Object Explorer provides a view similar to SQL Server Management Studio.

Question 3:

The correct answer is option b.

Before starting to work with database, the SQL connection should be created using connection object by using the type of database server.

Question 4:

The correct answer is option d.

Access is not a data provider included with .NET for accessing and manipulating data in databases.

Question 5:

The correct answer is option d.

Each row in a table represents a record.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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