DATABASE DESIGN ENGLISH SECTION MIDTERM TEST

Section 1
(Answer all questions in this section)

1. In the grid computing model, resources are pooled together for efficiency. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


2. Users could directly interact with which of the following software to access essential business applications? (Choose three) Mark for Review
(1) Points

(Choose all correct answers)


Server software


Operating System software (*)


Internet Browser software (*)


GUI software (*)



Correct Correct


3. Personal computers (PCs) have been in existence since 1950. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


4. Software cannot operate without Hardware. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


5. The market for IT professionals is still increasing and will continue to do so in the future as the world gets ever more dependent on computer systems. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct
6. Oracle was one of the first relational database systems available commercially. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


7. The work of E.F. Codd in the early 1970s led to the development of Relational databases. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


8. Most of the well known Internet search engines use databases to store data. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


9. What is the difference between "information" and "data"? Mark for Review
(1) Points


Data turns into useful information. It is stored in a database and accessed by systems and users. (*)


Information and data have no differences - they are two words for the same thing.


Data is held and understood only by users.


Information is held and understood only by users.



Correct Correct


10. How do you turn "data" into "information"? Mark for Review
(1) Points


By testing it


By querying it or accessing it (*)


By storing it in a database


By storing it on a server



Correct Correct
11. The Physical Model is derived from the Conceptual Model. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


12. An ERD is an example of a Physical Model. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


13. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


14. Data modeling is performed for the following reasons: (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)


It helps discussions and reviews. (*)


The ERD becomes a blueprint for designing the actual system. (*)


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.


We do not need datamodels; we can just start coding right away.



Correct Correct


15. Entity Relationship modeling is dependent on the hardware or software used for implementation, so you will need to change your ERD if you decide to change Hardware Vendor. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct
16. Which of the following can be found in an ERD? (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)


Tables.


Attributes. (*)


Entities. (*)


Instances.



Correct Correct


17. Which of the following statements about ERD's is false? Mark for Review
(1) Points


Model all information that is derivable from other information already modeled. (*)


Capture all required information.


Locate information in a predictable, logical place.


Ensure that information appears only once.



Correct Correct


18. All of the following would be instances of the entity ANIMAL SPECIES, except which one? Mark for Review
(1) Points


Bird


Dog


Elephant


Leaf (*)



Correct Correct


19. All of the following would be instances of the entity PERSON except which? Mark for Review
(1) Points


David Jones


Angelina Rosalie


Male (*)


Grace Abinajam



Correct Correct


20. A/an _________ is defined as "Something" of significance to the business about which data must be known. Mark for Review
(1) Points


Instance


Relationship


Entity (*)


None of the above



Correct Correct
21. Which of the following statements about Entities are true? Mark for Review
(1) Points

(Choose all correct answers)


They are usually a noun. (*)


A name for a set of similar "things" (*)


They never have Instances


"Something" of significance to the business about which data must be known. (*)



Correct Correct


22. In the following statements, find two good examples of ENTITY: Instance. (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)


BOOK: Biography of Mahatma Gandhi (*)


VEGETABLE: grows


TRAIN: runs


DAIRY PRODUCT: milk (*)



Correct Correct


23. Which of the following is an example of a volatile attribute? Mark for Review
(1) Points


Hire Date


Age (*)


Name


Date of Birth



Correct Correct




Section 3
(Answer all questions in this section)

24. To identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


25. Relationships can be either mandatory or optional. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct
26. What are the three properties that every relationship should have? Mark for Review
(1) Points


Transferability, degree, name


Name, optionality, arcs


Name, optionality, cardinality (*)


A UID bar, a diamond, an arc



Correct Correct


27. Which of the following are used to show Cardinality on an ERD? (Choose two) Mark for Review
(1) Points

(Choose all correct answers)


Crow's foot. (*)


Dashed line.


Single toe. (*)


Solid line.



Correct Correct


28. ERDish describes a relationship in words. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


29. When reading the relationships in an ERD, you are said to be speaking: Mark for Review
(1) Points


Relationship-ish


Gibberish


ERDish (*)


Entity-ish



Correct Correct


30. Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct
31. Matrix Diagrams are used to verify that all relationships have been identified for an ERD. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct




Section 4
(Answer all questions in this section)

32. Why is it important to identify and document structural rules? Mark for Review
(1) Points


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 Correct


33. Which of the following is an example of a structural business rule? Mark for Review
(1) Points


All overdue payments will have an added 10 % late fee.


All products will have a selling price no less than 30 % greater than wholesale.


Buildings to be purchased by the business must be current with earthquake building code.


All employees must belong to at least one department. (*)



Correct Correct


34. Business rules are important to data modelers because: Mark for Review
(1) Points


A. They capture all of the needs, processes, and required functionality of the business. (*)


B. All Business rules 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.



Correct Correct


35. A business rule such as "We only ship goods after customers have completely paid any outstanding balances on their account" is best enforced by: Mark for Review
(1) Points


Making the payment attribute optional.


Creating additional programming code to verify no goods are shipped until the account has been settled in full. (*)


