Deck 12: Access Databases and Linq

Question 1

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

Answer 1

C

Question 2

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

A group of related records is called a ____.

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

Question 5

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

Question 6

Each record in a table contains ____ fields.

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

Question 7

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

Question 8

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 9

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

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

Question 10

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 11

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

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

Question 12

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

Question 13

Databases created using Microsoft Access are ____ databases.

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

Question 14

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

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

Question 15

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

Question 16

Connecting an object to a control is called ____.

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

Question 17

The ____ object connects the database to the DataSet object.

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

Question 18

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

Question 19

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

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

Question 20

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

Question 21

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 22

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
An intersection of a row and column in a DataGridView.

Question 23

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

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

Question 24

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 25

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

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

Question 26

The _________________________ Wizard lists a connection to the database file in the Server Explorer window and adds a dataset's name to the Data Sources window.

Question 27

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
An electronic file that contains an organized collection of related information.

Question 28

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
A database that stores information in tables composed of columns and rows.

Question 29

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
A field in the child table that is used solely to link information to an appropriate record in the parent table.

Question 30

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 31

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

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

Question 32

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

Question 33

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 34

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
A product for creating computer databases.

Question 35

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

Question 36

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

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

Question 37

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
A language feature in Visual Basic 2012 that can be used to create a query.

Question 38

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
A copy of the data (fields and records) the application can access from the database.

Question 39

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
Database field(s) that uniquely identifies each record.

Question 40

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
An error that occurs while an application is running.

Question 41

What is a relational database?

Question 42

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

Question 43

Describe how table data is displayed using the DataGridView control.

Question 44

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

Question 45

Name five aggregate methods LINQ provides when querying a dataset.

Question 46

How does one have the computer create a bound control?

Question 47

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

Question 48

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

Question 49

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

Question 50

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