Quiz 1-3 Tiger [PDF]

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. Using a database solution instead of a flat file eliminates all of the following issues except: Mark for Review



(1) Points Incorrect data (*) Data entry anomalies Inconsistency Redundancy Correct 2. If information requirements are clearly communicated during conceptual modeling the following will result: Mark for Review



(1) Points Delays due to reworking model caused by incorrect assumptions A well designed conceptual model (*) A conceptual model that does not fully reflect the business will be created. Some business rules may not be taken into account Correct 3. 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? Mark for Review



(1) Points True (*)



False Correct 4. When completing the conceptual modeling process we must take into account the following: Mark for Review



(1) Points Business Rules Assumptions Problems All of the above (*) Correct 5. Business rules help you understand the standardization procedure an organization follows when handling huge data. Mark for Review



(1) Points True (*) False Correct Page 1 of 3 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. Information is the result of combining, comparing and performing calculations on data. Mark for Review



(1) Points True (*) False



Correct 7. 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 8. What is the difference between "information" and "data"? Mark for Review



(1) Points Data is held and understood only by users. Information and data have no differences - they are two words for the same thing. Data turns into useful information. It is stored in a database and accessed by systems and users. (*) Information is held and understood only by users. Correct 9. Which transformation in computing allows for storage and delivery of applications and data over the internet? Mark for Review



(1) Points Grid Computing Mainframe computing Desktop computing Cloud Computing (*) Correct 10. SQL *Plus is being used in the Oracle Academy courses to run SQL code. True or False? Mark for Review



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



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. The technical software requirements for this course include all of the following except: Mark for Review



(1) Points Oracle SQL Developer Data Modeler Microsoft Access (*) Oracle APEX application All are requirements. Correct 12. A flat file may contain many fields, often, with duplicate data that are prone to data corruption. Mark for Review



(1) Points True (*) False Correct 13. A ___________ model describes a database in terms of tables, columns, and joins between tables.



Mark for Review



(1) Points Network Object Oriented Relational (*) Hierarchical Correct 14. 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 Object Oriented Relational Network Hierarchical (*) Correct 15. A network database comprises of a collection of records connected to one another through links. Mark for Review



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



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. Which one of the following is not a goal of this course: Mark for Review



(1) Points Describing the purpose of a relational database. Describing key business requirements of a database. Database performance tuning. (*) Using data modeling to build a database. Correct



5. Which is the first step in the Database Development Process ? Mark for Review



(1) Points Build Design Testing Strategy and Analysis (*) Correct Page 1 of 3



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. In a hierarchical database model the data is stored as records that are connected to one another through ________. Mark for Review



(1) Points links (*) fields databases primary keys Incorrect. Refer to Section 1 Lesson 3.



9. Business rules are important because_________. Mark for Review



(1) Points They can become outdated quickly. They can all be incorporated into the database design structure. They allow the developer to understand the relationship and constraints of the participating entities (*) They are complex and difficult to understand. Correct 10. The reason or drive for using databases rather than files has been … (Choose 3) Mark for Review



(1) Points Use of blocks



Integration of data for easier access and modification for complex transactions (*) Availability of data to a diverse set of users (*) Reduced redundancy of data (*)



Correct



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. 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. True. Users delay the delivery of a system by changing their minds and adding new requirements. False. Business requirements can and will change. For instance new legal requirements may arise. (*) Correct 12. Today, all industries have a need for database systems. True or False? Mark for Review



(1) Points True (*) False Correct



2. The transformations that have occurred in the computing world progressing in this order: Mark for Review



(1) Points Mainframe computing, Desktop computing, Client/Server Computing, Grid computing. (*) Desktop computing, Grid computing, Client/Server computing, Mainframe computing. Mainframe Computing, Desktop Computing, Grid Computing, Client/Server Computing.



Grid Computing, Desktop Computing, Mainfram Computing, Client/Server Computing Correct 3. DBMS stands for : Mark for Review



(1) Points Database Management System (*) Database Management Software Database Manipulation System Database Memory System Correct 4. Select the business or industry that would not have a need for a database.SQLPlus



