D426 Assessment questions with ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
verified detailed answers ||//|\\|| ||//|\\||
A record consists of a? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
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?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Data reports ||//|\\||
||//|\\|| ||//|\\|| ||//|\\||
Which item is unstructured data? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
A video ||//|\\||
Data is/are: ||//|\\||
Raw facts ||//|\\||
Which classification is correct for the box marked "Registration" in the given E-R Diagram? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Intersection
Which type of relationship exists between Student and Course? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Many-to-many binary ||//|\\||
What is the E-R Diagram about an online pet food vendor showing? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
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.
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
One-to-many
Database models were developed to? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Model real-world events or conditions ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
, What is the correct way to read the modality on the right side of the association?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
A minimum of zero activities
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
What is the modality of Volunteer? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
At least one ||//|\\|| ||//|\\||
What type of relationship is expressed with the phrase "A Painter paints one or more
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Paintings"?
1:M
The entity integrity rule requires that?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
All primary key entries are unique
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
What does the 'refer' in referential integrity mean? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
A foreign key in a table must refer to a valid primary key in another table.
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
A table is perceived as a?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Two-dimensional structure ||//|\\||
Another word for the term "relation" is? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Table
DISTINT filters the results to remove duplicates. ORDER BY? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Modifies the presentation by changing the order of the result set. ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
A primary key?
||//|\\|| ||//|\\||
Must be unique ||//|\\|| ||//|\\||
A table can be logically connected to another table by defining a?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Common attribute ||//|\\||
A relational operator that allows for the combination of information from two or more
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
tables is known as the ____ operator? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Join
Which of the following statements concerning the primary key is true? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
All primary key entries are unique
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
verified detailed answers ||//|\\|| ||//|\\||
A record consists of a? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
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?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Data reports ||//|\\||
||//|\\|| ||//|\\|| ||//|\\||
Which item is unstructured data? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
A video ||//|\\||
Data is/are: ||//|\\||
Raw facts ||//|\\||
Which classification is correct for the box marked "Registration" in the given E-R Diagram? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Intersection
Which type of relationship exists between Student and Course? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Many-to-many binary ||//|\\||
What is the E-R Diagram about an online pet food vendor showing? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
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.
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
One-to-many
Database models were developed to? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Model real-world events or conditions ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
, What is the correct way to read the modality on the right side of the association?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
A minimum of zero activities
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
What is the modality of Volunteer? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
At least one ||//|\\|| ||//|\\||
What type of relationship is expressed with the phrase "A Painter paints one or more
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Paintings"?
1:M
The entity integrity rule requires that?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
All primary key entries are unique
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
What does the 'refer' in referential integrity mean? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
A foreign key in a table must refer to a valid primary key in another table.
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
A table is perceived as a?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Two-dimensional structure ||//|\\||
Another word for the term "relation" is? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Table
DISTINT filters the results to remove duplicates. ORDER BY? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Modifies the presentation by changing the order of the result set. ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
A primary key?
||//|\\|| ||//|\\||
Must be unique ||//|\\|| ||//|\\||
A table can be logically connected to another table by defining a?
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Common attribute ||//|\\||
A relational operator that allows for the combination of information from two or more
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
tables is known as the ____ operator? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Join
Which of the following statements concerning the primary key is true? ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
All primary key entries are unique
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||