Deck 14: Working with Databases

Question 1

Connection strings are vendor specific.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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.

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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 14

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 15

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 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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 23

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

Question 24

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

Question 25

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 26

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 27

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 28

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 29

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 30

Selecting Add New Data Source from the Data menu enables you to create a new SQL Server database.

Question 31

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 32

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 33

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

Question 34

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 35

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 36

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 37

A copy of an Access database can be stored locally;however,you can not store a local copy of a SQL Server database table.

Question 38

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 39

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 40

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

Question 41

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 42

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 43

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 44

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 45

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

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

Question 46

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 47

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 48

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 49

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 50

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

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

Question 51

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

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

Question 54

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 55

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

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

Question 56

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

A) Data
B) Data Sources
C) Solutions
D) Server

Question 57

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 58

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 59

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 60

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 61

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 62

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 63

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 64

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

Question 65

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 66

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

Question 67

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

Question 68

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

Question 69

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 70

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

Question 71

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

Question 72

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 73

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

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 75

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