Mark for Review



(1) Points Banking Retail Scientific Research All these businesses could benefit from using a database. (*) Correct 5. 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



7. 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 Hierarchical (*) Relational Network Object Oriented Correct 9. 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 Correct



Page 2 of 3 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) 12. Using a database solution instead of a flat file eliminates all of the following issues except: Mark for Review



(1) Points Data entry anomalies Redundancy



Incorrect data (*) Inconsistency Correct 13. 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? Mark for Review



(1) Points True (*) False Correct 14. Business rules help you understand the standardization procedure an organization follows when handling huge data. Mark for Review



(1) Points True (*) False Correct 15. All Business Rules can be modeled. Mark for Review



(1) Points True False (*) Incorrect. Refer to Section 1 Lesson 4. Page 3 of 3 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 _______ 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 Object Oriented Relational Network Hierarchical (*) Correct 2. A ___________ model describes a database in terms of tables, columns, and joins between tables. Mark for Review



(1) Points Network Hierarchical Relational (*) Object Oriented Correct 4. 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 Correct



6. Which of the following transformations in computing led to the increase in graphical user interface (GUI) applications?



Mark for Review



(1) Points Grid Computing Desktop computing (*) Client/Server Computing Mainframe computing Correct 7. A DBMS comprises of the following elements: (Choose 3) Mark for Review



(1) Points Memory and Storage Management (*) Data Dictionary (*) Client



Query language (*) Correct



9. Which one of the following is not a goal of this course: Mark for Review



(1) Points Describing the purpose of a relational database. Describing key business requirements of a database. Database performance tuning. (*) Using data modeling to build a database. Correct



10. The main subject areas taught by the Oracle Academy are: Mark for Review



(1) Points Systems programming and computer architecture Data Modeling, SQL, and PL/SQL (*) Computer Repairs Database performance tuning Correct Page 2 of 3 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)



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



(1) Points True (*) False Correct 13. Business ______ are used to understand business processes, and the nature, role, and scope of the data. Mark for Review



(1) Points Mission Statements



Rules (*) Goals Processes Correct 14. Using a database solution instead of a flat file eliminates all of the following issues except: Mark for Review



(1) Points Redundancy Inconsistency Data entry anomalies Incorrect data (*) Correct



3. Using a database solution instead of a flat file eliminates all of the following issues except: Mark for Review



(1) Points Incorrect data (*) Data entry anomalies Redundancy Inconsistency Incorrect. Refer to Section 1 Lesson 4.



6. The technical software requirements for this course include all of the following except: Mark for Review



(1) Points Oracle SQL Developer Data Modeler Microsoft Access (*) Oracle APEX application



All are requirements. Correct 9. Which of the following transformations in computing led to the increase in graphical user interface (GUI) applications? Mark for Review



(1) Points Mainframe computing Client/Server Computing Desktop computing (*) Grid Computing Correct 12. A flat file may contain many fields, often, with duplicate data that are prone to data corruption. Mark for Review



(1) Points True (*) False Correct 13. The advantages of an object-oriented data model are: Mark for Review



(1) Points Reduced Maintenance Real-World Modeling Both A and B. (*) Neither A or B. Correct 15. A network database comprises of a collection of records connected to one another through links. Mark for Review



(1) Points True (*) False Correct 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. When mapping a relationship for an ERD relationship names must be included. Mark for Review



(1) Points True (*) False Correct 2. Which of the following statements is true regarding Implementation-Free logical models? Mark for Review



(1) Points The model changes depending on operating system that is being used. The model does not need to implemented on a DBMS. The model changes depending on the relational database software being used The model stays the same regardless of the DBMS or operating system used. (*) Incorrect. Refer to Section 2 Lesson 6. 3. 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



Correct 4. A conceptual model includes : Mark for Review



