D426 - Assessment Data Management Foundations
Practice Test questions with verified answers
A record consists of a? Ans ✔✔-Set of one or more fields
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? Ans ✔✔-Data reports
Which item is unstructured data? Ans ✔✔-A video
Data is/are: Ans ✔✔-Raw facts
Which classification is correct for the box marked "Registration" in the
given E-R Diagram? Ans ✔✔-Intersection
Which type of relationship exists between Student and Course? Ans ✔✔-
Many-to-many binary
What is the E-R Diagram about an online pet food vendor showing? Ans
✔✔-One Invoice Line must include a minimum of one and a maximum
of one Item.
A pet owner can have many pets; a specific pet is linked to one pet
owner. Ans ✔✔-One-to-many
, Database models were developed to? Ans ✔✔-Model real-world events
or conditions
What is the correct way to read the modality on the right side of the
association? Ans ✔✔-A minimum of zero activities
What is the modality of Volunteer? Ans ✔✔-At least one
What type of relationship is expressed with the phrase "A Painter paints
one or more Paintings"? Ans ✔✔-1:M
The entity integrity rule requires that? Ans ✔✔-All primary key entries
are unique
What does the 'refer' in referential integrity mean? Ans ✔✔-A foreign
key in a table must refer to a valid primary key in another table.
A table is perceived as a? Ans ✔✔-Two-dimensional structure
Another word for the term "relation" is? Ans ✔✔-Table
DISTINT filters the results to remove duplicates. ORDER BY? Ans ✔✔-
Modifies the presentation by changing the order of the result set.
A primary key? Ans ✔✔-Must be unique
Practice Test questions with verified answers
A record consists of a? Ans ✔✔-Set of one or more fields
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? Ans ✔✔-Data reports
Which item is unstructured data? Ans ✔✔-A video
Data is/are: Ans ✔✔-Raw facts
Which classification is correct for the box marked "Registration" in the
given E-R Diagram? Ans ✔✔-Intersection
Which type of relationship exists between Student and Course? Ans ✔✔-
Many-to-many binary
What is the E-R Diagram about an online pet food vendor showing? Ans
✔✔-One Invoice Line must include a minimum of one and a maximum
of one Item.
A pet owner can have many pets; a specific pet is linked to one pet
owner. Ans ✔✔-One-to-many
, Database models were developed to? Ans ✔✔-Model real-world events
or conditions
What is the correct way to read the modality on the right side of the
association? Ans ✔✔-A minimum of zero activities
What is the modality of Volunteer? Ans ✔✔-At least one
What type of relationship is expressed with the phrase "A Painter paints
one or more Paintings"? Ans ✔✔-1:M
The entity integrity rule requires that? Ans ✔✔-All primary key entries
are unique
What does the 'refer' in referential integrity mean? Ans ✔✔-A foreign
key in a table must refer to a valid primary key in another table.
A table is perceived as a? Ans ✔✔-Two-dimensional structure
Another word for the term "relation" is? Ans ✔✔-Table
DISTINT filters the results to remove duplicates. ORDER BY? Ans ✔✔-
Modifies the presentation by changing the order of the result set.
A primary key? Ans ✔✔-Must be unique
