D426 – ASSESSMENT EXAM
QUESTIONS WITH COMPLETE
SOLUTIONS 2025
, A record consists of a? - ANSWERSet 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? - ANSWERData reports
Which item is unstructured data? - ANSWERA video
Data is/are: - ANSWERRaw facts
Which classification is correct for the box marked "Registration" in the given E-R
Diagram? - ANSWERIntersection
Which type of relationship exists between Student and Course? - ANSWERMany-to-
many binary
What is the E-R Diagram about an online pet food vendor showing? - ANSWEROne
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. -
ANSWEROne-to-many
Database models were developed to? - ANSWERModel real-world events or conditions
What is the correct way to read the modality on the right side of the association? -
ANSWERA minimum of zero activities
What is the modality of Volunteer? - ANSWERAt least one
What type of relationship is expressed with the phrase "A Painter paints one or more
Paintings"? - ANSWER1:M
The entity integrity rule requires that? - ANSWERAll primary key entries are unique
What does the 'refer' in referential integrity mean? - ANSWERA foreign key in a table
must refer to a valid primary key in another table.
A table is perceived as a? - ANSWERTwo-dimensional structure
Another word for the term "relation" is? - ANSWERTable
QUESTIONS WITH COMPLETE
SOLUTIONS 2025
, A record consists of a? - ANSWERSet 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? - ANSWERData reports
Which item is unstructured data? - ANSWERA video
Data is/are: - ANSWERRaw facts
Which classification is correct for the box marked "Registration" in the given E-R
Diagram? - ANSWERIntersection
Which type of relationship exists between Student and Course? - ANSWERMany-to-
many binary
What is the E-R Diagram about an online pet food vendor showing? - ANSWEROne
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. -
ANSWEROne-to-many
Database models were developed to? - ANSWERModel real-world events or conditions
What is the correct way to read the modality on the right side of the association? -
ANSWERA minimum of zero activities
What is the modality of Volunteer? - ANSWERAt least one
What type of relationship is expressed with the phrase "A Painter paints one or more
Paintings"? - ANSWER1:M
The entity integrity rule requires that? - ANSWERAll primary key entries are unique
What does the 'refer' in referential integrity mean? - ANSWERA foreign key in a table
must refer to a valid primary key in another table.
A table is perceived as a? - ANSWERTwo-dimensional structure
Another word for the term "relation" is? - ANSWERTable