(1) Points Only Entities, Attributes and Unique Identifiers Only Entities, Attributes and Relationships Only Entities and Relationships (*) Entities, Attributes, Unique Identifiers and Relationships Incorrect. Refer to Section 2 Lesson 2. 5. 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 Page 1 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) 6. In the relational model, relationships between relations or tables are created by using? Mark for Review



(1) Points Foreign Keys (*) Primary Keys Composite Keys Candidate Keys Correct 7. A row is called a record. Mark for Review



(1) Points True (*) False Correct 8. Which symbol is used to show that a particular attribute is mandatory? Mark for Review



(1) Points # o * (*) & Correct 9. Attributes that can be divided into smaller subparts are called________________.



Mark for Review



(1) Points Volatile Attribute Single Attribute Mandatory Attribute Composite Attribute (*) Correct 10. Entity Boxes are drawn on an ERD using what type of shape? Mark for Review



(1) Points Hard Boxes Rectangles Diamonds Soft Boxes (*) Incorrect. Refer to Section 2 Lesson 3. Page 2 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) 11. A unique identifier made up of more than one attribute is called a __________. Mark for Review



(1) Points Unique UID Foreign UID Candidate UID



Composite UID (*) Incorrect. Refer to Section 2 Lesson 4. 12. Candidate UIDs must be made up of only one attribute. Mark for Review



(1) Points True False (*) Incorrect. Refer to Section 2 Lesson 4. 13. A __________ relationship is a relationship between an entity and itself. Mark for Review



(1) Points Hierarchical One to one Recursive (*) Mandatory Correct 14. A foreign key is a column or combination of columns in one table that uniquely identifies a row of another table. Mark for Review



(1) Points True (*) False Correct 15. Which of the following are true about Cardinality? (Choose two) Mark for Review



(1) Points Cardinality specifies only singularity or plurality, but not a specific plural number.



(*) Cardinality specifies whether something is required or not.



Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.



Cardinality tells "how many". (*) Incorrect. Refer to Section 2 Lesson 5. 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 are suitable Entity names? (Choose Two) Mark for Review



(1) Points DOGS



ANIMAL (*) DOG (*) ANIMALS



Incorrect. Refer to Section 2 Lesson 3. 2. Entity names are always singular. True or False? Mark for Review



(1) Points True (*) False Incorrect. Refer to Section 2 Lesson 3. 3. Which of the attributes is a volatile attribute? Mark for Review



(1) Points Eye color Date of birth Race Age (*) Correct 4. Flat file databases avoids data duplication. True or False? Mark for Review



(1) Points True False (*) Correct 5. By defining ________ and _____ keys, you can ensure that the integrity of the data in a table is maintained. Mark for Review



(1) Points primary, secondary primary, unique foreign, unique primary, foreign (*) Correct Page 1 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) 6. The logical model determines relationship optionality and cardinality Mark for Review



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



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



They capture the implementation details of the physical model.



They model functional and informational needs. (*) Incorrect. Refer to Section 2 Lesson 2. 8. What is the purpose of a Unique Identifier? Mark for Review



(1) Points 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. Incorrect. Refer to Section 2 Lesson 4. 9. 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 (*) Date of birth for Baby



Personal Identification number for Person (*) Correct 10. One-to-Many relationships have cardinality of one or more in both directions. True or False? Mark for Review



(1) Points True False (*) Correct Page 2 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) 11. If a relationship is mandatory there must be at least one instance of the corresponding entity related to it. Mark for Review



(1) Points True (*) False Correct 12. A relationship is transformed from logical to physical model using _________. Mark for Review



(1) Points Candidate Keys Secondary Keys Foreign Keys (*) Composite Keys Incorrect. Refer to Section 2 Lesson 5. 13. 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. 14. ERDish includes the following except: Mark for Review



(1) Points Relationship Names



Data Values. (*) Cardinality Optionality Correct 15. An ERD created using ERDish is a __________ representation of entities and their relationships to each other. Mark for Review



(1) Points technical textual graphical (*) hierarchical Correct 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. Entity Boxes are drawn on an ERD using what type of shape? Mark for Review



(1) Points Diamonds Hard Boxes Rectangles Soft Boxes (*) Correct



