oracle 2 Flashcards
{“Which of the following are examples of e-businesses that use database software? (Choose all correct answers)”,
{“Online book store “, “Online personal web page”, “Online research paper”,
“Online clothing store “, “Online personal shopping service “},
{1, 4, 5}}, // Multiple correct answers
{“Data models show users the data that their Physical Model will contain.”,
{“True “, “False”},
{1}}, // Single correct answer
{“An ERD is an example of a Physical Model.”,
{“True”, “False “},
{2}}, // Single correct answer
{“Documenting Business Requirements helps developers control the scope of the system and prevents users from claiming that the new system does not meet their business requirements.”,
{“True “, “False”},
{1}}, // Single correct answer
{“A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system.”,
{“True “, “False”},
{1}}, // Single correct answer
{“A subtype is shown on an ERD as an entity with a one to many relationship to the supertype.”,
{“True”, “False “},
{2}}, // Single correct answer
{“All instances of a subtype may be an instance of the supertype but does not have to.”,
{“True”, “False “},
{2}}, // Single correct answer
{“A barred relationship on an ERD signifies that the UID of the intersection entity is inherited from the entities that made up the original many to many relationship.”,
{“True “, “False”},
{1}}, // Single correct answer
{“A subtype can have a relationship not shared by the supertype.”,
{“True “, “False”},
{1}}, // Single correct answer
{“Intersection Entities often have the relationships participating in the UID, so the relationships are often barred.”,
{“True “, “False”},
{1}}, // Single correct answer
Why is it important to identify and document structural rules?”,
{ “Ensures nothing. There are no benefits to be gained from documenting your Structural Business Rules.”,
Ensures we know what data to store and how that data works together.
“We need to concentrate on the Procedural Business Rules only.”,
“Ensures we know what processes are in place and how to program them.”},
{2}}, // Single correct answer
{“All instances of a subtype must be an instance of the supertype.”,
{“True “, “False”},
{1}}, // Single correct answer
{“All instances of the supertype must be an instance of one of the subtypes. True or False?”,
{“True “, “False”},
{2}}, // Single correct answer
{“One Relationship can be mandatory in one direction and optional in the other direction. True or False?”,
{“True “, “False”},
{1}}, // Single correct answer
{“Data modeling is performed for the following reasons: (Choose Two)”,
{“We do not need datamodels; we can just start coding right away.”,
“It helps discussions and reviews. “,
“We draw an ERD solely to please the users; once completed, the ERD is never referred to again as it serves no purpose in the real world.”,
“The ERD becomes a blueprint for designing the actual system. “},
{2, 4}}, // Multiple correct answers
