FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Databases

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

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

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

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

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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

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

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

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

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?

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.

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

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

What is a primary key?

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.

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

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

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 rectangular array of data is called a

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?

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.

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