2. 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 (*) Process Table ERD Correct 3. Which of the following entities most likely contains invalid attributes? Mark for Review



(1) Points Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of Children Entity: Pet. Attributes: Name, Birthdate, Owner Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed (*) Correct 4. When mapping a relationship for an ERD relationship names must be included. 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 technical specifications of the database to users



Is a hard and fast document that cannot be changed once development of the database has begun. Used to communicate the logical structure of the database to users. (*) Used to communicate the physical structure of the database to users. Incorrect. Refer to Section 2 Lesson 6. Page 1 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) 6. 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 (*) Correct 7. A table must have a primary key. True or False? Mark for Review



(1) Points True (*) False Correct 8. A row is called a record. Mark for Review



(1) Points True (*) False



Correct 9. Which of the following would be good as a Unique Identifier for its Entity? (Choose Three) Mark for Review



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



Correct 10. Primary UIDs are: Mark for Review



(1) Points Always comprised of numbers Useful as an alternative means of identifying instances of an entity, independent of their datatype Optional in data modeling. Mandatory in data modeling (*) Correct Page 2 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) 11. The physical model shows all table structures. True or False.



Mark for Review



(1) Points True (*) False Correct 12. The logical model determines relationship optionality and cardinality Mark for Review



(1) Points True (*) False Correct 13. If a relationship is mandatory there must be at least one instance of the corresponding entity related to it. Mark for Review



(1) Points True (*) False Correct 14. One-to-One relationships have _____________ of one to one in both directions. Mark for Review



(1) Points Optionality Foreign Keys Naming Cardinality (*) Correct 15. One-to-Many relationships have cardinality of one or more in both directions. True or False?



Mark for Review



(1) Points True False (*) Correct 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 are true? (Choose two) Mark for Review



(1) Points Relational systems pay more attention to retrieving data and making it accessible to the user. (*) Relational database systems are the main thrust behind SQL since it provides the language elements needed to tie together the information in the database. (*) Flat file database systems pay more attention to retrieving data and making it accessible to the user, whereas relational databases spend more energy updating indexes and data pointers.



Flat file database structures help eliminate redundant information.



Incorrect. Refer to Section 2 Lesson 1. 2. Which of the following statements does not apply to relational databases? Mark for Review



(1) Points Relational databases relate tables to each other using common fields called keys. Relational databases have a strong procedural orientation. (*) Relational databases are simple to understand. Tables are one of the basic components of relational databases. Correct 3. 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 4. 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 External data model An entity-relation data model Logical data model (*) Internal data model Incorrect. Refer to Section 2 Lesson 2. 5. A __________ relationship is a relationship between an entity and itself. Mark for Review



(1) Points One to one



Recursive (*) Hierarchical Mandatory Correct Page 1 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) 6. A foreign key is a column or combination of columns in one table that uniquely identifies a row of another table. Mark for Review



(1) Points True (*) False Correct 7. A relationship is transformed from logical to physical model using _________. Mark for Review



(1) Points Composite Keys Foreign Keys (*) Secondary Keys Candidate Keys Correct 8. 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 9. In an ERD diagram how is cardinality represented ? (Choose two) Mark for Review



(1) Points With a solid line



With a crow's foot (*) With a dotted line



With a single toe (*) Correct 10. The __________ model includes entities, attributes, UIDs, relationships as well as optionality and cardinality of these items. Mark for Review



(1) Points Logical (*) Physical Conceptual Hierarchical Incorrect. Refer to Section 2 Lesson 6. Page 2 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) 11. The primary key uniquely identifies each row in a table and is based on the __________ from the logical design. Mark for Review



(1) Points Secondary UID Primary UID (*) Candidate UID Composite UID Correct 12. A unique identifier made up of more than one attribute is called a __________. Mark for Review



(1) Points Candidate UID Composite UID (*) Unique UID Foreign UID Incorrect. Refer to Section 2 Lesson 4. 13. An entity may have which of the following? Mark for Review



