2013-2015 Oracle Academy English Database Design - Student MID TEST EXAM PART 1

NOTE: RED TEXT IS THE ANSWER Section 1
	(Answer all questions in this section)
		1.	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
		2.	It interacts with, processes, develops, or manipulates the data for document creation.		Mark for Review (1) Points
			Database Server
			Application Server
			Workstation
		3.	What is the difference between "information" and "data"?		Mark for Review (1) Points
			Data is held and understood only by users.
			Information 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.
		4.	Entities are transformed into Tables during the Database Design process. True or False?		Mark for Review (1) Points
			True
			False
	Section 2
	(Answer all questions in this section)
		5.	Volatile attributes have special requirements and need special attention when you are doing data modelling. True or False?		Mark for Review (1) Points
			True
			False
		6.	Which of the following statements about relationships are true? (Choose Two)		Mark for Review (1) Points
			(Choose all correct answers)
			They become foreign keys in the database.
			They must be mandatory to be created in the database.
			They can be either mandatory or optional.
			They must exist between two different Entities.
		7.	A/an _________ is a picture of all the information that will form the basis for the finished system.		Mark for Review (1) Points
			ERD
			Process
			Table
			Attribute
		8.	Which of the following are examples of ENTITY: Instance ? (Choose Two)		Mark for Review (1) Points
			(Choose all correct answers)
			TRANSPORTATION METHOD: Car
			ANIMAL: Dog
			MEAT PRODUCT: Lettuce
			BODY PART: Larry Elliso 9.  Primary Unique Identifiers: (Choose Two)  Mark for Review (1) Points (Choose all correct answers) Are Required. The data model is not complete until all entities have a Primary UID. Distinguish each instance of an entity from all others Are not required You may create more than one Primary Unique Identifier for an entity 10.  Attributes have Instances. True or False?  Mark for Review (1) Points True False Section 2 (Answer all questions in this section) 11.  The Physical Model is derived from the Conceptual Model. True or False?  Mark for Review (1) Points True False Section 3 (Answer all questions in this section) 12.  Two entities can ONLY have one relationship between them. True or False?  Mark for Review (1) Points True False 13.  Matrix Diagrams are developed BEFORE the ERD. True or False?  Mark for Review (1) Points True False 14.  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)  Mark for Review (1) Points (Choose all correct answers) Each FOOD TYPE must be suitable for one or more ANIMALs. Each ANIMAL must be the seller of one or more FOOD TYPES. Each FOOD TYPE may be made from one or more ANIMALs. Each FOOD TYPE may be given to one or more ANIMALs. 15.  Relationships represents something of significance to the business. True or False?  Mark for Review (1) Points True False 16.  All the Attributes in a system are just written on the ERD, and they all go in the Top Left Hand Corner of the paper. True or False?  Mark for Review (1) Points True False Section 4 (Answer all questions in this section) 17.  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 18.  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 19.  A supertype can only have two subtypes and no more. True or False?  Mark for Review (1) Points True False 20.  You can only create relationships to a Supertype, not to a Subtype. True or False?  Mark for Review (1) Points True False 21.  The "Other" subtype is mandatory. True or False?  Mark for Review (1) Points True False 22.  Which of the following are suitable Entity names? (Choose Two)  Mark for Review (1) Points (Choose all correct answers) DOGS ANIMAL ANIMALS DOG Section 5 (Answer all questions in this section) 23.  What do you call the entity created when you resolve a M:M relationship?  Mark for Review (1) Points Intersection entity Inclusion entity Recursive entity M:M entity 24.  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 25.  Intersection Entities are at the Parent end of the newly created 1:M (Parent:Child) relationship; therefore, the original entities are the children of the newly created intersection entity. True or False?  Mark for Review (1) Points True False 26.  A Diamond on a relationship indicates the Relationship as Non-Tranferable. True or False?  Mark for Review (1) Points True False 27.  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 28.  Relationships can be Redundant. True or False?  Mark for Review (1) Points True False 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 30.  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