Kuis Database Foundations Midterm Exam

Database Foundations Midterm Exam Test: Database Foundations Midterm Exam Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 (Answer all questions in this section) 1. What is the difference between "information" and "data"?

Mark for Review (1) Points

Information and data have no differences - they are two words for the same thing. Information is held and understood only by users. Data turns into useful information. It is stored in a database and accessed by systems and users. (*) Data is held and understood only by users. Correct 2. A database is a centralized and structured set of data stored on a computer system and provides facilities for retrieving, adding, modifying, and deleting the data when required.


True (*) False Correct 3. 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 similar.


True (*) False Correct 4. The advantages of object-oriented data model are:


Reduced Maintenance Real-World Modeling Both (*) None Correct 5. A network database comprises of a collection of records connected to one another through links. True (*) False Correct


Page 1 of 10

Next Summary

Test: Database Foundations Midterm Exam Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 (Answer all questions in this section) 6. A database can be considered only from a physical storage perspective.


True False (*) Correct 7. The Oracle Database stores data logically in tablespaces, and physically in datafiles associated with the corresponding tablespace.


True (*) False Correct 8. The smallest logical storage unit of a database is ...


Data Blocks (*) Tablespaces Segments Extents Correct 9. The main subject areas taught by the Oracle Academy are:


Data Modeling, SQL, and PL/SQL (*) Computer Repairs Systems programming and computer architecture Database performance tuning Correct 10. Data Integrity ensures the duplication of information.

True False (*) Correct


Previous

Page 2 of 10

Next Summary

Test: Database Foundations Midterm Exam Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 (Answer all questions in this section) 11. In a relational database a table is referred to as ..


Cardinality Relation (*) Attribute None Correct 12. Business rules help you understand the standardization procedure an organization follows when handling huge data.


True (*) False Correct 13. Business rules are used to understand business processes, and the nature, role, and scope of the data.


True (*) False Correct Section 2 (Answer all questions in this section) 14. An entity may have which of the following?


Experiences Instances (*) Tables None of the above Correct 15. The transformation from an ER diagram to a physical design involves changing terminology. Secondary Unique Identifiers become


Unique Constraints (*) Primary Key Constraints Columns Tables Correct

Previous

Page 3 of 10

Next Summary

Test: Database Foundations Midterm Exam Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 (Answer all questions in this section) 16. 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 Table Process Attribute (*) Correct 17. Primary Key can contain null values.


True False (*) Correct 18. What is the purpose of a Unique Identifier?


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 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. Correct 19. One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False? True False (*)


Correct 20. A foreign key cannot refer to a primary key in the same table. True or False?



Previous

Page 4 of 10

Next Summary

Test: Database Foundations Midterm Exam Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 (Answer all questions in this section) 21. The Physical Model is derived from the Conceptual Model. True or False?


True (*) False Correct 22. Data modeling is performed for the following reasons: (Choose Two)


(Choose all correct answers) The ERD becomes a blueprint for designing the actual system. (*) It helps discussions and reviews. (*) 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. Correct 23. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. (Choose 3) (Choose all correct answers) They model functional and informational needs. (*) They capture current and future needs. (*) They capture the implementation details of the physical model. They model the information flow of data. They accurately describe what a physical model will contain. (*) Correct


24. In the relational model, data is organized in two-dimensional tables called ___________.


Relations (*) Row Tuples Field Correct 25. A table must have a primary key. True or False?



Previous

Page 5 of 10

Next Summary

Test: Database Foundations Midterm Exam Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 (Answer all questions in this section) 26. Flat file databases are generally in plain-text form, where each line holds only one record. True or False?


True (*) False Correct 27. Flat file databases avoids data duplication. True or False?


True False (*) Incorrect. Refer to Section 2 Lesson 1. Section 3 (Answer all questions in this section) 28. Age is a Non-volatile attribute. True or False.



29. To identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False?


True (*) False Correct 30. A unique identifier must be made up of more than one attribute. True or False?



Previous

Page 6 of 10

Next Summary

Test: Database Foundations Midterm Exam Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 3 (Answer all questions in this section) 31. People are not born with "numbers", but a lot of systems assign student numbers, customer IDs, etc. ﾠA shoe has a color, a size, a style, but may not have a descriptive "number". So, to be able to uniquely and efficiently identify one instance of the entity SHOE, a/an ______________ UID can be created.


Artificial (*) Unrealistic Identification Structured Correct 32. In a business that sells pet food, choose the best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse, or cat). (Choose Two)


(Choose all correct answers) Each FOOD TYPE may be given to one or more ANIMALs. (*) Each FOOD TYPE may be made from one or more ANIMALs. Each ANIMAL must be the seller of one or more FOOD TYPES. Each FOOD TYPE must be suitable for one or more ANIMALs. (*) Correct 33. A Matrix Diagram should be developed by the end-users of your database. True or False?


True False (*) Correct 34. Matrix Diagrams are used to verify that all relationships have been identified for an ERD. True or False?


True (*) False Correct 35. Relationships represents something of significance to the business. True or False?


True (*) False Correct

Previous

Page 7 of 10

Next Summary

Test: Database Foundations Midterm Exam Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 3 (Answer all questions in this section) 36. Documenting Business Requirements helps developers control the scope of the system and prevents users from claiming that the new system does not meet their business requirements. True or False?


True (*) False Correct 37. The Physical Model is derived from the Conceptual Model. True or False?


True (*) False Correct 38. Would it be a good idea to model age as an attribute of STUDENT?

Yes No - it breaks the Normalization rules (*) Yes, it would prevent our having to calculate someone's age every time we need it.


Sometimes, but not all of the time Correct 39. A table is in 3NF if it has met all database requirements for both 1NF and 2NF and ll transitive dependencies are eliminated.


True (*) False Correct 40. If Audit trail attributes are added to an entity, they must be in the entities they are auditing. True or False?



Previous

Page 8 of 10

Next Summary

Test: Database Foundations Midterm Exam Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 3 (Answer all questions in this section) 41. Which of the following would be a logical constraint when modeling time for a City entity?


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. 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. Correct 42. Why is it important to identify and document structural rules?


Ensures we know what data to store and how that data works together. (*) Ensures nothing. There are no benefits to be gained from documenting your Structural Business Rules. We need to concentrate on the Procedural Business Rules only. Ensures we know what processes are in place and how to program them. All of the Above. Correct 43. Business rules are important to data modelers. True or False?

Mark for Review

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


An attribute that should be stored on the PERSON entity A procedural business rule (*) A structural business rule An attribute that is not be inherited from the PERSON supertype and is unique to the TEACHER subtype Correct 45. Which of the following is true about subtypes?


Subtypes should not be exhaustive. Subtypes must not be mutually exclusive. Subtypes must be mutually exclusive. (*) One instance of a supertype may belong to two subtypes. Correct

Previous

Page 9 of 10

Next Summary

Test: Database Foundations Midterm Exam Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 3 (Answer all questions in this section) 46. A supertype can only have two subtypes and no more. True or False?


True False (*) Correct 47. Entity Boxes are drawn with 90 degree angles, also known as Hard Boxes. True or False? True False (*) Incorrect. Refer to Section 3 Lesson 3.


48. A single relationship can be both Recursive and Hierachal at the same time. True or False?


True False (*) Correct 49. Arcs are used to visually represent _________ between two or more relationships in an ERD.


Exclusivity (*) Sameness Inheritance Differences Correct 50. An arc can also be modeled as Supertype and Subtypes. True or False?


Previous

Page 10 of 10

Summary


Kuis Database Foundations Midterm Exam

Recommend Documents