(1) Points Experiences Instances (*) Tables None of the above Incorrect. Refer to Section 2 Lesson 3. 14. Entities are usually _____________.



Mark for Review



(1) Points Verbs Adjectives Nouns (*) Adverbs Correct 15. Attributes that can be divided into smaller subparts are called________________. Mark for Review



(1) Points Mandatory Attribute Volatile Attribute Single Attribute Composite Attribute (*) Correct 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. The cardinality of a relationship can be _____________. (Choose two) Mark for Review



(1) Points one or more (*) one to one



one and only one (*) many to many



Correct 2. A foreign key is a column or combination of columns in one table that uniquely identifies a row of another table. Mark for Review



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



(1) Points Bidirectional or a single direction One or (One or More) Single or Multiple Mandatory or Optional (*) Correct 4. 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. 5. The primary key uniquely identifies each row in a table and is based on the __________ from the logical design.



Mark for Review



(1) Points Primary UID (*) Composite UID Candidate UID Secondary UID Correct Page 1 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) 6. When creating entities in a logical model you must follow these rules: (Choose Two) Mark for Review



(1) Points Name them in Singular (*) Name them in Plural



Include Attributes (*) Exclude Attributes



Correct 7. Which of the attributes is a volatile attribute? Mark for Review



(1) Points Age (*) Date of birth Eye color Race Correct 8. Entity Boxes are drawn on an ERD using what type of shape? Mark for Review



(1) Points Soft Boxes (*) Diamonds Hard Boxes Rectangles Correct 9. Data modeling is performed for the following reasons: (Choose Two) Mark for Review



(1) Points We do not need datamodels; we can just start coding right away.



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. (*) It helps discussions and reviews. (*) Correct 10. In an ERD diagram how is cardinality represented ? (Choose two) Mark for Review



(1) Points With a solid line



With a dotted line



With a single toe (*) With a crow's foot (*) Correct Page 2 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) 11. An ERD created using ERDish is a __________ representation of entities and their relationships to each other. Mark for Review



(1) Points graphical (*) hierarchical textual technical Correct 12. A _______ is a collection of records. Mark for Review



(1) Points



column table (*) row field Incorrect. Refer to Section 2 Lesson 1. 13. In the relational model, data is organized in a basic storage structure called a ____________. Mark for Review



(1) Points Tuples Table (*) Field Row Correct 14. 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 Logical data model (*) External data model Internal data model An entity-relation data model Correct 15. 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 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. _____________ are converted to rows in the physical design. Mark for Review



(1) Points instances (*) attributes columns entities Incorrect. Refer to Section 3 Lesson 4. 2. When mapping a many to many relationship it must first be resolved using _____________. Mark for Review



(1) Points An intersection entity (*) Business Rules Unique keys An intermediary entity Correct 3. Attribute names are converted to column names by _________________. Mark for Review



(1) Points Replacing underscores with dashes. Replacing periods with commas. Replacing spaces with underscores. (*) Replacing numbers with letters. Correct 4. A table is in 2NF if the table is in 1NF and what other condition is met? Mark for Review



(1) Points There are no repeating groups. There are no functional dependencies. There are no null values in primary key fields. There are no attributes that are not functionally dependent on the relation's entire primary key. (*) Correct 5. An entity without repeated values is said to be in __________. Mark for Review



(1) Points 3rd normal form 4th normal form 2nd normal form 1st normal form (*) Correct Page 1 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)



6. According to ___________, an attribute must be dependent on its entity’s entire unique identifier. Mark for Review



(1) Points 4th normal form 2nd normal form (*) 3rd normal form 1st normal form Incorrect. Refer to Section 3 Lesson 3. 7. Normalization is the process of organizing the attributes and entities of a relational database to minimize ______________ Mark for Review



(1) Points redundancy data inconsistencies anomalies All of the above. (*) Correct 8. A table is in 1NF if … (Choose 2) Mark for Review



(1) Points There is only one data value. (*) The entries in a column are of different type



There are no duplicate rows (*) Each row contains different columns



