Deck 10: Database Applications

Question 1

The Data Source Configuration Wizard will only allow the programmer to choose a database file that resides in the project's \bin\Debug folder.

Answer 1

False

Question 2

The toolbox contains the TableAdapter component that allows you to establish a link from a specific file or database to your program.

Answer 2

False

Question 3

Any time a database is open,one record is considered the current record.

Answer 3

True

Question 4

The DataGridView control has a smart tag that can be used to activate the Data Source Configuration Wizard.

Question 5

Use the Sorted property of a data-bound combo box in order to sort the data in the control.

Question 6

You can display the Data Sources window and then use it to add a new data source to the project.

Question 7

A dataset is a temporary set of data stored in the memory of the computer.

Question 8

When you add a new data source to a project,a file with the extension .xml is added to the Solution Explorer.

Question 9

You can use a DataGridView control on a Windows form to display the fields from a database table.

Question 10

When the Data Source Configuration Wizard is used on a data-bound control and the details view is selected,the BindingNavigator component appears in the component tray and navigation buttons appear at the top of the form.

Question 11

The navigation bar provides buttons for Add New,Delete,and Save,but these buttons will not produce permanent changes to the database itself unless you select the database file or the .xsd file in the Solution Explorer and set its "Copy to Output Directory" property to "Copy if newer".

Question 12

If you select a database on a local disk drive when you select "Local Database File",the Data Source Configuration Wizard,if you so request,will create a copy of the database file in the project's folder.

Question 13

When working with a dataset,you are connected to the original database and all changes take place in the original database table.

Question 14

A binding source handles retrieving and updating the data in a file.

Question 15

After you connect a DataGridView control to a dataset,you must then write code in the form's Form_Load event in order to fill the dataset from the database table.

Question 16

A table adapter automatically generates SQL statements that you can use to access or update data.

Question 17

A database may contain more than one table.

Question 18

A TableAdapter,a DataSet,and BindingSource objects are added to the component tray when you add data-bound controls to a Windows form.

Question 19

Visual Basic 2010 uses ADO.NET database technology.

Question 20

A relational database generally contains multiple tables and relationships between the tables.

Question 21

What does ADO stand for?

A)Advanced Data Objects
B)Active Data Objects
C)ActiveX Directory Objects
D)ActiveX Data Objects

Question 22

Visual Basic 2010 uses _______ database technology.

A)DAO
B)ADO
C)ADO.NET
D)XML.NET

Question 23

Use the _______ in order to sort the data in a data-bound combo box.

A)Sorted property
B)QueryBuilder
C)Data Connector
D)Data Sources

Question 24

A doctor's office uses a database to store information about each of the patients.All of the information about a patient is stored in a _______.

A)file in the database
B)record in a database table
C)field in the database table
D)key field

Question 25

A library keeps track of all of the books in a database table.Author,Title,and Subject are _______ in the database table.

A)files
B)records
C)fields
D)keys

Question 26

Using _______ as the data provider,you can obtain data from sources such as Access,Oracle,Sybase,or DB2.

A)OleDb
B)SQLClient for SQL Server
C)ODBC
D)Oracle

Question 27

Each time the user selects an item from a list box in a Web page,a postback occurs,the Web page will redisplay,and the Page_Load event will occur.

Question 28

The file that contains the XML schema has a(n)_______ extension.

A).xml
B).xsd
C).scma
D).aspx

Question 29

Each column in a database table represents a _______.

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

Question 30

Which one of the following is NOT a component that appears in the component tray after a DataGridView control has been connected to a data source?

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

Question 31

LINQ is an acronym that stands for Linking Individual Numbers in a Query.

Question 32

Which of the following windows can be used to add a new data source?

A)Solution Explorer
B)Properties
C)Data Connector
D)Data Sources

Question 33

Each time the user makes a selection from a list in a Web page,_______ occurs.

A)a posting
B)a postback
C)the SortList event
D)the SmartTag event

Question 34

A database table that contains information about the students in a college probably uses the _______ as the key field.

A)last name
B)zip code
C)date of birth
D)student identification number

Question 35

Each row in a database table represents a _______.

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

Question 36

A SQL Server Express file has a(n)_______ file extension.

A).adb
B).mdb
C).mdf
D).net

Question 37

The _______ method is used to populate the data set.

A)Load
B)Data
C)Fill
D)DataSet

Question 38

The textbook examples use _______ database files.

A)Oracle
B)Access
C)SQLClient
D)SQL Server Express (SSE)

Question 39

Which of the following controls CANNOT be data bound?

A)label
B)check box
C)combo box
D)All of the controls above can be data bound

Question 40

A _______ is a temporary set of data stored in the memory of the computer.

A)record source
B)dataset
C)connector
D)table adapter

Question 41

This is a general-purpose query language that can ask a question of any data that is defined as an object,a database,or as XML.

A)AJAX
B)LINQ
C)XML
D)HTML

Question 42

Explain the following line of code that is automatically created in the Form_Load procedure when a DataGridView is connected to a data source.Identify the name of the database and table of the data source.
BooksTableAdapter.Fill(RnRBooksDataSet.Books)

Question 43

Describe each of the following objects: BindingSource,TableAdapter,and Dataset.