• Author / Uploaded
• Hadi Wijaya

Citation preview

Test: DFo Section 1 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1 (Answer all questions in this section)

1. In a hierarchical database model the data is stored as records that are connected to one another through ________. Mark for Review

(1) Points databases primary keys fields links (*) Incorrect. Refer to Section 1 Lesson 3. 2. In the relational database model, each table name must be unique. The column names in the table must be unique too. You can have two different tables that have column names that are the same. Mark for Review

(1) Points True (*) False Incorrect. Refer to Section 1 Lesson 3. 3. In a _______ database model the data is organized into a tree-like structure and to retrieve data the whole tree needs to be traversed starting from the root node. Mark for Review

(1) Points Relational Hierarchical (*) Network Object Oriented Correct 4. Which of the following is not a stage in the Database Development Process? Mark for Review

(1) Points Strategy and Analysis Reporting (*) Design

Build Correct 5. A database interacts with the data and provides the following facilities: Mark for Review

(1) Points Retrieving data Inserting data Deleting data All of the above. (*) Correct

Test: DFo Section 1 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1 (Answer all questions in this section)

6. DBMS stands for : Mark for Review

(1) Points Database Memory System Database Management Software Database Manipulation System Database Management System (*) Correct 7. The transformations that have occurred in the computing world progressing in this order: Mark for Review

(1) Points Grid Computing, Desktop Computing, Mainfram Computing, Client/Server Computing Desktop computing, Grid computing, Client/Server computing, Mainframe computing. Mainframe Computing, Desktop Computing, Grid Computing, Client/Server Computing. Mainframe computing, Desktop computing, Client/Server Computing, Grid computing. (*) Correct 8. Select the business or industry that would not have a need for a database. Mark for Review

(1) Points Banking Retail Scientific Research All these businesses could benefit from using a database. (*) Correct 9. If information requirements are clearly communicated during conceptual modeling the following will result: Mark for Review

(1) Points A well designed conceptual model (*) Some business rules may not be taken into account A conceptual model that does not fully reflect the business will be created. Delays due to reworking model caused by incorrect assumptions Incorrect. Refer to Section 1 Lesson 4. 10. Business rules are important because_________. Mark for Review

(1) Points They allow the developer to understand the relationship and constraints of the participating entities (*) They are complex and difficult to understand. They can become outdated quickly. They can all be incorporated into the database design structure. Correct Previous Page 2 of 3 Next 

Test: DFo Section 1 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1 (Answer all questions in this section)

11. Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want. Mark for Review

(1) Points True. Users delay the delivery of a system by changing their minds and adding new requirements. True. The only requirement for creating a perfect system is a perfect programmer.

True. Users never know what they want anyway, so building systems is best left to the professionals. False. Business requirements can and will change. For instance new legal requirements may arise. (*) Correct 12. Business ______ are used to understand business processes, and the nature, role, and scope of the data. Mark for Review

(1) Points Goals Rules (*) Processes Mission Statements Incorrect. Refer to Section 1 Lesson 4. 13. All Business Rules can be modeled. Mark for Review

(1) Points True False (*) Incorrect. Refer to Section 1 Lesson 4. 14. The strategies for learning used in this course include: Mark for Review

(1) Points Instructor led training Industry recognized certification Project driven curriculum All of the above (*) Correct 15. The main subject areas taught by the Oracle Academy are: Mark for Review

(1) Points Data Modeling, SQL, and PL/SQL (*) Database performance tuning Systems programming and computer architecture Computer Repairs Correct Previous Page 3 of 3 

Test: DFo Section 2 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 (Answer all questions in this section)

1. In the relational model, data is organized in a basic storage structure called a ____________. Mark for Review

(1) Points Field Tuples Table (*) Row Correct 2. A _______ is a collection of records. Mark for Review

(1) Points table (*) row field column Incorrect. Refer to Section 2 Lesson 1. 3. In an ERD diagram how is an optional relationship represented ? Mark for Review

(1) Points With a solid line With a dotted line (*) With an arrow With a crows foot Incorrect. Refer to Section 2 Lesson 6. 4. When mapping a relationship for an ERD diagram both sides of the relationship have to be mapped. Mark for Review

(1) Points True (*) False Correct 5. Which of the following statements about entity relationship diagrams (ERD) is true? Mark for Review

(1) Points Used to communicate the logical structure of the database to users. (*)

Used to communicate the technical specifications of the database to users Used to communicate the physical structure of the database to users. Is a hard and fast document that cannot be changed once development of the database has begun. Correct Page 1 of 3 Next 

Test: DFo Section 2 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 (Answer all questions in this section)

6. What is the purpose of a Unique Identifier? Mark for Review

