Question 1

When a navigation toolbar is used with a table from a database, the first record of the table has position .

Accepted Answer

A)  0 
B)  1 
C)  First 
D)  -1 
A)  0 
B)  1 
C)  First 
D)  -1 B

Question 2

When a navigation toolbar is used with a table from a database, the first record of the table has index .

Accepted Answer

A)  0 
B)  1 
C)  First 
D)  -1 
A)  0 
B)  1 
C)  First 
D)  -1 A

Question 3

Which of the following is NOT a button on the navigation toolbar?

Accepted Answer

A)  Current position 
B)  Add new 
C)  Find 
D)  Delete 
A)  Current position 
B)  Add new 
C)  Find 
D)  Delete C

Question 4

When a navigation toolbar is used with a table from a database, the value of BindingSource1.Position is the position of the current record.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is used to insure that each value for a foreign key also appears as a value for the primary key in any related table?

Accepted Answer

A)  the Rule of Referential Integrity 
B)  the Join statement 
C)  SQL 
D)  a relational database 
A)  the Rule of Referential Integrity 
B)  the Join statement 
C)  SQL 
D)  a relational database

Question 6

The Rule of Referential Integrity insists that each value in the foreign key must also appear in the primary key of the other table.

Accepted Answer

A) True 
 B)False

Question 7

Each row in a table is also called a(n)

Accepted Answer

A)  record. 
B)  array. 
C)  field. 
D)  selection. 
A)  record. 
B)  array. 
C)  field. 
D)  selection.

Question 8

When a navigation toolbar is used with a table from a database, the Find method of the BindingSource control returns the position of a record.

Accepted Answer

A) True 
 B)False

Question 9

What control causes a binding navigator toolbar to appear anchored to the top of the form?

Accepted Answer

A)  BindingNavigator 
B)  NavigatorToolbar 
C)  Navigator 
D)  BindingToolbar 
A)  BindingNavigator 
B)  NavigatorToolbar 
C)  Navigator 
D)  BindingToolbar

Question 10

The error message Index or primary key cannot contain a Null Value. will be generated by attempting which of the following?

Accepted Answer

A)  A user tries to enter a record in the table Countries that doesn't contain data in the primary key. 
B)  A user tries to add a record to a table that is related to the Countries table, and that record contains a foreign key value that does NOT correspond to a primary key value in the Countries table. 
C)  A user tries to enter a record in the table Countries with the same primary key as another record. 
D)  A user tries to request a joined table using LINQ. 
A)  A user tries to enter a record in the table Countries that doesn't contain data in the primary key. 
B)  A user tries to add a record to a table that is related to the Countries table, and that record contains a foreign key value that does NOT correspond to a primary key value in the Countries table. 
C)  A user tries to enter a record in the table Countries with the same primary key as another record. 
D)  A user tries to request a joined table using LINQ.

Question 11

Which of the following allows the linking together of two or more interdependent tables in a meaningful way?

Accepted Answer

A)  ANSI 
B)  foreign keys 
C)  duplicate entries in a single field 
D)  null values 
A)  ANSI 
B)  foreign keys 
C)  duplicate entries in a single field 
D)  null values

Question 12

When a navigation toolbar is used with a table from a database, the statement BindingSource1.Position = n makes the record of index n the current record.

Accepted Answer

A) True 
 B)False

Question 13

A foreign key allows Visual Basic to join together two tables from a relational database in a meaningful way.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following terms is defined as two or more interdependent tables?

Accepted Answer

A)  Rule of Referential Integrity 
B)  join 
C)  joined database 
D)  relational database 
A)  Rule of Referential Integrity 
B)  join 
C)  joined database 
D)  relational database

Question 15

What is a primary key?

Accepted Answer

A)  A field that uniquely identifies each record. 
B)  The first field in every record.. 
C)  The largest field in every record.. 
D)  The first field specified when a table is created. 
A)  A field that uniquely identifies each record. 
B)  The first field in every record.. 
C)  The largest field in every record.. 
D)  The first field specified when a table is created.

Question 16

The error message The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. will be generated by attempting which of the following?

Accepted Answer

