Section 4 Oracle Quiz

Test: Quiz: Supertypes and Subtypes

1. A supertype should have at least two subtypes. True or False?

• True (*)
• False

2. Which of the following is a TRUE statement about the diagram below?

• Every Z is either an A or a B
• Every B is a Z
• Every A is a Z
• Every A is a B (*)

3. All instances of the subtypes must be an instance of the supertype. True or False?

• True (*)
• False

4. A subtype can have a relationship not shared by the supertype. True or False?

• True (*)
• False

5. Which of the following are valid formats for an attribute?

• Character string (*)
• Decimal
• Number (*)
• HEX

6. All instances of the supertype are also instances of one of the subtypes. True or False?

• True (*)
• False

7. The “Other” subtype is best used:

• For instances that belong to the supertype and at least one other subtype.
• For a subtype that does not have any of the same attributes as the supertype to which it belongs.
• As an extra subtype to ensure that all instances of subtypes are mutually exclusive and complete. By having an “Other” subtype, all instances of the Supertype will be of one subtype type. (*)
• You should never have a subtype called Other.

8. Which of the following is the best scenario for using supertype/subtype entities:

• A pet store that sells small animals, because they each need different size cages and food.
• An ice cream store that sells ice cream in sugar cones and regular cones.
• A grocery store that gives customers a choice of plastic or paper bags.
• A vehicle dealership that sells cars, trucks and boats on trailers. (*)

9. When creating entities it is important to remember all of the following:

• Create a formal description. (*)
• Include attributes. (*)
• Do not use synonyms.
• Do use reserved words.

10. Which of the following is true about supertypes and subtypes?

• Instances that belong to two subtypes of the same supertype may be modeled as a one-to-one relationship between the two subtypes
• Subtypes inherit the relationships and attributes of the supertype (*)
• Subtypes may have no more than 2 levels of nesting
• Supertype and subtype entities must be mutually exclusive

Test: Quiz: Documenting Business Rules

1. How would you model a business rule that states that on a studentﾒs birthday, they do not have to attend their classes?

• Use a supertype
• Use a subtype
• Make the attribute Birthdate mandatory
• You cannot model this. You need to document it (*)

2. Why is it important to identify and document business rules?

• It allows you to create your data model, then check for accuracy. (*)
• It allows you to improve the client’s business.
• It ensures that the data model will automate all manual processes.
• None of the above

3. How should you handle constraints that cannot be modeled on an ER diagram?

• Always let the network architect handle them
• List them on a separate document to be handled programmatically (*)
• Explain them to the users so they can enforce them
• All constraints must be modeled and shown on the ER diagram

4. Which of the following is an example of a structural business rule?

• All employees must belong to at least one department. (*)
• Buildings to be purchased by the business must be current with earthquake building code.
• All overdue payments will have an added 10 % late fee.
• All products will have a selling price no less than 30 % greater than wholesale.

5. A business rule such as “All accounts must be paid in full within 10 days of billing” is best enforced by:

• Making the payment attribute mandatory.
• Making the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both sides.
• Creating a message to be printed on every bill that reminds the customer to pay within ten days.
• Hiring a programmer to create additional programming code to identify and report accounts past due. (*)

6. Business rules are important to data modelers because:

• A. They capture all of the needs, processes and required functionality of the business. (*)
• B. They are easily implemented in the ERD diagram.
• C. The data modeler must focus on structural rules, because they are easily represented diagrammatically and eliminate other rules that involve extra procedures or programming.
• D. Both A and C are true.

7. Only managers can approve travel requests is an example of which of the following?

• A structural business rule.
• A mandatory business rule.
• A procedural business rule. (*)
• An optional business rule.

Section 3 Oracle Quiz

Test: Quiz: Identifying Relationships

1. What are the three properties that every relationship should have?

• Transferability, degree, name
• Name, optionality, degree (*)
• A UID bar, a diamond, an arc
• Name, optionality, arcs

2. Relationships can be either mandatory or optional. True or False?

• True (*)
• False

3. In a business that sells computers, choose the best relationship name from CUSTOMER to ITEM (computer, in this case).

• Each CUSTOMER must be the buyer of one or more ITEMS. (*)
• Each CUSTOMER must be the seller of one or more ITEMS.
• Each CUSTOMER may be the maker of one or more ITEMS.
• Each CUSTOMER may be the producer of one or more ITEMS.

4. Relationships always exist between

• 3 or more entities
• 2 entities (or one entity twice)  (*)
• 2 attributes
• 3 or more attributes

Test: Quiz: ER Diagramming

1. Attributes are written inside the entity to which they belong. True or False?

