INFS 346 Final Quizzes With Complete
Solutions
Which of the following is typically NOT found in the database metadata?
| | | | | | | | | | |
-all answers here are correct
| | | |
-table names |
-column names |
-column data types | |
-row names |
row names
|
Front-end applications facilitate: | |
-Indirect interaction |
-neither direct nor indirect interaction
| | | |
-direct interaction |
-sometimes direct and sometimes indirect interaction (but not both at
| | | | | | | | | |
the same time)
| |
-both direct and indirect interaction
| | | |
indirect interaction |
,Implicit (undocumented) changes of requirements are permitted during:
| | | | | | |
-database deployment |
-Implicit (undocumented) changes of requirements are always
| | | | | | |
permitted (during any stage) | | |
-Implicit (undocumented) changes of requirement are not permitted
| | | | | | |
-database use |
-logical modeling |
Implicit (undocumented) changes of requirement are not permitted
| | | | | | |
Which of the following is an example of a daily operational procedure or
| | | | | | | | | | | |
task supported by an operational database?
| | | | | |
-Bank deducting the correct amount of money from a customer's
| | | | | | | | | |
checking account upon an ATM withdrawal | | | | |
-E-business issuing a correct bill to a customer who purchased a camera
| | | | | | | | | | |
-flight attendant courteously greeting passengers entering an aircraft
| | | | | | |
-all of the above
| | |
-A and B only
| | |
A and B only
| | |
,A multivalued composite attribute can be used to depict which of the
| | | | | | | | | | | |
following weak entity concepts? | | |
-all of the answers here are correct
| | | | | |
-A regular (non-identifying) one-to-many relationship between a weak
| | | | | | | |
entity and a regular entity
| | | |
-partially unique attribute | |
-Identifying relationship |
-a regular (non-identifying) many-to-many relationship between a weak
| | | | | | | |
entity and a regular entity
| | | |
identifying relationship |
What is depicted by ER diagrams?
| | | | |
-metadata only |
-data only |
-neither data nor metadata | | |
-either data or metadata, but not both
| | | | | |
-both data and metadata
| | |
metadata only |
, Within an ER diagram that contains multiple entities, each entity must
| | | | | | | | | | |
be related to at least one other entity via a relationship.
| | | | | | | | | |
-True
-False
True
The values of the following attribute are NOT permanently stored in a
| | | | | | | | | | | |
database.
-optional attribute |
-multivalued attribute |
-composite attribute |
-derived attribute |
-unique attribute |
derived attribute |
Which of the following is a legitimate exact minimum and maximum
| | | | | | | | | | |
cardinality?
-(5, 0)|
-(0, 0)|
-(20, 10) |
Solutions
Which of the following is typically NOT found in the database metadata?
| | | | | | | | | | |
-all answers here are correct
| | | |
-table names |
-column names |
-column data types | |
-row names |
row names
|
Front-end applications facilitate: | |
-Indirect interaction |
-neither direct nor indirect interaction
| | | |
-direct interaction |
-sometimes direct and sometimes indirect interaction (but not both at
| | | | | | | | | |
the same time)
| |
-both direct and indirect interaction
| | | |
indirect interaction |
,Implicit (undocumented) changes of requirements are permitted during:
| | | | | | |
-database deployment |
-Implicit (undocumented) changes of requirements are always
| | | | | | |
permitted (during any stage) | | |
-Implicit (undocumented) changes of requirement are not permitted
| | | | | | |
-database use |
-logical modeling |
Implicit (undocumented) changes of requirement are not permitted
| | | | | | |
Which of the following is an example of a daily operational procedure or
| | | | | | | | | | | |
task supported by an operational database?
| | | | | |
-Bank deducting the correct amount of money from a customer's
| | | | | | | | | |
checking account upon an ATM withdrawal | | | | |
-E-business issuing a correct bill to a customer who purchased a camera
| | | | | | | | | | |
-flight attendant courteously greeting passengers entering an aircraft
| | | | | | |
-all of the above
| | |
-A and B only
| | |
A and B only
| | |
,A multivalued composite attribute can be used to depict which of the
| | | | | | | | | | | |
following weak entity concepts? | | |
-all of the answers here are correct
| | | | | |
-A regular (non-identifying) one-to-many relationship between a weak
| | | | | | | |
entity and a regular entity
| | | |
-partially unique attribute | |
-Identifying relationship |
-a regular (non-identifying) many-to-many relationship between a weak
| | | | | | | |
entity and a regular entity
| | | |
identifying relationship |
What is depicted by ER diagrams?
| | | | |
-metadata only |
-data only |
-neither data nor metadata | | |
-either data or metadata, but not both
| | | | | |
-both data and metadata
| | |
metadata only |
, Within an ER diagram that contains multiple entities, each entity must
| | | | | | | | | | |
be related to at least one other entity via a relationship.
| | | | | | | | | |
-True
-False
True
The values of the following attribute are NOT permanently stored in a
| | | | | | | | | | | |
database.
-optional attribute |
-multivalued attribute |
-composite attribute |
-derived attribute |
-unique attribute |
derived attribute |
Which of the following is a legitimate exact minimum and maximum
| | | | | | | | | | |
cardinality?
-(5, 0)|
-(0, 0)|
-(20, 10) |
