Question 1

Classes that can be used to retrieve,manipulate,and update data in databases are part of ____.

Accepted Answer

A)  ACCESS.NET 
B)  ASP.NET 
C)  ODBC.NET 
D)  ADO.NET 
A)  ACCESS.NET 
B)  ASP.NET 
C)  ODBC.NET 
D)  ADO.NET D

Question 2

The CommandBuilder object used for accessing data from database tables can be used for datasets that map to one or more database tables.

Accepted Answer

A) True 
 B)False  False

Question 3

Typically when you are programming for database access,you use a(n)____________.

Accepted Answer

query language

Question 4

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

Accepted Answer

A)  TabControl 
B)  BindingNavigator 
C)  BindingStrip 
D)  MenuStrip 
A)  TabControl 
B)  BindingNavigator 
C)  BindingStrip 
D)  MenuStrip

Question 5

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

Accepted Answer

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

Question 6

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 7

Using the local copy of data stored in a datagrid object,you can delete,insert new records or change the values of individual fields in the data grid.

Accepted Answer

A) True 
 B)False

Question 8

After values have been retrieved using the OleDbDataReader,you can send the ordinal location of data fields as arguments to methods of the OleDbDataReader class.

Accepted Answer

A) True 
 B)False

Question 9

Each data provider includes a collection of classes used to access a data source,including connection,command,data reader and data adapter classes.

Accepted Answer

A) True 
 B)False

Question 10

To retrieve data from a database programmatically,one of the first things you must do is ____.

Accepted Answer

A)  issue a command to retrieve the records from the database 
B)  include a using directive inside the try...catch block to add a reference to the correct data provider 
C)  connect to the database 
D)  turn on the data provider database engine 
A)  issue a command to retrieve the records from the database 
B)  include a using directive inside the try...catch block to add a reference to the correct data provider 
C)  connect to the database 
D)  turn on the data provider database engine

Question 11

A foreign key is a column (field)or combination of columns that uniquely identifies a
row in a table.

Accepted Answer

A) True 
 B)False

Question 12

The default server name for SQL Express is (LocalDB)\v11.0.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  database 
B)  dataset 
C)  data adapter 
D)  data reader 
A)  database 
B)  dataset 
C)  data adapter 
D)  data reader

Question 14

The Dataset Designer tool provides a visual representation of the objects contained in the dataset object.

Accepted Answer

A) True 
 B)False

Question 15

DataAdapter classes are used to exchange data between a database source and a dataset object.

Accepted Answer

A) True 
 B)False

Question 16

Applications that connect to a Microsoft Access database use the OLE DB data provider.

Accepted Answer

A) True 
 B)False

Question 17

OleDbDataReader class includes a number of typed accessor method members (i.e GetChar( ),GetString( ),GetDecimal( ))..

Accepted Answer

A) True 
 B)False

Question 18

string sConnection =
"Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=member.accdb";
-Which class is used to hold the SQL statement or stored procedures for Access databases?

Accepted Answer

A)  AccessCommand 
B)  command 
C)  OleDbCommand 
D)  ODBCCommand 
A)  AccessCommand 
B)  command 
C)  OleDbCommand 
D)  ODBCCommand

Question 19

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

Accepted Answer

A)  Jet 
B)  SQL Server 
C)  Oracle 
D)  Access 
A)  Jet 
B)  SQL Server 
C)  Oracle 
D)  Access

Question 20

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

Classes that can be used to retrieve,manipulate,and update data in databases are part of ____.

The CommandBuilder object used for accessing data from database tables can be used for datasets that map to one or more database tables.

Typically when you are programming for database access,you use a(n)____________.

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

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

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

Using the local copy of data stored in a datagrid object,you can delete,insert new records or change the values of individual fields in the data grid.

After values have been retrieved using the OleDbDataReader,you can send the ordinal location of data fields as arguments to methods of the OleDbDataReader class.

Each data provider includes a collection of classes used to access a data source,including connection,command,data reader and data adapter classes.

To retrieve data from a database programmatically,one of the first things you must do is ____.

A foreign key is a column (field)or combination of columns that uniquely identifies a row in a table.

The default server name for SQL Express is (LocalDB)\v11.0.

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

The Dataset Designer tool provides a visual representation of the objects contained in the dataset object.

DataAdapter classes are used to exchange data between a database source and a dataset object.

Applications that connect to a Microsoft Access database use the OLE DB data provider.

OleDbDataReader class includes a number of typed accessor method members (i.e GetChar( ),GetString( ),GetDecimal( ))..

string sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; -Which class is used to hold the SQL statement or stored procedures for Access databases?

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

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

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

Classes that can be used to retrieve,manipulate,and update data in databases are part of ____.

The CommandBuilder object used for accessing data from database tables can be used for datasets that map to one or more database tables.

Typically when you are programming for database access,you use a(n)____________.

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

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

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

Using the local copy of data stored in a datagrid object,you can delete,insert new records or change the values of individual fields in the data grid.

After values have been retrieved using the OleDbDataReader,you can send the ordinal location of data fields as arguments to methods of the OleDbDataReader class.

Each data provider includes a collection of classes used to access a data source,including connection,command,data reader and data adapter classes.

To retrieve data from a database programmatically,one of the first things you must do is ____.

A foreign key is a column (field)or combination of columns that uniquely identifies a row in a table.

The default server name for SQL Express is (LocalDB)\v11.0.

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

The Dataset Designer tool provides a visual representation of the objects contained in the dataset object.

DataAdapter classes are used to exchange data between a database source and a dataset object.

Applications that connect to a Microsoft Access database use the OLE DB data provider.

OleDbDataReader class includes a number of typed accessor method members (i.e GetChar( ),GetString( ),GetDecimal( ))..

string sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; -Which class is used to hold the SQL statement or stored procedures for Access databases?

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

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

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