IT 380 A+: CHAPTER 3 EXAM ENGAGING THE LATEST UPDATE
OF QUESTIONS AND ANSWERS.
21. logic, used extensively in mathematics, provides a framework in which an
assertion (statement of fact) can be verified as either true or false.
a. Predicate b. Database
c. Relational d. Index
ANSWER: a. Predicate
22. Each table represents an attribute.
a. column b. row
c. dimension d. value
ANSWER: a. column
23. Date attributes contain calendar dates stored in a special format known as the
date format.
a. Epoch b. calendar
c. Julian d. logical
ANSWER: c. Julian
24. In the relational model, are important because they are used to ensure that
each row in a table is uniquely identifiable.
a. relations b. keys
c. indexes d. logical structures
ANSWER: b. keys
25. A is any key that uniquely identifies each row.
a. superkey b. special key
c. foreign key d. candidate key
ANSWER: a. superkey
26. A key can be described as a minimal superkey, a superkey without any
unnecessary attributes.
a. secondary b. candidate
c. primary d. foreign
ANSWER: b. candidate
, 27. A is the primary key of one table that has been placed into another table to
create a common attribute.
a. superkey b. composite primary key
c. candidate key d. foreign key
ANSWER: d. foreign key
28. Referential dictates that the foreign key must contain values that match the
primary key in the related table, or must contain null.
a. integrity b. uniqueness
c. model d. attribute
ANSWER: a. integrity
29. A key is defined as a key that is used strictly for data retrieval purposes.
a. lookup b. foreign
c. candidate d. secondary
ANSWER: d. secondary
30. The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary
key column has no null entries, and all entries are unique. This is an example of
integrity.
a. entity b. referential
c. relational d. null
ANSWER: a. entity
31. The constraint can be placed on a column to ensure that every row in the
table has a value for that column.
a. UNIQUE b. NOT NULL
c. VALUE d. EMPTY
ANSWER: b. NOT NULL
32. To be considered minimally relational, the DBMS must support the key
relational operators , PROJECT, and JOIN.
a. INTERSECT b. UNION
c. DIFFERENCE d. SELECT
ANSWER: d. SELECT
OF QUESTIONS AND ANSWERS.
21. logic, used extensively in mathematics, provides a framework in which an
assertion (statement of fact) can be verified as either true or false.
a. Predicate b. Database
c. Relational d. Index
ANSWER: a. Predicate
22. Each table represents an attribute.
a. column b. row
c. dimension d. value
ANSWER: a. column
23. Date attributes contain calendar dates stored in a special format known as the
date format.
a. Epoch b. calendar
c. Julian d. logical
ANSWER: c. Julian
24. In the relational model, are important because they are used to ensure that
each row in a table is uniquely identifiable.
a. relations b. keys
c. indexes d. logical structures
ANSWER: b. keys
25. A is any key that uniquely identifies each row.
a. superkey b. special key
c. foreign key d. candidate key
ANSWER: a. superkey
26. A key can be described as a minimal superkey, a superkey without any
unnecessary attributes.
a. secondary b. candidate
c. primary d. foreign
ANSWER: b. candidate
, 27. A is the primary key of one table that has been placed into another table to
create a common attribute.
a. superkey b. composite primary key
c. candidate key d. foreign key
ANSWER: d. foreign key
28. Referential dictates that the foreign key must contain values that match the
primary key in the related table, or must contain null.
a. integrity b. uniqueness
c. model d. attribute
ANSWER: a. integrity
29. A key is defined as a key that is used strictly for data retrieval purposes.
a. lookup b. foreign
c. candidate d. secondary
ANSWER: d. secondary
30. The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary
key column has no null entries, and all entries are unique. This is an example of
integrity.
a. entity b. referential
c. relational d. null
ANSWER: a. entity
31. The constraint can be placed on a column to ensure that every row in the
table has a value for that column.
a. UNIQUE b. NOT NULL
c. VALUE d. EMPTY
ANSWER: b. NOT NULL
32. To be considered minimally relational, the DBMS must support the key
relational operators , PROJECT, and JOIN.
a. INTERSECT b. UNION
c. DIFFERENCE d. SELECT
ANSWER: d. SELECT
