Data Management Foundations Pre Test 2 Question and answers verified to pass 2024

Data Management Foundations Pre Test
2
1. A record consists of a ____.
a. character
b. collection of related records
c. set of one or more fields
d. group of files
C




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
C




We have an expert-written solution to this problem!
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.
B




4. Data is/are:
a. information
b. raw facts
c. processed information
d. a DBMS
B




A
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




B
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




C
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
B




9. Database models were developed to ____.
a. model real-world events or conditions