(1) Points To identify one unique instance of an entity by using one or more attributes and/or relationships. (*) To identify a specific row within a table, using one or more columns and/or foreign keys. To uniquely determine a table and columns within that table. Create an entity that is unlike any other entity aside from itself. Correct 7. All entities must be given a new artificial UID. True or False? Mark for Review

(1) Points True False (*) Incorrect. Refer to Section 2 Lesson 4. 8. Matrix Diagrams are used to verify that all ____________ have been identified for an ERD. Mark for Review

(1) Points entities relationships (*) keys attributes Correct 9. In an ERD, optionality is depicted using __________. Mark for Review

(1) Points

single toe or crows foot solid or dashed lines (*) names of relationships soft boxes Incorrect. Refer to Section 2 Lesson 5. 10. The optionality of a relationship must be either _______ or _______. Mark for Review

(1) Points One or (One or More) Single or Multiple Bidirectional or a single direction Mandatory or Optional (*) Correct Previous Page 2 of 3 Next 

Test: DFo Section 2 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 (Answer all questions in this section)

11. The logical model becomes the blueprint for designing the ________ model Mark for Review

(1) Points Physical (*) Network Data Integrity Data Flow Correct 12. The logical model's entities, attributes, unique identifiers and relationships map to the physical model's _________________. Mark for Review

(1) Points Optionality and Cardinality Files, records, fields and data values Tables, columns, primary keys and foreign keys (*) Correct 13. Entities are usually _____________. Mark for Review

(1) Points

Nouns (*) Verbs Adjectives Adverbs Incorrect. Refer to Section 2 Lesson 3. 14. Which of the following entities most likely contains invalid attributes? Mark for Review

(1) Points Entity: Pet. Attributes: Name, Birthdate, Owner Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of Children Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed(*) Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built Correct 15. Which symbol is used to show that a particular attribute is mandatory? Mark for Review

(1) Points # * (*) & o Incorrect. Refer to Section 2 Lesson 3. Previous Page 3 of 3 

Test: DFo Section 2 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 (Answer all questions in this section)

1. Which of the following statements about attributes are true? (Choose Two) Mark for Review

(1) Points They must be single valued unless they belong to more than one entity. They describe, qualify, quantify, classify, or specify an entity. (*) They are the primary container for data. They are often adjectives.(*)

Incorrect. Refer to Section 2 Lesson 3.

2. When creating entities in a logical model you must follow these rules: (Choose Two) Mark for Review

(1) Points Include Attributes(*) Name them in Plural Exclude Attributes

Name them in Singular(*)

Incorrect. Refer to Section 2 Lesson 3. 3. An entity may have which of the following? Mark for Review

(1) Points Experiences Instances (*) Tables None of the above Correct 4. Which of the following statements is true regarding ImplementationFree logical models? Mark for Review

(1) Points The model changes depending on operating system that is being used. The model stays the same regardless of the DBMS or operating system used. (*) The model changes depending on the relational database software being used The model does not need to implemented on a DBMS. Incorrect. Refer to Section 2 Lesson 6. 5. When mapping a relationship for an ERD diagram both sides of the relationship have to be mapped. Mark for Review

(1) Points True (*) False Correct

Test: DFo Section 2 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2

(Answer all questions in this section)

6. Which of the following is not a goal of ER modeling: Mark for Review

(1) Points Locate information in a logical manner Ensure information appears only once. It is acceptable to include information that is derivable. (*) Capture all required information. Incorrect. Refer to Section 2 Lesson 6. 7. Which of the following would be good as a Unique Identifier for its Entity? (Choose Three) Mark for Review

(1) Points Vehicle Registration Number for Car(*) ISBN Number for Book(*) Personal Identification number for Person(*) Date of birth for Baby

Incorrect. Refer to Section 2 Lesson 4. 8. Primary UIDs are: Mark for Review

(1) Points Useful as an alternative means of identifying instances of an entity, independent of their datatype Always comprised of numbers Optional in data modeling. Mandatory in data modeling (*) Incorrect. Refer to Section 2 Lesson 4. 9. A _______ is a collection of records. Mark for Review

(1) Points column row field table (*) Correct 10. What does single table refer to? (Choose Two) Mark for Review

(1) Points A type of database storage method where all of the data elements are stored on top of each other. A database where all of the data is stored in one large table. (*) A fully-relational database system like Microsoft's SQL Server or Oracle's database systems.

Non-relational systems that typically store each table and index in separate files and often do not support the SQL language.(*)

Incorrect. Refer to Section 2 Lesson 1. Previous Page 2 of 3 Next 

Test: DFo Section 2 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 (Answer all questions in this section)

11. Which of the following are reasons we create conceptual models? Mark for Review

(1) Points 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 (*) Correct 12. The logical model determines relationship optionality and cardinality Mark for Review