We need to trust our customers, and we know they will pay some day.


Making the payment attribute null.



Correct Correct
36. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


37. A Supertype can have only one subtype. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


38. All instances of the supertype must be an instance of one of the subtypes. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


39. A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


40. A supertype can only have two subtypes and no more. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct
41. A Diamond on a relationship indicates the Relationship as Non-Tranferable. True or False? Mark for Review
(1) Points


True (*)


False



Correct Correct


42. Non-transferable relationships can only be mandatory, not optional. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


43. A non-transferable relationship means the relationship is manatory at both sides. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


44. What uncommon relationship is described by the statements: "Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE" Mark for Review
(1) Points


One to Many Optional


One to One Optional (*)


Many to Many Mandatory


One to Many Mandatory



Correct Correct


45. Which of the following pairs of entities is most likely to be modeled as a 1:1 relationship? Mark for Review
(1) Points


CAR and WHEEL


TEACHER and SUBJECT AREA


PERSON and FINGERPRINT (*)


TREE and BRANCH



Correct Correct
46. Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


47. If two entities have two relationships between them, these relationships can be either _____________ or _____________ . Mark for Review
(1) Points


Replicated or Required


Redundant and Replicated


Resourced and Really Good


Redundant or Required (*)



Correct Correct


48. A relationship on an ERD can have attributes. True or False? Mark for Review
(1) Points


True


False (*)



Correct Correct


49. Many to many relationships between entities usually hide what? Mark for Review
(1) Points


Uniqueness


Another entity (*)


More attributes


Another relationship



Correct Correct


50. When you resolve a M:M by creating an intersection entity, this new entity will always inherit: Mark for Review
(1) Points


The attributes of both related entities.


A relationship to each entity from the original M:M. (*)


Nothing is inherited from the original entities and relationship.


The UID's from the entities in the original M:M.



Correct Correct
1.         The main subject areas taught by the Oracle Academy are:     Mark for Review
(1) Points
            Data Modeling, SQL, and PL/SQL (*)
            Computer Repairs
            Database performance tuning
            Systems programming and computer architecture

2.         What is the difference between "information" and "data"?      Mark for Review
(1) Points
            Data turns into useful information. It is stored in a database and accessed by systems and users. (*)

            Information and data have no differences - they are two words for the same thing.
            Information is held and understood only by users.
            Data is held and understood only by users.

3.         Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is the total number of books out on loan in one given month considered Data or Information?    Mark for Review
(1) Points
            Data
            Information (*)
            Both
            Neither

4.         Changes in computing have affected many of our day-to-day activities. Are all of the following activities examples of this change? Yes or No?
In the past you used to use the phone system to call directory assistance to get a phone number. Today you can use your PC to look up a phone number online.

In the past you used to have to go to the shoe store to buy shoes. Today you can use your PC to order shoes online.

In the past you had to use your PC to send a person an email. Today you can use your phone to send a text message.

 Mark for Review
(1) Points
            Yes (*)
            No

5.         The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network.   Mark for Review
(1) Points
            True
            False (*)

6.         In the grid computing model, resources are pooled together for efficiency. True or False?     Mark for Review
(1) Points
            True (*)
            False

7.         Personal computers (PCs) have been in existence since 1950. True or False? Mark for Review
(1) Points
            True
            False (*)

8.         Entities are transformed into Tables during the Database Design process. True or False?        Mark for Review
(1) Points
            True (*)
            False

9.         Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False?     Mark for Review
(1) Points
            True (*)
            False

10.       Oracle was one of the first relational database systems available commercially. True or False?          Mark for Review
(1) Points
            True (*)
            False

Section 2
            (Answer all questions in this section)

11.       Data models show users the data that their Physical Model will contain. True or False?          Mark for Review
(1) Points
            True (*)
            False

12.       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

13.       An ERD is an example of a Physical Model. True or False?    Mark for Review
(1) Points
            True
            False (*)

14.       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

15.       Which of the following attributes is suitable to be a Unique Identifier?           Mark for Review
(1) Points
            Address
            Last name
            First name
            Social Security Number (*)

16.       In the following statements, find two good examples of ENTITY: Instance. (Choose Two)    Mark for Review
(1) Points
                                    (Choose all correct answers)  
            BOOK: Biography of Mahatma Gandhi (*)
            VEGETABLE: grows
            TRAIN: runs
            DAIRY PRODUCT: milk (*)

17.       Which of the following is an example of a volatile attribute?  Mark for Review
(1) Points
            Hire Date
            Name
            Date of Birth
            Age (*)

18.       Which of the following entities most likely contains valid attributes? (Choose two)    Mark for Review
(1) Points
                                    (Choose all correct answers)  
            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, Start Date

19.       All of the following could be attributes of an ENTITY called PERSON, except which one?   Mark for Review
(1) Points
            Gender
            Natacha Hansen (*)
            Weight
            Haircolor

20.       Which of the following are examples of ENTITY: Instance ? (Choose Two)  Mark for Review
(1) Points
                                    (Choose all correct answers)  
            MEAT PRODUCT: Lettuce
            TRANSPORTATION METHOD: Car (*)
            BODY PART: Larry Ellison
            ANIMAL: Dog (*)