Correct 9. A recursive relationship has cardinality of ___________. Mark for Review



(1) Points One to Many Many to Many One to One Cannot be determined without more information. (*) Incorrect. Refer to Section 3 Lesson 1. 10. The UIDs for a set of hierarchical entities can be propagated through multiple ________ relationships. Mark for Review



(1) Points recursive barred (*) one to one arc Correct Page 2 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) 11. A _________ on a relationship line indicates the Relationship as Non-Tranferable. Mark for Review



(1) Points



Triangle Circle Diamond (*) Star Incorrect. Refer to Section 3 Lesson 1. 12. All instances of the supertype _____ be an instance of one of the subtypes. Mark for Review



(1) Points cannot must (*) will sometimes may Incorrect. Refer to Section 3 Lesson 1. 13. Which of the following statements about subtypes is not true? Mark for Review



(1) Points Inherits all relationships of the supertype. Inherits all attributes of the supertype. Must have subtypes of its own. (*) Never exists alone. Incorrect. Refer to Section 3 Lesson 1. 14. Modeling historical data can produce a unique identifier that includes dates. True or False? Mark for Review



(1) Points True (*) False Correct 15. Which of the following scenarios should be modeled so that historical data is kept? (Choose two)



Mark for Review



(1) Points BABY and AGE



CUSTOMER and PAYMENTS (*) CUSTOMER and ORDERS (*) TEACHER and AGE



Incorrect. Refer to Section 3 Lesson 2. 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. Which of the following is true about subtypes? Mark for Review



(1) Points Subtypes must not be mutually exclusive. One instance of a supertype may belong to two subtypes. Subtypes must be mutually exclusive. (*) Subtypes should not be exhaustive. Incorrect. Refer to Section 3 Lesson 1. 2. Which of the following statements about subtypes is not true? Mark for Review



(1) Points Inherits all attributes of the supertype. Never exists alone. Inherits all relationships of the supertype. Must have subtypes of its own. (*) Correct 3. Transferable relationships can only be mandatory, not optional. True or False? Mark for Review



(1) Points True False (*) Incorrect. Refer to Section 3 Lesson 1. 4. All instances of the supertype _____ be an instance of one of the subtypes. Mark for Review



(1) Points may must (*) cannot will sometimes Correct 5. Another name for a "barred relationship" is ________________. Mark for Review



(1) Points Hierarchical Relationship Identifying Relationship (*) Recursive Relationship Supertype Relationship Incorrect. Refer to Section 3 Lesson 1.



Page 1 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) 6. "Only teachers may supervise exams" is an example of which of the following? Mark for Review



(1) Points An attribute that should be stored on the PERSON entity A structural business rule A procedural business rule (*) An attribute that is not be inherited from the PERSON supertype and is unique to the TEACHER subtype Incorrect. Refer to Section 3 Lesson 3. 7. Normalization is the process of organizing the attributes and entities of a relational database to minimize ______________ Mark for Review



(1) Points redundancy data inconsistencies anomalies All of the above. (*) Correct 8. Why is it important to follow the rules of normalization? Mark for Review



(1) Points To reduce redundant data in the existing design



To increase the integrity of data and the design's stability To eliminate other types of data inconsistencies and anomalies To identify missing tables, columns, and constraints All of the above. (*) Correct 9. When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review



(1) Points Multiplication Normalization (*) Reduction Normality Correct 10. When is an entity in 2nd Normal Form? Mark for Review



(1) Points When all non-UID attributes are dependent upon the entire UID. (*) When attributes with repeating or multi-values are removed. When no attritibutes are mutually independent and all are fully dependent on the primary key. None of the Above. Incorrect. Refer to Section 3 Lesson 3. Page 2 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) 11. An entity name is converted to a table name by making it plural.



Mark for Review



(1) Points True (*) False Incorrect. Refer to Section 3 Lesson 4. 12. _____________ are converted to rows in the physical design. Mark for Review



(1) Points instances (*) attributes entities columns Correct 13. In a physical data model, an attribute is represented as a/an Mark for Review