(1) Points True (*) False Correct 13. The optionality of a relationship must be either _______ or _______. Mark for Review

(1) Points Single or Multiple Mandatory or Optional (*) One or (One or More) Bidirectional or a single direction Correct 14. Which of the following is NOT a relationship type? Mark for Review

(1) Points One to One One to Many Many to Many Some to None (*)

Correct 15. A __________ relationship is a relationship between an entity and itself. Mark for Review

(1) Points Recursive (*) One to one Mandatory Hierarchical Correct Previous Page 3 of 3 

Test: DFo Section 2 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 (Answer all questions in this section)

1. Which symbol is used to show that a particular attribute is optional? Mark for Review

(1) Points o (*) & * # Correct 2. Attributes have Instances. True or False? Mark for Review

(1) Points True False (*) Incorrect. Refer to Section 2 Lesson 3. 3. Entities are usually _____________. Mark for Review

(1) Points Verbs Adjectives Adverbs Nouns (*) Correct

4. A candidate UID that does not get chosen to become the primary UID is called a _________ . Mark for Review

(1) Points Secondary UID (*) Primary UID Composite UID Unique UID Incorrect. Refer to Section 2 Lesson 4. 5. What is the purpose of a Unique Identifier? Mark for Review

(1) Points 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. (*) To identify a specific row within a table, using one or more columns and/or foreign keys. To uniquely determine a table and columns within that table. Correct Page 1 of 3 Next 

Test: DFo Section 2 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 (Answer all questions in this section)

6. Data Integrity ensures ______ in the information. Mark for Review

(1) Points duplication anomalies no duplication (*) errors Incorrect. Refer to Section 2 Lesson 1. 7. Flat file databases avoids data duplication. True or False? Mark for Review

(1) Points True False (*) Correct

8. A conceptual model includes : Mark for Review

(1) Points Only Entities and Relationships (*) Only Entities, Attributes and Unique Identifiers Only Entities, Attributes and Relationships Entities, Attributes, Unique Identifiers and Relationships Incorrect. Refer to Section 2 Lesson 2. 9. In a relational database system, the next step after creating a conceptual data model is to convert it to a _________ . Mark for Review

(1) Points An entity-relation data model External data model Internal data model Logical data model (*) Correct 10. Data models are drawn to show users the actual Data that their new system will contain; only Data listed on the Diagram can be entered into the Database. True or False? Mark for Review

(1) Points True False (*) Incorrect. Refer to Section 2 Lesson 6. Previous Page 2 of 3 Next 

Test: DFo Section 2 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 (Answer all questions in this section)

11. The __________ model includes entities, attributes, UIDs, relationships as well as optionality and cardinality of these items. Mark for Review

(1) Points Physical Hierarchical Conceptual Logical (*) Incorrect. Refer to Section 2 Lesson 6.

12. ERDish is a language used to create database structures in SQL Mark for Review

(1) Points True False (*) Incorrect. Refer to Section 2 Lesson 5. 13. The components of a relationship include all of the following except : Mark for Review

(1) Points Cardinality Relational Integrity (*) Names Optionality Incorrect. Refer to Section 2 Lesson 5. 14. The cardinality of a relationship can be _____________. (Choose two) Mark for Review

(1) Points one to one

one or more(*) many to many one and only one(*)

Incorrect. Refer to Section 2 Lesson 5. 15. One-to-Many relationships have cardinality of one or more in both directions. True or False? Mark for Review

(1) Points True False (*) Incorrect. Refer to Section 2 Lesson 5. Previous Page 3 of 3 

Test: DFo Section 2 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 (Answer all questions in this section)

1. A relational database stores information in tables with rows and columns. Mark for Review

(1) Points True (*) False Correct 2. Flat file databases avoids data duplication. True or False? Mark for Review

(1) Points True False (*) Correct 3. When mapping a relationship for an ERD relationship names must be included. Mark for Review

(1) Points True (*) False Correct 4. Which of the following is not a goal of ER modeling: Mark for Review

(1) Points Capture all required information. It is acceptable to include information that is derivable. (*) Ensure information appears only once. Locate information in a logical manner Incorrect. Refer to Section 2 Lesson 6. 5. Using ERDish, which wording represents cardinality? (Choose Two) Mark for Review

(1) Points one only

one or more(*) one and only one(*) one or multiple

Incorrect. Refer to Section 2 Lesson 6. Page 1 of 3 Next 

Test: DFo Section 2 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 (Answer all questions in this section)

6. 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. Mark for Review

(1) Points Attribute (*) ERD Table Process Incorrect. Refer to Section 2 Lesson 3. 7. Which of the attributes is a volatile attribute? Mark for Review

