Section 1 1. requirements. Why?

(1) Points The first step in system development is to document the Mark for Review

Wrong. A blueprint for the database design is not needed. We can just st art coding straight away. It clarifies what a business wants to accomplish, and provides measures for deciding if the system delivers all that is required. (*) It allows application development to be conducted without having to cons ider database design. It keeps businesses honest.

Correct

Correct

2. Consider your school library. It will have a database wi th transaction details of which student borrows which books. Is a record of one student borrowing one book Data or Information? Mark for Review (1) Points Data (*) Information Both Neither

Correct

Correct

3. Consider your school library. It will have a database wi th transaction details of which student borrows which books. Is details of the t otal number of books out on loan in one given month Data or Information? Mark for Review (1) Points Data Information (*)

Both Neither

Correct

Correct

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

Correct

Correct

5. Oracle Database Software provides which of the following functionality? (Choose two) Mark for Review (1) Points (Choose all correct answers) Graphical User Interface (*) Internet Browser Server (*) Operating System

Correct

Correct 6. Which of the following are types of databases? Mark for

Review (1) Points (Choose all correct answers)

Hierarchical (*) Relational (*) SQL Network (*)

Incorrect

Incorrect. Refer to Section 1

Section 2 7. Volatile entities have special requirements and need spe cial attention when you are doing data modelling. True or False? Mark for Review (1) Points True (*) False

Correct

Correct

8. The entity/relationship model is created before the phys ical database design model? True or False? Mark for Review (1) Points True (*) False

Correct

Correct

9. In a physical data model, a relationship is represented as a? Mark for Review (1) Points Column

Row Instance Foreign Key (*)

Correct

Correct 10. An entity is instantiated as a ? Mark for Review

(1) Points Experience Instance Table (*) None of the above

Correct Section 2

Correct

11. All of the following could be attributes of an ENTITY ca lled PERSON except one. Select the incorrect one: Mark for Review (1) Points Haircolor Weight Gender Natacha Hansen (*)

Correct

Correct

12. All of the following are examples of ENTITY: Instance ex cept two. Select the answers that are ENTITY: Instance. (Choose Two) Mark for Review (1) Points (Choose all correct answers)

TRANSPORTATION METHOD: Car (*) ANIMAL: Dog (*) MEAT PRODUCT: Lettuce BODY PART: Larry Ellison

Correct

Correct

13. All of the following would be instances of the entity AN IMAL SPECIES except which? Mark for Review (1) Points Dog Bird Elephant Leaf (*)

Correct

Correct

Section 3 14. . True or False? (1) Points True False (*) Two entities can ONLY have one relationship between them Mark for Review

Incorrect

Incorrect. Refer to Section 3

15. Relationship Degree/Cardinality is important. True or Fa lse? Mark for Review (1) Points

True (*) False

Correct

Correct 16. Which of the following are valid relationship degrees

Mark for Review (1) Points (Choose all correct answers) 1:1 (*) 1:M (*) 1:O O:O

Correct

Correct

17. Entity Boxes are drawn with 90 degree angles, also known as Hard Boxes. True or False? Mark for Review (1) Points True False (*)

Correct

Correct

18. All the Attributes in a system are just written on the E RD, and they all go in the Top Left Hand Corner of the paper. True or False? Mark for Review (1) Points True False (*)

Correct

Correct

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

Correct

Correct 20. Which of the following is true about subtypes? Mark for

Review (1) Points One instance may belong to two subtypes of the same supertype. Subtypes must be mutually exclusive. (*) Subtypes must not be mutually exclusive. Subtype entities may not have relationships to the other subtype entitie s, only the supertype itself.

Correct Section 4 or False? (1) Points True

Correct 21. A supertype can only have two subtypes and no more. True Mark for Review

False (*)

Correct

Correct

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

Correct

Correct

23. Which of the following are suitable Entity names? (Choos e Two) Mark for Review (1) Points (Choose all correct answers) DOGS ANIMAL (*) ANIMALS DOG (*)

Correct

Correct

24. Business rules are important to data modelers. True or F alse? Mark for Review (1) Points True (*) False

Correct

Correct

25. How would you model a business rule that states that gir ls and boys may not attend classes together? Mark for Review (1) Points Use a supertype Use two subtypes with relationships from class to student gender (*) Make the attribute Gender mandatory You cannot model this. You need to document it