(1) Points Instance Row Column (*) Foreign Key Correct 14. A ______________ is frequently used to track information about a relationship that changes over time. Mark for Review



(1) Points recursive relationship many to many relationship



non-transferable relationship intersection entity (*) Correct 15. Modeling historical data can produce a unique identifier that includes dates. True or False? Mark for Review



(1) Points True (*) False Correct 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. A ______________ is frequently used to track information about a relationship that changes over time. Mark for Review



(1) Points recursive relationship non-transferable relationship intersection entity (*) many to many relationship Correct 2. Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review



(1) Points 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. If you are doing a system for any French City, you would need security clearance. Daily traffic patterns must be monitored to determine how many law enforcement officers are needed. Correct 3. A table is in 3NF if it has met all database requirements for both 1NF and 2NF and all transitive dependencies are eliminated. Mark for Review



(1) Points True (*) False Correct 4. "Only teachers may supervise exams" is an example of which of the following? Mark for Review



(1) Points An attribute that should be stored on the PERSON entity An attribute that is not be inherited from the PERSON supertype and is unique to the TEACHER subtype A structural business rule A procedural business rule (*) Correct 5. The Rule of 3rd Normal Form states that No Non-UID attribute can be dependent on another nonUID attribute. True or False? Mark for Review



(1) Points True (*) False Incorrect. Refer to Section 3 Lesson 3. Page 1 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) 6. A table is in 1NF if … (Choose 2) Mark for Review



(1) Points Each row contains different columns



There is only one data value. (*) There are no duplicate rows (*) The entries in a column are of different type



Correct 7. Normalization is the process of organizing the attributes and entities of a relational database to minimize ______________ Mark for Review



(1) Points redundancy data inconsistencies anomalies All of the above. (*) Correct 8. When mapping a barred relationship a primary key and foreign key can be the same field. Mark for Review



(1) Points True (*) False Correct 9. When mapping a many to many relationship it must first be resolved using _____________. Mark for Review



(1) Points An intermediary entity Business Rules An intersection entity (*) Unique keys Correct 10. The transformation from an ER diagram to a physical design involves changing terminology. Primary Unique Identifiers in the ER diagram become __________ and relationships become ____________. Mark for Review



(1) Points Foreign keys, Primary keys Primary keys, Foreign keys (*) Unique Keys, Primary keys Foreign keys, mandatory business rules Correct Page 2 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)



11. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review



(1) Points True (*) False Correct 12. All relationships participating in an arc must be mandatory. True or False? Mark for Review



(1) Points True False (*) Incorrect. Refer to Section 3 Lesson 1. 13. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review



(1) Points CAR and WHEEL PERSON and FINGERPRINT TREE and BRANCH TEACHER and SUBJECT AREA (*) Correct 14. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review



(1) Points Optional Mandatory Transferable



Non-Transferable (*) Correct 15. A ___________ relationship is created when the UID for an entity includes the relationship with another entity. Mark for Review



(1) Points one to one barred (*) recursive many to many Correct 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. Modeling historical data can produce a unique identifier that includes dates. True or False? Mark for Review



(1) Points True (*) False Correct 2. A ______________ is frequently used to track information about a relationship that changes over time. Mark for Review



(1) Points non-transferable relationship



many to many relationship recursive relationship intersection entity (*) Correct 3. Another name for a "barred relationship" is ________________. Mark for Review



(1) Points Recursive Relationship Hierarchical Relationship Identifying Relationship (*) Supertype Relationship Correct 4. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review



(1) Points True (*) False Correct 5. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review



(1) Points TREE and BRANCH PERSON and FINGERPRINT TEACHER and SUBJECT AREA (*) CAR and WHEEL Correct Page 1 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) 6. Which of the following statements about subtypes is not true? Mark for Review



(1) Points Must have subtypes of its own. (*) Inherits all attributes of the supertype. Never exists alone. Inherits all relationships of the supertype. Correct 7. A recursive relationship has cardinality of ___________. Mark for Review



