C175 ALTERNATE PRACTICE TEST UPDATED 2022
C175 Practice Test 2
Multiple Choice
Identify the choice that best completes the statement or answers the question.
____ 1. A record consists of a ____.
a. character
b. collection of related records
c. set of one or more fields
d. group of files
____ 2. A DBMS performs several important functions that guarantee the integrity and consistency of the data in
the database. Which of the following is NOT one of those functions?
a. Data integrity management
b. Data storage management
c. Data reports
d. Security management
____ 3. Which item is unstructured data.
a. A record representing one student
b. A video
c. A table that holds student data
d. A relational database that hold course registration data.
____ 4. Data is/are:
a. information
b. raw facts
c. processed information
d. a DBMS
____ 5.
Which classification is correct for the box marked “Registration” in the given E-R Diagram?
a. Intersection data
b. Modality data
c. Cardinality data
, d. Student data
____ 6.
Which type of relationship exists between Student and Course
a. One-to-many binary
b. Many-to-many binary
c. One-to-many unary
d. Many-to-many unary
____ 7.
What is the E-R Diagram about an online pet food vendor showing?
a. An Invoice Line can include many Items
b. An item can only be included in one Invoice Line
c. One Invoice Line must include a minimum of one and a maximum of one Item.
d. The relationship between Item and Invoice Line is many-to-many.
____ 8. A pet owner can have many pets; a specific pet is linked to one pet owner.
Which kind of binary relationship is described in this example?
a. One-to-one
b. One-to-many
c. Many-to-many
, d. Associative
____ 9. Database models were developed to ____.
a. model real-world events or conditions
b. deposit data within a single file
c. keep data within multiple data repositories
d. allow DBMSs to maintain loose control over the database activities
____ 10.
What is the correct way to read the modality on the right side of the association?
a. A maximum of one activity
b. A maximum of zero activities
c. A minimum of zero activities
d. A maximum of many activities
____ 11.
What is the modality of Volunteer?
a. Two or more
b. Two
C175 Practice Test 2
Multiple Choice
Identify the choice that best completes the statement or answers the question.
____ 1. A record consists of a ____.
a. character
b. collection of related records
c. set of one or more fields
d. group of files
____ 2. A DBMS performs several important functions that guarantee the integrity and consistency of the data in
the database. Which of the following is NOT one of those functions?
a. Data integrity management
b. Data storage management
c. Data reports
d. Security management
____ 3. Which item is unstructured data.
a. A record representing one student
b. A video
c. A table that holds student data
d. A relational database that hold course registration data.
____ 4. Data is/are:
a. information
b. raw facts
c. processed information
d. a DBMS
____ 5.
Which classification is correct for the box marked “Registration” in the given E-R Diagram?
a. Intersection data
b. Modality data
c. Cardinality data
, d. Student data
____ 6.
Which type of relationship exists between Student and Course
a. One-to-many binary
b. Many-to-many binary
c. One-to-many unary
d. Many-to-many unary
____ 7.
What is the E-R Diagram about an online pet food vendor showing?
a. An Invoice Line can include many Items
b. An item can only be included in one Invoice Line
c. One Invoice Line must include a minimum of one and a maximum of one Item.
d. The relationship between Item and Invoice Line is many-to-many.
____ 8. A pet owner can have many pets; a specific pet is linked to one pet owner.
Which kind of binary relationship is described in this example?
a. One-to-one
b. One-to-many
c. Many-to-many
, d. Associative
____ 9. Database models were developed to ____.
a. model real-world events or conditions
b. deposit data within a single file
c. keep data within multiple data repositories
d. allow DBMSs to maintain loose control over the database activities
____ 10.
What is the correct way to read the modality on the right side of the association?
a. A maximum of one activity
b. A maximum of zero activities
c. A minimum of zero activities
d. A maximum of many activities
____ 11.
What is the modality of Volunteer?
a. Two or more
b. Two
