Quiz Database Section 3 in ORACLE

1.Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below.
Mark for Review(Choose all correct answers)

They model functional and informational needs. (*)
They capture current and future needs. (*)
They capture the implementation details of the physical model.
They model the information flow of data.
They accurately describe what a physical model will contain. (*)

2.Data models show users the data that their Physical Model will contain. True or False?

True (*)
False

3. Data modeling is performed for the following reasons: (Choose Two)
     (Choose all correct answers)

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.
We do not need datamodels; we can just start coding right away.
The ERD becomes a blueprint for designing the actual system. (*)

4.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 or False?

True (*)
False

5.A/an _________'s value can be a number, a character string, a date, an image, a sound

Table
Attribute (*)
ERD
Entity

6.Unique Identifiers:

They have a data type, such as number or character string. (*)
They are often adjectives.
They describe, qualify, quantify, classify, or specify an entity. (*)
They must be single valued. (*)

8.Entities are usually verbs. True or False?
 
True
False (*)

9.All of the following could be attributes of an ENTITY called PERSON, except which one?

    Gender
Natacha Hansen (*)
Weight
Haircolor

10.Which of the following are examples of ENTITY: Instance ? (Choose Two)
 
    ANIMAL: Dog (*)
MEAT PRODUCT: Lettuce
TRANSPORTATION METHOD: Car (*)
BODY PART: Larry Ellison

11.Which of the following entities most likely contains valid attributes? (Choose two)
 
Entity: Mother. Attributes: Name, Birthdate, Occupation, Start Date
Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed
Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built (*)
Entity: Pet. Attributes: Name, Birthdate, Owner (*)

12.What is the purpose of a Unique Identifier?
 
    To identify a specific row within a table, using one or more columns and/or foreign keys.
To identify one unique instance of an entity by using one or more attributes and/or relationships. (*)
To uniquely determine a table and columns within that table.
Create an entity that is unlike any other entity aside from itself.

13.Entity Relationship modeling is dependent on the hardware or software used for implementation, so you will need to change your ERD if you decide to change Hardware Vendor. True or False?
   
True
False (*)

14.Which of the following statements are true about ERD's? (Choose Two)

    All data must be represented on the ERD, including derived summaries and the result of calculations.
A piece of information can be shown multiple times on an ERD.
A piece of information should only be found in one place on an ERD. (*)
You should not model derivable data. (*)

15.An Entity Relationship model is independent of the hardware or software used for implementation. True or False?

True (*)
False