(1) Points One to Many Many to Many One to One Cannot be determined without more information. (*) Incorrect. Refer to Section 3 Lesson 1. 8. When is an entity in 2nd Normal Form? Mark for Review



(1) Points When all non-UID attributes are dependent upon the entire UID. (*) When attributes with repeating or multi-values are removed. When no attritibutes are mutually independent and all are fully dependent on the primary key.



None of the Above. Correct 9. According to ___________, an attribute must be dependent on its entity’s entire unique identifier. Mark for Review



(1) Points 1st normal form 3rd normal form 4th normal form 2nd normal form (*) Incorrect. Refer to Section 3 Lesson 3. 10. If there is a column missing in an entity - normalization should identify this problem. Mark for Review



(1) Points True (*) False Correct Page 2 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) 11. A table is in 1NF if … (Choose 2) Mark for Review



(1) Points There are no duplicate rows



(*) Each row contains different columns



There is only one data value. (*) The entries in a column are of different type



Correct 12. A table is in 2NF if Mark for Review



(1) Points It meets the requirements for the 1 NF. Each non-key attribute is fully functional dependent on the table's primary key. Both A and B must be true. (*) Neither A or B must be true. Correct 13. Table names can contain all of the following except: Mark for Review



(1) Points Spaces (*) Letters Some special characters Numbers Correct 14. An entity name is converted to a table name by making it plural. Mark for Review



(1) Points True (*)



False Correct 15. Attribute names are converted to column names by _________________. Mark for Review



(1) Points Replacing periods with commas. Replacing spaces with underscores. (*) Replacing numbers with letters. Replacing underscores with dashes. Correct 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. Modeling historical data can produce a unique identifier that includes dates. True or False? Mark for Review



(1) Points True (*) False Correct 2. Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review



(1) Points If you are doing a system for any French City, you would need security clearance. People are born in the city and people die in the city.



Cites may change their names and/or country association if the borders of a country change. (*) Daily traffic patterns must be monitored to determine how many law enforcement officers are needed. Correct 3. "Only teachers may supervise exams" is an example of which of the following? Mark for Review



(1) Points An attribute that is not be inherited from the PERSON supertype and is unique to the TEACHER subtype A procedural business rule (*) An attribute that should be stored on the PERSON entity A structural business rule Correct 4. When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review



(1) Points Normality Reduction Multiplication Normalization (*) Correct 5. Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False? Mark for Review



(1) Points True (*) False Correct



Page 1 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) 6. A table is in 3NF if it has met all database requirements for both 1NF and 2NF and all transitive dependencies are eliminated. Mark for Review



(1) Points True (*) False Correct 7. According to ___________, an attribute must be dependent on its entity’s entire unique identifier. Mark for Review



(1) Points 2nd normal form (*) 3rd normal form 4th normal form 1st normal form Correct 8. A non-transferable relationship means the detail _____ be changed to point to a new master. Mark for Review



(1) Points can not (*) sometimes can can Correct



9. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review



(1) Points True False (*) Incorrect. Refer to Section 3 Lesson 1. 10. Which of the following is true about subtypes? Mark for Review



(1) Points One instance of a supertype may belong to two subtypes. Subtypes must not be mutually exclusive. Subtypes must be mutually exclusive. (*) Subtypes should not be exhaustive. Correct Page 2 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) 11. Another name for a "barred relationship" is ________________. Mark for Review



(1) Points Identifying Relationship (*) Hierarchical Relationship Recursive Relationship Supertype Relationship



Correct 12. The "Other" subtype is mandatory. True or False? Mark for Review



(1) Points True False (*) Incorrect. Refer to Section 3 Lesson 1. 13. Table names can contain all of the following except: Mark for Review



(1) Points Numbers Letters Spaces (*) Some special characters Correct 14. When converting attribute names to columns __________ are frequently used. Mark for Review



(1) Points numbers spaces special characters abbreviations (*) Correct 15. We take the primary key from the "one" table and place it on the "many" table to create a foreign key. Mark for Review



(1) Points



True (*) False Correct Page 3 of 3