(1) Points Age (*) Race Eye color Date of birth Correct 8. When creating entities in a logical model you must follow these rules: (Choose Two) Mark for Review

(1) Points Include Attributes(*) Exclude Attributes Name them in Singular(*) Name them in Plural

Correct

9. The optionality of a relationship must be either _______ or _______. Mark for Review

(1) Points One or (One or More) Single or Multiple Bidirectional or a single direction Mandatory or Optional (*) Correct 10. In a relationship , _________ are used to helped describe the meaning of the connection between the entities. Mark for Review

(1) Points names (*) descriptions

arrows crows feet Correct Previous Page 2 of 3 Next 

Test: DFo Section 2 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 (Answer all questions in this section)

11. The components of a relationship include all of the following except : Mark for Review

(1) Points Optionality Relational Integrity (*) Names Cardinality Correct 12. The physical model shows all table structures. True or False. Mark for Review

(1) Points True (*) False Correct 13. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. Mark for Review

(1) Points They capture the data values. They accurately describe what a physical model will contain. (*) They capture the implementation details of the physical model. They capture current and future needs.(*)

They model functional and informational needs. (*)

Incorrect. Refer to Section 2 Lesson 2.

14. All entities must be given a new artificial UID. True or False? Mark for Review

(1) Points True False (*) Correct

15. The candidate UID that is chosen to identify an entity is called the Primary UID; other candidate UIDs are called Secondary UIDs. Mark for Review

(1) Points No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc. No, each Entity can only have one UID, the secondary one. No, it is not possible to have more than one UID for an Entity. Yes, this is the way UID's are named. (*) Incorrect. Refer to Section 2 Lesson 4. Previous Page 3 of 3 

Test: DFo Section 3 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 3 (Answer all questions in this section)

1. Until all attributes are single-valued, the database model is said to be: Mark for Review

(1) Points Normalized in 1st Normal Form in 2nd Normal Form Not Normalized (*) Incorrect. Refer to Section 3 Lesson 3. 2. Would it be a good idea to model age as an attribute of STUDENT? Mark for Review

(1) Points Yes, it would prevent our having to calculate someone's age every time we need it. Sometimes, but not all of the time Yes No - it is a volatile attribute (*) Correct 3. Sources of business rules include all of the following except: Mark for Review

(1) Points Procedures Word of mouth (*) Operational manuals Standards

Correct 4. Can all constraints be modeled on an ER diagram? Mark for Review

(1) Points No, but you just explain them to the users so they can enforce them Yes, all constraints must be modeled and shown on the ER diagram No, and those that cannot be modeled should be listed on a separate document to be handled programmatically (*) No, in which case you should let the database administrator handle them Incorrect. Refer to Section 3 Lesson 3. 5. Business rules are important to data modelers. True or False? Mark for Review

(1) Points True (*) False Correct Page 1 of 3 Next 

Test: DFo Section 3 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 3 (Answer all questions in this section)

6. All instances of the supertype _____ be an instance of one of the subtypes. Mark for Review

(1) Points cannot must (*) may will sometimes Correct 7. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review

(1) Points True False (*) Correct

8. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review

(1) Points Transferable Non-Transferable (*) Mandatory Optional Correct 9. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review

(1) Points TEACHER and SUBJECT AREA (*) CAR and WHEEL TREE and BRANCH PERSON and FINGERPRINT Correct 10. A recursive relationship has cardinality of ___________. Mark for Review

(1) Points Many to Many One to One Cannot be determined without more information. (*) One to Many Incorrect. Refer to Section 3 Lesson 1. Previous Page 2 of 3 Next 

Test: DFo Section 3 Quiz Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 3 (Answer all questions in this section)

11. Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review

(1) Points Daily traffic patterns must be monitored to determine how many law enforcement officers are needed. If you are doing a system for any French City, you would need security clearance.

Cites may change their names and/or country association if the borders of a country change. (*) People are born in the city and people die in the city. Incorrect. Refer to Section 3 Lesson 2. 12. Modeling historical data is optional. True or False? Mark for Review

(1) Points True (*) False Incorrect. Refer to Section 3 Lesson 2. 13. Attribute names are converted to column names by _________________. Mark for Review

(1) Points Replacing numbers with letters. Replacing spaces with underscores. (*) Replacing underscores with dashes. Replacing periods with commas. Correct 14. Table names can contain all of the following except: Mark for Review

(1) Points Letters Numbers Some special characters Spaces (*) Correct 15. When mapping entities containing supertypes and subtypes a _________ table implementation is used when most of the attributes and relationships are shared at the supertype level. Mark for Review

(1) Points many to many multiple-table two-table single-table (*) Incorrect. Refer to Section 3 Lesson 4. Previous Page 3 of 3