A)  A user tries to enter a record in the table Countries that doesn't contain data in the primary key. 
B)  A user tries to add a record to a table that is related to the Countries table, and that record contains a foreign key value that does NOT correspond to a primary key value in the Countries table. 
C)  A user tries to enter a record in the table Countries with the same primary key as another record. 
D)  A user tries to request a joined table using the SQL language. 
A)  A user tries to enter a record in the table Countries that doesn't contain data in the primary key. 
B)  A user tries to add a record to a table that is related to the Countries table, and that record contains a foreign key value that does NOT correspond to a primary key value in the Countries table. 
C)  A user tries to enter a record in the table Countries with the same primary key as another record. 
D)  A user tries to request a joined table using the SQL language.

Question 17

When a navigation toolbar is used with a table from a database, the Find method of the BindingSource control returns the value -1 if it cannot locate the sought after record.

Accepted Answer

A) True 
 B)False

Question 18

Once a field has been specified as a primary key, Visual Basic will not allow that field to contain an empty entry for any record.

Accepted Answer

A) True 
 B)False

Question 19

A rectangular array of data is called a

Accepted Answer

A)  field. 
B)  record. 
C)  table. 
D)  database management system. 
A)  field. 
B)  record. 
C)  table. 
D)  database management system.

Question 20

The Move next button of a navigator toolbar is never disabled.

Accepted Answer

A) True 
 B)False

When a navigation toolbar is used with a table from a database, the first record of the table has position .

When a navigation toolbar is used with a table from a database, the first record of the table has index .

Which of the following is NOT a button on the navigation toolbar?

When a navigation toolbar is used with a table from a database, the value of BindingSource1.Position is the position of the current record.

Which of the following is used to insure that each value for a foreign key also appears as a value for the primary key in any related table?

The Rule of Referential Integrity insists that each value in the foreign key must also appear in the primary key of the other table.

Each row in a table is also called a(n)

When a navigation toolbar is used with a table from a database, the Find method of the BindingSource control returns the position of a record.

What control causes a binding navigator toolbar to appear anchored to the top of the form?

The error message Index or primary key cannot contain a Null Value. will be generated by attempting which of the following?

Which of the following allows the linking together of two or more interdependent tables in a meaningful way?

When a navigation toolbar is used with a table from a database, the statement BindingSource1.Position = n makes the record of index n the current record.

A foreign key allows Visual Basic to join together two tables from a relational database in a meaningful way.

Which of the following terms is defined as two or more interdependent tables?

What is a primary key?

When a navigation toolbar is used with a table from a database, the Find method of the BindingSource control returns the value -1 if it cannot locate the sought after record.

Once a field has been specified as a primary key, Visual Basic will not allow that field to contain an empty entry for any record.

A rectangular array of data is called a

The Move next button of a navigator toolbar is never disabled.

An Introduction to Computers and Problem Solving

Visual Basic, Controls, and Events

Variables, Input, and Output

Decisions

General Procedures

Repetition

Arrays

Text Files

Additional Controls and Objects

Object-Oriented Programming

Filters

Exam 10: Databases

When a navigation toolbar is used with a table from a database, the first record of the table has position .

When a navigation toolbar is used with a table from a database, the first record of the table has index .

Which of the following is NOT a button on the navigation toolbar?

When a navigation toolbar is used with a table from a database, the value of BindingSource1.Position is the position of the current record.

Which of the following is used to insure that each value for a foreign key also appears as a value for the primary key in any related table?

The Rule of Referential Integrity insists that each value in the foreign key must also appear in the primary key of the other table.

Each row in a table is also called a(n)

When a navigation toolbar is used with a table from a database, the Find method of the BindingSource control returns the position of a record.

What control causes a binding navigator toolbar to appear anchored to the top of the form?

The error message Index or primary key cannot contain a Null Value. will be generated by attempting which of the following?

Which of the following allows the linking together of two or more interdependent tables in a meaningful way?

When a navigation toolbar is used with a table from a database, the statement BindingSource1.Position = n makes the record of index n the current record.

A foreign key allows Visual Basic to join together two tables from a relational database in a meaningful way.

Which of the following terms is defined as two or more interdependent tables?

What is a primary key?

When a navigation toolbar is used with a table from a database, the Find method of the BindingSource control returns the value -1 if it cannot locate the sought after record.

Once a field has been specified as a primary key, Visual Basic will not allow that field to contain an empty entry for any record.

A rectangular array of data is called a

The Move next button of a navigator toolbar is never disabled.

An Introduction to Computers and Problem Solving

Visual Basic, Controls, and Events

Variables, Input, and Output

Decisions

General Procedures

Repetition

Arrays

Text Files

Additional Controls and Objects

Object-Oriented Programming

Filters