CHAPTER10

Topics: SQL, Data modeling, Relational model Pages: 10 (1439 words) Published: January 25, 2015
Chapter 10 Databases
Section 10.1 An Introduction to Databases
1.

A rectangular array of data is called a
(A)
(B)
(C)
(D)

2.

Each row in a table is also called a(n)
(A)
(B)
(C)
(D)

3.

record.
array.
field.
selection.
A

Which one of the following statements is NOT true about tables? (A)
(B)
(C)
(D)

4.

field.
record.
table.
database management system.
C

Each column of a table represents a field.
Each row of a table represents a record.
Each record in a table contains unrelated collections of fields. A table is a rectangular array of data.
C

Which of the following is a collection of one or more (usually related) rectangular arrays of data?
(A)
(B)
(C)
(D)

a table
a field
a record
a database
D

5.

Each entry of a field of a table must contain some information. (T/F) F

6.

The management of databases is one of the major uses of computers today. (T/F) T

7.

DataBase Explorer can be used to browse through all parts of a connected database. (T/F) T

8.

What is a primary key?
(A)
(B)
(C)
(D)

9.

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

The requirement that no record may have a null primary key and that entries for primary keys be unique is called the
(A)
(B)
(C)
(D)

Rule of Referential Integrity.
Rule of Primary Keys.
Rule of Entity Integrity.
Rule of Null Values.
C

10. Which one of the following statements is true about primary keys? (A)
(B)
(C)
(D)

A column of names is usually a good choice for use as a primary key. Only a single record can be used as a primary key.
Social Security numbers are never used as a primary key.
A primary key is used to uniquely identify records in a table. D

11. Which of the following is used to uniquely identify records in a table? (A)
(B)
(C)
(D)

a Rule of Referential Integrity
a foreign key
a primary key
a relational database
C

12. 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?
(A)
(B)
(C)
(D)

the Rule of Referential Integrity
the Join statement
SQL
a relational database
A

13. Which of the following terms is defined as two or more interdependent tables? (A)
(B)
(C)
(D)

Rule of Referential Integrity
join
joined database
relational database
D

14. Which of the following allows the linking together of two or more interdependent tables in a meaningful way?
(A)
(B)
(C)
(D)

ANSI
foreign keys
duplicate entries in a single field
null values
B

15. The error message
You cannot add or change a record because a related record is required in table 'Countries'.

will be generated by attempting which of the following with the Megacities database? (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 to the table Countries with the same primary key as another record.
(D) The user tries to request a joined table using LINQ.
B
16. The error message
Index or primary key cannot contain a Null Value.

will be generated by attempting which of the following?
(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

17. The error...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Chapter10 Helicalgears Essay
  • chapter10 PQ Essay

Become a StudyMode Member

Sign Up - It's Free