CST 8215 MIDTERM EXAM -DATABASE CONCEPTS &
03/29/2026
PRINCIPLES | VERIFIED QUESTIONS & ANSWERS 2026
CST 8215 Midterm Exam -Database Concepts & Principles | Verified
Questions & Answers 2026/, Exams of Nursing
A referential integrity constraint is used to make sure the values of a foreign key match a valid value of a
primary key. (T/F)
T
Which of the following is not true about a relation?
a) Has rows containing data about an entity
b) Has columns containing data about attributes of the entity
c) Has cells that hold only a single value
d) Can have two identical rows
Which of the following is true for a relation?
a) Entities in a column vary as to kind.
b) The order of the columns is important.
c) The order of the rows is unimportant.
d) More than one column can use the same name.
A relation is also known as a(n) ________.
3/29/2026
a) relationship
b) table
1
, CST 8215 MIDTERM EXAM -DATABASE CONCEPTS &
03/29/2026
PRINCIPLES | VERIFIED QUESTIONS & ANSWERS 2026
c) tuple
d) attribute
A tuple is also known as a ________.
a) table
b) row
c) relation
d) field
An attribute is also known as a ________.
a) table
b) column
c) relationship
d) row
A combination of one or more columns used to identify rows in a relation is a ________.
a) field
b) key
c) record
d) tuple
3/29/2026
2
, CST 8215 MIDTERM EXAM -DATABASE CONCEPTS &
03/29/2026
PRINCIPLES | VERIFIED QUESTIONS & ANSWERS 2026
A combination of two or more columns used to identify rows in a relation is a ________.
a) composite key
b) record
c) foreign key
d) surrogate key
A determinant that determines all the other columns in a relation is a ________.
a) foreign key
b) surrogate key
c) record
d) candidate key
When designing a database, one of the candidate keys in a relation is selected as the ________.
a) surrogate key
b) composite key
c) primary key
d) foreign key
An artificial column added to a relation to serve as the primary key is a ________.
3/29/2026
a) composite key
b) candidate key
3
, CST 8215 MIDTERM EXAM -DATABASE CONCEPTS &
03/29/2026
PRINCIPLES | VERIFIED QUESTIONS & ANSWERS 2026
c) foreign key
d) surrogate key
A key consisting of one or more columns that is a primary key in another relation is a ________.
a) composite key
b) candidate key
c) foreign key
d) surrogate key
Referential integrity constraints are used to limit the possible values of a ________.
a) composite key
b) candidate key
c) foreign key
d) surrogate key
A ________ is used to limit the possible values of a foreign key.
a) functional dependency
b) composite key
c) referential integrity constraint
d) surrogate key
3/29/2026
4
03/29/2026
PRINCIPLES | VERIFIED QUESTIONS & ANSWERS 2026
CST 8215 Midterm Exam -Database Concepts & Principles | Verified
Questions & Answers 2026/, Exams of Nursing
A referential integrity constraint is used to make sure the values of a foreign key match a valid value of a
primary key. (T/F)
T
Which of the following is not true about a relation?
a) Has rows containing data about an entity
b) Has columns containing data about attributes of the entity
c) Has cells that hold only a single value
d) Can have two identical rows
Which of the following is true for a relation?
a) Entities in a column vary as to kind.
b) The order of the columns is important.
c) The order of the rows is unimportant.
d) More than one column can use the same name.
A relation is also known as a(n) ________.
3/29/2026
a) relationship
b) table
1
, CST 8215 MIDTERM EXAM -DATABASE CONCEPTS &
03/29/2026
PRINCIPLES | VERIFIED QUESTIONS & ANSWERS 2026
c) tuple
d) attribute
A tuple is also known as a ________.
a) table
b) row
c) relation
d) field
An attribute is also known as a ________.
a) table
b) column
c) relationship
d) row
A combination of one or more columns used to identify rows in a relation is a ________.
a) field
b) key
c) record
d) tuple
3/29/2026
2
, CST 8215 MIDTERM EXAM -DATABASE CONCEPTS &
03/29/2026
PRINCIPLES | VERIFIED QUESTIONS & ANSWERS 2026
A combination of two or more columns used to identify rows in a relation is a ________.
a) composite key
b) record
c) foreign key
d) surrogate key
A determinant that determines all the other columns in a relation is a ________.
a) foreign key
b) surrogate key
c) record
d) candidate key
When designing a database, one of the candidate keys in a relation is selected as the ________.
a) surrogate key
b) composite key
c) primary key
d) foreign key
An artificial column added to a relation to serve as the primary key is a ________.
3/29/2026
a) composite key
b) candidate key
3
, CST 8215 MIDTERM EXAM -DATABASE CONCEPTS &
03/29/2026
PRINCIPLES | VERIFIED QUESTIONS & ANSWERS 2026
c) foreign key
d) surrogate key
A key consisting of one or more columns that is a primary key in another relation is a ________.
a) composite key
b) candidate key
c) foreign key
d) surrogate key
Referential integrity constraints are used to limit the possible values of a ________.
a) composite key
b) candidate key
c) foreign key
d) surrogate key
A ________ is used to limit the possible values of a foreign key.
a) functional dependency
b) composite key
c) referential integrity constraint
d) surrogate key
3/29/2026
4
