PrepAway - Latest Free Exam Questions & Answers

Which of the following would not correspond to the numb…

Which of the following would not correspond to the number of primary keys values found in a table in a
relational database?

PrepAway - Latest Free Exam Questions & Answers

A.
Degree

B.
Number of tuples

C.
Cardinality

D.
Number of rows

Explanation:
The degree of a table represents the number of columns in a database table. This does not correspond to the
number of primary key values in a table as each row must have a unique primary key.
Incorrect Answers:
B, D: A row in a database table is referred to as a tuple. Each row or tuple must have a unique primary key.
Therefore, the number of rows or tuples will correspond to the number of primary keys values found in a table.
D: Cardinality is the number of rows, also known as tuples, in a table. Each row or tuple must have a unique
primary key. Therefore, the cardinality of a table will correspond to the number of primary keys values found in
a table.

Stewart, James, Ed Tittel and Mike Chapple, CISSP: Certified Information Systems security Professional Study
Guide, 5th Edition, Wiley Publishing, Indianapolis, 2011, pp. 275, 277
http://databases.about.com/od/specificproducts/a/keys.htm


Leave a Reply