Deck 13: Access Databases and Linq

Question 1

The copy of the data that is accessed by the application is referred to as a(n) _____.

A) database
B) dataset
C) table
D) record

Answer 1

B

Question 2

The ____ stores objects that do not appear in the user interface when an application is running.

A) component tray
B) TableAdapter object
C) dataset
D) BindingSource object

Answer 2

A

Question 3

When an application is running, you can use the ____ control to move from one record to the next in the dataset, as well as to add or delete a record and save any changes made to the dataset.

A) Binding Source
B) Binding
C) DataGridView
D) BindingNavigator

Answer 3

D

Question 4

Before an application can access the data stored in a database, you need to connect the application to the database using ____.

A) the Preview Data dialog box
B) bound controls
C) the Data Source Configuration Wizard
D) DataGridView controls

Question 5

Connecting an object to a control is called ____.

A) binding
B) linking
C) securing
D) updating

Question 6

In order to access the data stored in a database, an application needs to be connected to the database.

Question 7

Databases created using Microsoft Access are ____ databases.

A) object-oriented
B) Web
C) transparent
D) relational

Question 8

One restriction of a relational database is that it may contain only one table.

Question 9

A ____ is a single item of information about a person, place, or thing.

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

Question 10

Controls in an interface that is connected to objects in the dataset are called ____ controls.

A) default
B) parameterized
C) linked
D) bound

Question 11

A dataset is stored in the computer's ____ memory.

A) external
B) volatile
C) internal
D) fixed

Question 12

The ____ object stores the information you want to access from the database.

A) DataSet
B) BindingNavigator
C) TableAdapterManager
D) BindingSource

Question 13

A group of related records is called a ____.

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

Question 14

A ____ is a group of related fields that contain all of the necessary data about a specific person, place, or thing.

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

Question 15

You may only bind an object to a control that the computer creates for you.

Question 16

Each record in a table contains ____ fields.

A) different
B) the same
C) identical
D) related

Question 17

In most cases, you will use the ____ object to save changes to the database, because it can handle saving data to multiple tables in the DataSet .

A) DataSet
B) TableAdapter
C) TableAdapterManager
D) BindingSource

Question 18

The ____ object connects the database to the DataSet object.

A) TableAdapter
B) BindingNavigator
C) TableAdapterManager
D) BindingSource

Question 19

The most commonly used aggregate operators are Average , Count , Max , Min , and Sum .

Question 20

You can use Visual Basic to access the data stored in databases by using a database management system.

Question 21

Describe how table data is displayed using the DataGridView control.

Question 22

A ____ specifies the fields and records to retrieve from the database, as well as the order in which to arrange the fields and records.

A) dataset
B) query
C) database builder
D) component tray

Question 23

You can create a query in Visual Basic using a language feature called ____.

A) Query Language Creator
B) Structured Query Language
C) Visual Basic Query
D) Language Integrated Query

Question 24

Describe two ways to bind an object in a dataset to an existing control on the form.

Question 25

Describe the default action taken by Visual Basic if you do not take specific steps in your code to handle exceptions.

Question 26

The AutoSizeColumnsMode property has ____ different settings that control the way the column widths are sized in the DataGridView control.

A) six
B) seven
C) eight
D) nine

Question 27

A _________________________ control displays the table data in a row-and-column format, similar to a spreadsheet.

Question 28

Why is the DataGridView control one of the most popular controls for displaying table data?

Question 29

In a two-table database, one of the tables is referred to as the parent table and the other is referred to as the ____________________ table.

Question 30

What two methods are used in conjunction with previewing the contents of a dataset and explain their use?

Question 31

If a table object's control type is changed from DataGridView to ____________________, the computer automatically provides the appropriate controls when you drag the table object to the form.

Question 32

The way Visual Basic saves changes to a local database file is determined by the file's _________________________ property.

Question 33

The BindingSource object stores the position of the record pointer in its ____________________ property.

Question 34

The ____ object provides the connection between the DataSet and the bound controls on the form.

A) ToolStrip
B) BindingNavigator
C) TableAdapterManager
D) BindingSource

Question 35

What are the advantages of storing data in a relational database?

Question 36

A(n) ____ operator returns a single value from a group of values.

A) aggregate
B) group
C) single
D) convert

Question 37

How does one have the computer create a bound control?

Question 38

What is a relational database?

Question 39

Exception handling in your code takes the form of the ____ statement.

A) Try...Catch
B) Try...Exception
C) Fix...Exception
D) Exception...Handle

Question 40

What buttons are contained on a BindingNavigator control and what additional items can you include on a BindingNavigator control?

Question 42

Name five aggregate methods LINQ provides when querying a dataset.