Oracle Database Test Point 7 Quiz Answer

step 1. Which of your following carry out finest feel represented of the an arch? Pupil (elder, male) College student (Stages A student, Average Pupil) College student (graduating, female) Beginner ( College or university, Technical College) (*)

dos. Arcs try Required into the Research acting. All ERD’s need a minumum of one Arc. Real or Untrue? True false (*)

3. To visually represent uniqueness between a couple of dating into the an ERD you’d probably have fun with a keen ________ Arch (*) Dating Trait UID

5. Hence of your own adopting the perform ideal feel illustrated from the an arch? Teacher (Girls, Bob) Moms and dad (Woman, Bob) Birth Address (House, Office) (*) Pupil (Amount Students, Average Scholar)

A particular condition is generally solved having fun with often an excellent Recursive Dating or a Hierarchical Dating, even when not meanwhile

eight. Every single business keeps limitations on which characteristic viewpoints and and this dating are allowed. Talking about labeled as: Restrictions. (*) Relationship Entities. Functions

8. Arcs are widely used to aesthetically portray _________ between several relationship during the an ERD. Distinctions Genetics Sameness Exclusivity (*)

nine. Streaming UIDs try a feature will found in what kind of Dating? Invalid Relationships Recursive Relationships Standard Relationships Hierarchical Relationships (*)

10. A love between an entity and you can itself is entitled an excellent/an: Recursive Relationship (*) Incorrect Matchmaking Heirarchical Dating General Relationship

eleven. An excellent Recursive Relationship try portrayed towards a keen ERD by the good/an: Unmarried Bottom Pig’s Ear canal (*) Crow’s Legs Dog’s End

twelve. Just one relationship are both Recursive and Hierarchical at the exact same big date. Correct or Untrue? True false (*)

dos. Just one matchmaking would be one another Recursive and Hierarchical on exact same date. True or Not true? True-false (*)

step three. An effective Recursive Dating try portrayed to your an enthusiastic ERD by an effective/an: Solitary Toe Dog’s Tail Pig’s Ear canal (*) Crow’s Feet

5. A love ranging from an organization and you can is actually entitled a good/an: Standard Relationships Recursive Matchmaking (*) Heirarchical Relationship Incorrect Relationship

six. A Hierarchical matchmaking was a few dating you to definitely reflect agencies arranged with the successive account. Correct or Not true? Genuine (*) Incorrect

seven. Streaming UIDs are a component usually utilized in what type of Dating? Recursive Dating General Matchmaking Invalid Relationships Hierarchical Matchmaking (*)

8. And this of one’s adopting the perform most readily useful become illustrated because of the an arch? Beginner (older, male) Pupil ( College, Tech School) (*) Beginner (Level Students, Mediocre Pupil) Student (graduating, female)

9. To help you aesthetically show exclusivity between several dating in the a keen ERD you’ll most likely explore an enthusiastic ________. Matchmaking Arc (*) UID Attribute

a dozen. Arcs are used to visually show _________ between a couple of matchmaking within the a keen ERD. Sameness Differences Exclusivity (*) Heredity

thirteen. Which of one’s after the would be put into a relationship? An elective feature are going to be authored An ingredient feature A feature An arc is going to be assigned (*)

14. And this of following the carry out finest feel illustrated by the an arch? Teacher (Girls, Bob) Beginner (Levels A student, Mediocre Beginner) Beginning Target (Household, Office) (*) Mother or father (Girl, Bob)

step one. A romance anywhere between an organization and you may is called good/an: Invalid Matchmaking Recursive Relationships (*) General Matchmaking Hierarchical Relationships

step three. A good Hierarchical relationships was some relationships one mirror agencies organized into the straight profile. Real or Incorrect? Correct (*) Not true

cuatro. An individual dating is both Recursive and you can Hierarchical within exact same go out. Genuine otherwise False? True-false (*)

7. A great Recursive Relationships try illustrated on an ERD by a beneficial/an: Single Bottom Pig’s Ear (*) Crow’s Legs Dog’s Tail

8. Hence of after the should be put into a love? An arch is going to be assigned (*) A recommended attribute are written A characteristic A compound attribute

9. Every business features restrictions on what characteristic viewpoints and you may and this matchmaking are allowed. Talking about labeled as: Characteristics Constraints. (*) Agencies. Matchmaking

ten. And therefore of your own after the carry out top become depicted by the an arc? Teacher (Lady, Bob) Birth Target (Domestic, Office) (*) Moms and dad (Woman, Bob) Pupil (Degree Students, Mediocre Student)

Attribute Dating UID Arc (*)

12. Arcs is actually Mandatory into the Studies modeling. All of the ERD’s need one Arc. True or False? True-false (*)

13. So you’re able to visually portray uniqueness anywhere between 2 or more relationship in the an enthusiastic ERD you’ll probably have fun with a keen ________.

cuatro. And this of the pursuing the manage finest become portrayed because of the an arch? Pupil (Values Students, Mediocre Pupil) Professor (Female, Bob) Beginning Address (House, Office) (*) Moms and dad (Girl, Bob)

5. To visually portray uniqueness ranging from 2 or more relationship into the a keen ERD you’d most likely use a keen ________. UID Arch (*) Attribute Relationships

six. Which of your adopting the manage finest feel depicted from the an arc? Beginner (graduating, female) Beginner ( School, Tech College) (*) Scholar (Stages A student, Mediocre College student) Scholar (older, male)

7. Arcs are widely used to aesthetically represent _________ anywhere between two or more matchmaking in a keen ERD. Exclusivity (*) Distinctions Heredity Sameness

8. Every single business has actually constraints on what attribute viewpoints and and that relationship are allowed. Speaking of known as: Entities. Dating Restrictions. (*) Services

9. Just one dating can be each other Recursive and you can Hierarchical within exact same time. True or False? True false (*)

11. Streaming UIDs was a feature usually utilized in what kind of Matchmaking? Recursive Relationship General Relationship Hierarchical Matchmaking (*) Invalid Relationship

a dozen. An excellent Hierarchical matchmaking is actually several matchmaking you to definitely reflect organizations organized to your consecutive profile. True otherwise Not the case? Correct (*) Untrue

thirteen. Good Recursive Relationship is depicted into the an ERD by a beneficial/an: Crow’s Base Single Bottom Pig’s Ear get it on indir canal (*) Pet’s End