D426 – Assessment Test | Actual Questions And Answers Latest Update
1. A record consists of a? Set of one or more fields
2. A DBMS performs several important functions that Data reports
guarantee the integrity and consistency of the data in
the database. Which of the following is NOT one of
those functions?
3. Which item is unstructured data? A video
4. Data is/are: Raw facts
5. Which classification is correct for the box marked "Reg- Intersection
istration" in the given E-R Diagram?
6. Which type of relationship exists between Student and Many-to-many binary
Course?
7. What is the E-R Diagram about an online pet food One Invoice Line must in-
vendor showing? clude a minimum of one
and a maximum of one
Item.
8. A pet owner can have many pets; a specific pet is linked One-to-many
to one pet owner.
9. Database models were developed to? Model real-world events
or conditions
10.
1/9
, What is the correct way to read the modality on the A minimum of zero activi-
right side of the association? ties
11. What is the modality of Volunteer? At least one
12. What type of relationship is expressed with the phrase 1:M
"A Painter paints one or more Paintings"?
13. The entity integrity rule requires that? All primary key entries are
unique
14. What does the 'refer' in referential integrity mean? A foreign key in a table
must refer to a valid pri-
mary key in another table.
15. A table is perceived as a? Two-dimensional struc-
ture
16. Another word for the term "relation" is? Table
17. DISTINT filters the results to remove duplicates. OR- Modifies the presentation
DER BY? by changing the order of
the result set.
18. A primary key? Must be unique
19. A table can be logically connected to another table by Common attribute
defining a?
20. Join
2/9
1. A record consists of a? Set of one or more fields
2. A DBMS performs several important functions that Data reports
guarantee the integrity and consistency of the data in
the database. Which of the following is NOT one of
those functions?
3. Which item is unstructured data? A video
4. Data is/are: Raw facts
5. Which classification is correct for the box marked "Reg- Intersection
istration" in the given E-R Diagram?
6. Which type of relationship exists between Student and Many-to-many binary
Course?
7. What is the E-R Diagram about an online pet food One Invoice Line must in-
vendor showing? clude a minimum of one
and a maximum of one
Item.
8. A pet owner can have many pets; a specific pet is linked One-to-many
to one pet owner.
9. Database models were developed to? Model real-world events
or conditions
10.
1/9
, What is the correct way to read the modality on the A minimum of zero activi-
right side of the association? ties
11. What is the modality of Volunteer? At least one
12. What type of relationship is expressed with the phrase 1:M
"A Painter paints one or more Paintings"?
13. The entity integrity rule requires that? All primary key entries are
unique
14. What does the 'refer' in referential integrity mean? A foreign key in a table
must refer to a valid pri-
mary key in another table.
15. A table is perceived as a? Two-dimensional struc-
ture
16. Another word for the term "relation" is? Table
17. DISTINT filters the results to remove duplicates. OR- Modifies the presentation
DER BY? by changing the order of
the result set.
18. A primary key? Must be unique
19. A table can be logically connected to another table by Common attribute
defining a?
20. Join
2/9