Incorrect

Incorrect. Refer to Section 4

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

Correct

Correct 27. Can all constraints be modeled on an ER diagram?

Mark for Review (1) Points No, in which case you should let the database administrator handle them 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, so you should list them on a separate document to be handled program matically (*)

Incorrect

Incorrect. Refer to Section 4

Section 5 28. A Diamond on a relationship indicates the Relationship a s Non-Tranferrable. True or False? Mark for Review (1) Points True (*) False

Correct

Correct

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

30. A relationship from an entity back to itself is called a ___________ relationship. Mark for Review (1) Points Mandatory Recursive (*) Many to Many Optional Transferrable

Correct

Correct Section 5

31. 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 TREE and BRANCH PERSON and FINGERPRINT TEACHER and SUBJECT AREA (*)

Incorrect

Incorrect. Refer to Section 5

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

Correct

Correct

Section 6 False? (1) Points True False (*) 33. All entities must be given a new artificial UID. True or Mark for Review

Correct

Correct 34. 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 no attritibutes are mutually independant and fully independent on t he primary key. When no attritibutes are mutually independent and all are fully dependen t on the primary key. None of the Above.

Correct

Correct

35. An entity without repeated values is said to be on 1st N ormal Form. True or False? Mark for Review (1) Points True (*) False

Correct

Correct

Section 7 36. Mark for Review (1) Points True False (*) No parts of an UID are mandatory. True or False?

Correct

Correct 37. An arc can also be modelled as Supertype and Subtypes. T Mark for Review

rue or False? (1) Points True (*) False

Correct

Correct 38. Which of the following is NOT a relationship type?

Mark for Review (1) Points Some to None (*) One to One One to Many Many to Many

Correct

Correct

39. Which of the following would best be represented by an a rc? Mark for Review (1) Points TEACHER (Female, Bob) DELIVERY ADDRESS (Home, Office) (*) PARENT (Girl, Bob) STUDENT (Grade A student, Average Student)

Correct

Correct

40. Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False? Mark for Review (1) Points True False (*)

Correct Section 7

Correct

41. If Audit trail attributes are added to an entity they mu st be in the entities they are auditing. True or False? Mark for Review (1) Points True (*) False

Correct

Correct

42. Which of the following would be good as a Unique Identif ier for its Entity? (Choose Three) Mark for Review (1) Points (Choose all correct answers) Personal Identification number for Person (*) Vehicle Registration Number for Car (*) ISBN Number for Book (*) Date of birth for Baby

Correct

Correct

Section 8 43. Consultants often use their experience in ensuring proje cts stay on track and delivers within the timescales set out for the project. Tr ue or False? Mark for Review (1) Points True (*) False

Correct

Correct

44. Your apperance at a presentation is important. You need to look smart and presentable. True or False? Mark for Review (1) Points True (*) False

Correct

Correct

Section 10 45. When you add the concept of time to your data model, you r model becomes more complex. True or False? Mark for Review (1) Points True (*) False

Correct

Correct 46. There is only one way to model time in a Data Model. Tru Mark for Review

e or False? (1) Points True

False (*)

Correct

Correct

47. Which of the following would be a logical constraint whe n modeling time for a City entity? Mark for Review (1) Points People are born in the city and people die in the city. Cites may change their name and/or which country they are placed in, if the borders of a country change. (*)

If you are doing a system for any French City, you would need security c learance You need a constant record of cities because they are still cities, even if leadership changes over time, e.g. they get a new Mayor

Incorrect

Incorrect. Refer to Section 10

48. All systems must have an entity called WEEK with a holid ay attribute, so you know when to give your employees a holiday. True or False? Mark for Review (1) Points True False (*)

Correct

Correct

49. All systems must include functionality to provide loggin g or journaling in conceptual data models. True or False? Mark for Review (1) Points True False (*)

Correct

Correct

50. Why would you want to model a time component when design ing a system that lets people buy shares via the Internet? (Choose Two) Mark for Review (1) Points (Choose all correct answers) This would only be required in the US to allow the New York Stock Exchan ge to be notified of this information To allow the sales people to determine when the shares were bought and t herefore at what price. (*) You would not want to model this, it is not important.

The price of shares fluctuates and for determining price, you need to kn ow the time of purchase (*)

Correct

Correct