Deck 14: Working With Databases

Question 1

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.

Answer 1

True

Question 2

When accessing a database, it is not necessary to close the connection. This is done automatically for you.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

A data reader class allows read-only forward retrieval of data from the database.

Question 5

The query language used to access, manipulate, and update data in a database is called Data Query Language.

Question 6

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

Question 7

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

Question 8

In order to test for a date value with Access tables, surround the date with single apostrophes. Surround the date with pound symbols for SQL Server data.

Question 9

You use the data adapter object to populate the data reader object.

Question 10

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

Question 11

The SELECT statement can also be used to retrieve results from multiple tables by joining them using a common field.

Question 12

When a database is accessed using a disconnected mode, all or part of a database table(s) is retrieved and stored in a temporary file on a local machine.

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

Connection strings are vendor specific.

Question 18

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.

Question 19

ADO.NET requires that you keep a continuous live connection to the database and process one retrieved record at a time.

Question 20

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

Question 21

In relational databases, data is stored ____.

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 22

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.

Question 23

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

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 24

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

Question 25

The Data Source Configuration Wizard simplifies connecting your application to a  data source by guiding you through the process, automatically generating the connection  string, creating dataset and table adapter objects, and bringing the data into your  application.

Question 26

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
B) databases
C) data adapters
D) data tables

Question 27

The DataGridView is a customizable control that can be bound to a data source.

Question 28

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

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

Question 29

A Data Source Configuration Wizard is available in Visual Studio to automatically generate the connection string, create dataset and table adapter objects, and bring the data into an application.

Question 30

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.

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

Question 31

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

A) table
B) field
C) key
D) record

Question 32

The connection string  includes ____.

A) the data provider and the database name
B) SQL statement to retrieve the data
C) the type of database
D) an open statement

Question 33

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

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 34

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

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

Question 35

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

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

Question 36

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

A) OLE DB
B) ODBC
C) SQL Server
D) Access

Question 37

The ADO namespace includes a number of classes that allow you to interact with databases.

Question 38

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.

Question 39

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

Question 40

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

A) comment
B) verbatim string
C) numeric value
D) argument

Question 41

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

A) GetBoolean( )
B) AccessInt( )
C) RetrieveDouble( )
D) ReadDecimal( )

Question 42

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

Question 43

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

A) INNER JOIN
B) WHERE clause
C) BETWEEN statement
D) relational operator

Question 44

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

Question 45

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

Question 46

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

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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)

Question 52

​ 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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

A) Command
B) ​Adapter
C) ​Connection
D) ​SQL

Question 58

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

Question 59

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

A) Connection
B) Command
C) DataReader
D) DataSet

Question 60

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

Question 61

The four core classes that make up each data provider are ____________, Command, DataReader, and DataAdapter.

Question 62

The ____________ provides a visual representation of the dataset and table adapter. It can be used to create and modify data and table adapters and their queries.

Question 63

You identify which records and fields you want to retrieve from the database using the SQL ____________ statement.

Question 64

When you select the TableAdapter object (from the component tray) and view its properties, you will not see the SelectCommand, InsertCommand, UpdateCommand, and DeleteCommand properties. In order to change the SQL statements associated with those properties, you need to use the DataSet Designer and modify the ____________ for these properties.

Question 65

The ____________ object stores an entire relational table like structure. More than one table, plus relationships and constraints on the database, can be stored with the ____________ object. The ____________ is considered a memory-resident representation of the data.

Question 66

Included as part of the ____________ namespaces are a number of classes that can be used to retrieve, manipulate, and update data in databases.

Question 67

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

Question 68

____________ provide a communication link between the application and a database. ____________ have a built-in connection object and enable you to configure the InsertCommand, UpdateCommand, and DeleteCommand SQL queries using the Properties window.

Question 69

The ____________ class can be used to generate SQL statements automatically so that you do not have to do additional SQL programming beyond the initial SELECT statement used to retrieve the records.

Question 70

For simple read-only access to the database, ADO.NET includes a(n) ____________ class that can be used to read rows of data from a database.

Question 71

You can use the ____________ to edit or write new SQL statements for each of the SelectCommand, InsertCommand, UpdateCommand, and DeleteCommand's CommandTexts.

Question 72

Provider classes include classes that allow you to connect to the data source, execute commands against the source, and read the results. The unique provider namespace for Access databases is ____________.

Question 73

To position the OleDbDataReader object onto the row of the first retrieved query result, you use the ____________ method of the OleDbDataReader class. This method is also used to advance to the next record after the previous one is processed.

Question 74

sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=member.accdb"; is an example of a(n) ____________.

Question 75

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