C175 PRACTISE 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 inthe
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 owne
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
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 inthe
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 owne
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