21.       An Entity Relationship model is independent of the hardware or software used for implementation. True or False?          Mark for Review
(1) Points
            True (*)
            False

22.       Which of the following statements are true about ERD's? (Choose Two)        Mark for Review
(1) Points
                                    (Choose all correct answers)  
            You should not model derivable data. (*)
            A piece of information can be shown multiple times on an ERD.
            A piece of information should only be found in one place on an ERD. (*)
            All data must be represented on the ERD, including derived summaries and the result of calculations.

23.       Which of the following can be found in an ERD? (Choose Two)        Mark for Review
(1) Points
                                    (Choose all correct answers)  
            Attributes. (*)
            Instances.
            Entities. (*)
            Tables.

Section 3
            (Answer all questions in this section)

24.       When reading a relationship between 2 entities, the relationship is read both from left to right and right to left. True or False?       Mark for Review
(1) Points
            True (*)
            False

25.       Relationship names are not shown on an ERD. True or False?            Mark for Review
(1) Points
            True
            False (*)

26.       Which symbol is used to show that a particular attribute is mandatory?          Mark for Review
(1) Points
            o
            * (*)
            #
            &

27.       Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?         Mark for Review
(1) Points
            True
            False (*)

28.       Matrix Diagrams are developed BEFORE the ERD. True or False?     Mark for Review
(1) Points
            True (*)
            False

29.       What are the three properties that every relationship should have?      Mark for Review
(1) Points
            Transferability, degree, name
            Name, optionality, cardinality (*)
            Name, optionality, arcs
            A UID bar, a diamond, an arc

30.       Which of the following are used to show Cardinality on an ERD? (Choose two)        Mark for Review
(1) Points
                                    (Choose all correct answers)  
            Dashed line.
            Single toe. (*)
            Crow's foot. (*)
            Solid line.

Section 3
            (Answer all questions in this section)

31.       Relationship Cardinality is important. True or False?   Mark for Review
(1) Points
            True (*)
            False

Section 4
            (Answer all questions in this section)

32.       Why is it important to identify and document business rules? Mark for Review
(1) Points
            It allows you to create a complete data model and then check it 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

33.       Why is it important to identify and document structural rules?            Mark for Review
(1) Points
            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.

34.       How should you handle constraints that cannot be modeled on an ER diagram?         Mark for Review
(1) Points
            Explain them to the users so they can enforce them
            Always let the network architect handle them
            List them on a separate document to be handled programmatically (*)
            All constraints must be modeled and shown on the ER diagram

35.       A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. True or False?      Mark for Review
(1) Points
            True (*)
            False

36.       All ER diagrams must have one of each of the following: (Choose two)         Mark for Review
(1) Points
                                    (Choose all correct answers)  
            At least one supertype and subtype
            One or more Entities (*)
            Relationships between entities (*)
            Arcs

37.       A subtype is drawn on an ERD as an entity inside the "softbox" of the supertype. True or False?      Mark for Review
(1) Points
            True (*)
            False

38.       A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False?  Mark for Review
(1) Points
            True
            False (*)

39.       A subtype can have a relationship not shared by the supertype. True or False?           Mark for Review
(1) Points
            True (*)
            False

40.       All instances of a subtype may be an instance of the supertype but does not have to. True or False? Mark for Review
(1) Points
            True
            False (*)

Section 5
            (Answer all questions in this section)

41.       If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
(1) Points
            Removable
            Resourceful
            Redundant (*)
            Replicated

42.       What uncommon relationship is described by the statements: "Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE"        Mark for Review
(1) Points
            Many to Many Mandatory
            One to Many Optional
            One to Many Mandatory
            One to One Optional (*)

43.       If two entities have two relationships between them, these relationships can be either _____________ or _____________ .        Mark for Review
(1) Points
            Redundant or Required (*)
            Replicated or Required
            Resourced and Really Good
            Redundant and Replicated

44.       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

45.       When you resolve a M:M by creating an intersection entity, this new entity will always inherit:         Mark for Review
(1) Points
            The UID's from the entities in the original M:M.
            The attributes of both related entities.
            A relationship to each entity from the original M:M. (*)
            Nothing is inherited from the original entities and relationship.

46.       When you resolve a M:M, you simply re-draw the relationships between the two original entities; no new entities are created. True or False?       Mark for Review
(1) Points
            True
            False (*)

47.       If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by        Mark for Review
(1) Points
            Creating new attributes.
            Barring the relationships to the original entities. (*)
            Placing the UID attributes from the original entities into the intersection entity.
            None of the above.

48.       If a relationship can NOT be moved between instances of the entities it connects, it is said to be:      Mark for Review
(1) Points
            Mandatory
            Transferable
            Optional
            Non-Transferable (*)

49.       A non-transferable relationship means the relationship is manatory at both sides. True or False?       Mark for Review
(1) Points
            True
            False (*)

50.       A non-transferable relationship is represented by which of the following symbols?   Mark for Review
(1) Points
            Circle
            Triangle
            Heart

            Diamond (*)