Section 2 Oracle Quiz

Test: Quiz: Conceptual and Physical Models
1. Examples of software are:

• Data entry webpages, Spreadsheets, Google and Yahoo search Engines, SQL Developer, Oracle Application Express (*)
• Microsoft Word, Microsoft Powerpoint, Microsoft Excel, Mouse pad
• Mouse, Cables, Microsoft Word, Microsoft Powerpoint
• Monitor, Microsoft Word, Microsoft PowerPoint, SQL Developer

2. Examples of hardware are:

• Data entry web pages, Mouse, Hard disk
• Mouse, Hard disk, Monitor (*)
• Monitor, Mouse, Printer, Printed Reports
• Monitor, Mouse, Mouse pad, Cables and Wires, Hard disk

3. Which of the following are reasons we create conceptual models?

• It facilitates discussion. A picture is worth a thousand words.
• It forms important ideal system documentation.
• It takes into account government regulations and laws
• It forms a sound basis for physical database design
• All of the above. (*)

Test: Quiz: Entities, Instances, Attributes and Identifiers

1. Which of the following statements about attributes are true?

• They describe, qualify, quantify, classify, or specify an entity. (*)
• They are often adjectives.
• They have a data type such as a number or character string. (*)
• They must be single valued unless they belong to more than one entity.

2. All of the following would be instances of the entity PERSON except which?

• David Jones
• Male (*)
• Angelina Rosalie
• Grace Abinajam

3. Some of the following could be attributes of an ENTITY called PERSON. Select the incorrect attributes for PERSON.

• Age
• Freddy Wilson (*)
• Name
• Priya Hansenna (*)

4. Entities are usually verbs. True or False?

• True
• False (*)

5. A/an _________ is a piece of information that in some way describes an entity. It is a property of the entity and it quantifies, qualifies, classifies or specifies the entity.

• ERD
• Process
• Table
• Attribute (*)

6. Unique Identifiers…

• distinguish one entity from another
• distinguish one instance of an entity from all other instances of that entity (*)
• distinguish all entities in a database
• distinguishes nothing

7. An entity may have which of the following?

• experiences
• instances (*)
• tables
• none of the above

8. What is the purpose of a Unique Identifier?

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

9. In a physical data model, an attribute is represented as a/an

• Column (*)
• Row
• Instance
• Foreign Key

10. The word “Volatile” means…

• Changing constantly; unstable (*)
• Static; unlikely to change
• Large quantity
• Limited quantity

11. Which of the following entities most likely contains invalid attributes?

• Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built
• Entity: Pet. Attributes: Name, Birthdate, Owner
• Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed (*)
• Entity: Mother. Attributes: Name, Birthdate, Occupation, Salary

12. In the following statements, find two examples of ENTITY: Instance.

• DAIRY PRODUCT: cow (*)
• VEGETABLE: grows
• BOOK: Biography of Mahatma Gandhi (*)
• BODY PART: Marilyn Manson

Test: Quiz: Entity Relationship Modeling and ERDs

1. The purpose of an ERD is to document the proposed system and facilitate discussion and understanding of the requirements captured by the developer. True or False?

• True (*)
• False

2. A well structured ERD will show only some parts of the finished data model. You should never try to model the entire system in one diagram, no matter how small the diagram might be. True or False?

• True
• False (*)

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

• True (*)
• False

4. Which of the following statements are true about ERD’s?

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