• True (*)
• False

2. Entity boxes are drawn as

• Soft Boxes (*)
• Hard Boxes
• Bold Circles
• Normal Circles

3. Entity names are always plural. True or False?

• True
• False (*)

4. Which symbol is used to indicate that a particular attribute is optional?

• *
• o  (*)
• #
• &

5. On an ER diagram which symbol identifies an attribute as part of a unique identifier.

• #  (*)
• *
• o
• x

6. Consider the recommended drawing conventions for ERD’s. Indicate which of the following accurately describes diagramming conventions for entities and attributes:

• The * means that an attribute is optional and entity names should be plural verbs
• The ‘o’ means that the attribute is optional and entity names should be plural verbs
• The * means that an attribute is mandatory or required and the entity name should be singular  (*)
• The ‘o’ means that the attribute is mandatory or required and the entity name should be a singular noun

Test: Quiz: Speaking ERDish and Drawing Relationships

1. Two entities can have one or more relationships between them. True or False?

• True (*)
• False

2. After looking at the diagram, choose the sentence below that could be “read” from the existing relationship (even though you’re missing relationship labels!)

• Each Student must have one or more Activities.
• Each Activity may be performed by one or more Students.
• Each Student may participate in one or more Activities. (*)
• Each Activity must belong to one and only one Student.

3. When reading a relationship between 2 entities, the relationship is only read from left to right. True or False?

• True
• False (*)

Test: Quiz: Matrix Diagrams

1. A Matrix Diagram will help you with all of the following except:

• Defining Relationships Between Entities
• Identifying Entities
• Defining Instances of Entities (*)
• Naming Relationships

2. Matrix Diagrams helps verify you have identified all possible relationships between your existing entities. True or False?

• True (*)
• False

3. Creating a Matrix Diagram is mandatory when doing Data Modeling. True or False?

• True
• False (*)

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.

Section 1 Oracle Quiz

Test: Quiz: Introduction to The Oracle Academy

1. There is a big increase in demand for Information Technology professionals in today’s market. True or False?

• True (*)
• False

2. Why is it important to identify the business requirements before beginning to program a new system?

• It is not important to have a blueprint for database design and programs. You should just start coding as soon as possible, so you can meet your deadlines.
• It clarifies what a business wants to accomplish, so that you can get your database design and coding started correctly.(*)
• It allows application development to be conducted without having to consider database design.
• It keeps businesses honest.

3. What are the major content areas covered in the Oracle Academy?

• Database programming and Computer repair.
• Database configuration and performance tuning.
• Data Modeling, SQL, and PL/SQL (*)
• Data Modeling, PJava and C+

Test: Quiz: Data vs Information

1. How do you turn “data” into “information”

• By testing it
• By querying it or accessing it (*)
• By storing it on a server
• By storing it in a database

2. Which of the following are examples of data vs. information.

• A. Student age vs. average age of all students in class
• B. Bank deposit amount vs. total account balance
• C. Winning time for a race vs. length of race
• D. Price of computer vs. total sales of all computers for a company
• E. Both A and B (*)

3. Consider an example where an Oracle database works “behind the scenes” for common internet activity. Which of the following best describes a database transaction?

• A person searching an airline website to find all available fares for a flight.(*)
• A business identifies what processes it uses for purchasing inventory.
• A student places a link to their homepage from the school’s website.
• A person looking in the newspaper for good internet sites.

4. What are the results of having all your data in one central location?

• Improved performance (*)
• Easier access to data (*)
• Updates are harder to execute
• Decreased performance

Test: Quiz: History of the Database

1. Oracle was one of the first relational database systems available commercially? True or False?

• True (*)
• False

2. Which of the following is the correct order for the Database Development Process?

• Strategy, Analysis, Design, Build (*)
• Analysis, Strategy, Design, Build
• Build, Strategy, Analysis, Design
• Design, Build, Strategy, Analysis

3. Data Modeling is the last stage in the development of a database. True or False?

• True
• False (*)

Test: Quiz: Major Transformations in Computing

1. Personal computers (PCs) have been in existence since 1950. True or False?

• True
• False (*)

2. Which of the following is NOT a type of database?

• Hierarchical
• Relational
• SQL (*)
• Network

3. Databases function more efficiently as:

• Multiple applications on multiple client-servers
• Integrated software on fast processing servers (*)
• Client-based software on client-servers
• Client-based software on personal computers

4. Users would use which of the following software to access essential business applications?

• GUI Interface (*)
• Internet Browser (*)
• Server
• Operating System (*)

5. In the grid computing model, resources are pooled together for efficiency. True or False?

• True (*)
• False