Oracle Databases Quiz Section seven Test Answer

Oracle Databases Quiz Section seven Test Answer

step one. Which of the pursuing the manage greatest be portrayed because of the an arc? Beginner (elderly, male) Beginner (Stages A student, Average Pupil) Scholar (graduating, female) Pupil ( College, Technology University) (*)

2. Arcs try Required from inside the Research acting. All of the ERD’s have to have one Arc. Genuine otherwise Incorrect? True-false (*)

step 3. To help you aesthetically show exclusivity anywhere between 2 or more relationship when you look at the an ERD you’ll probably play with an ________ Arc (*) Relationships Characteristic UID

5. And this of one’s following manage best end up being illustrated because of the an arc? Teacher (Ladies, Bob) Mother (Woman, Bob) Birth Address (House, Office) (*) College student (Grade Students, Mediocre Pupil)

A specific problem can be set having fun with often an excellent Recursive Dating otherwise an excellent Hierarchical Relationship, whether or not perhaps not meanwhile

7. Every business provides restrictions on what trait opinions and you may which relationships are permitted. These are known as: Restrictions. (*) Relationship Organizations. Characteristics

8. Arcs are used to aesthetically depict _________ between a couple of relationship inside the an enthusiastic ERD. Differences Genetics Sameness Exclusivity (*)

9. Streaming UIDs was a component have a tendency to used in what sort of Relationships? Invalid Relationship Recursive Relationships Standard Relationships Hierarchical Dating (*)

ten. A love ranging from an organization and you may itself is entitled a good/an: Recursive Matchmaking (*) Invalid Matchmaking Heirarchical Dating General Matchmaking

11. A beneficial Recursive Relationships was depicted with the an ERD by good/an: Single Toe Pig’s Ear (*) Crow’s Ft Pet’s End

a dozen. One matchmaking will be one another Recursive and you can Hierarchical on exact same time. Correct or Incorrect? True-false (*)

2. An individual relationships are going to be both Recursive and you can Hierarchical in the exact same go out. Correct or Not true? True false (*)

3. A beneficial Recursive Relationships are portrayed on a keen ERD by the good/an: Solitary Bottom Dog’s End Pig’s Ear canal (*) Crow’s Foot

5. A love anywhere between an entity and itself is named a beneficial/an: General Relationships Recursive Relationships (*) Heirarchical Relationship Invalid Relationship

6. Good Hierarchical relationships are a series of matchmaking one to reflect entities planned towards straight accounts. Genuine or Untrue? Genuine (*) Incorrect

eight. Streaming UIDs try an element usually found in what type of Matchmaking? Recursive Relationships Standard Matchmaking Incorrect Dating Hierarchical Dating (*)

8. And therefore of your own adopting the do greatest be illustrated of the an arch? College student (elder, male) Pupil ( School, Technical School) (*) Student (Amount A student, Average Student) Scholar (graduating, female)

nine. So you’re filipinocupid ekЕџi able to aesthetically portray uniqueness anywhere between two or more relationship into the a keen ERD you would most likely fool around with an ________. Relationships Arc (*) UID Characteristic

12. Arcs are accustomed to visually show _________ anywhere between 2 or more matchmaking in the a keen ERD. Sameness Distinctions Exclusivity (*) Genetics

thirteen. And therefore of following the can be set in a relationship? A recommended characteristic are going to be authored A chemical trait An attribute An arc is going to be assigned (*)

14. And this of your after the would most readily useful end up being portrayed from the an arc? Professor (Females, Bob) Student (Values A student, Average College student) Birth Target (Family, Office) (*) Father or mother (Girl, Bob)

1. A relationship anywhere between an entity and is actually entitled a great/an: Incorrect Relationship Recursive Relationships (*) General Matchmaking Hierarchical Relationship

step 3. A great Hierarchical matchmaking are some relationships you to echo organizations arranged into successive profile. Correct otherwise Not the case? Correct (*) False

cuatro. One relationships is going to be each other Recursive and Hierarchical on exact same time. Real otherwise False? True-false (*)

eight. An effective Recursive Matchmaking are represented on the an ERD by good/an: Solitary Bottom Pig’s Ear (*) Crow’s Foot Pet’s Tail

8. And that of your own following shall be added to a love? An arch are assigned (*) A recommended attribute should be authored A characteristic A chemical characteristic

nine. Every single business possess limits about what trait values and you will and that dating are allowed. Talking about known as: Features Restrictions. (*) Organizations. Relationship

10. And this of your adopting the perform finest be represented by the an arch? Teacher (Girls, Bob) Beginning Address (Domestic, Office) (*) Mother (Girl, Bob) Beginner (Stages A student, Average Pupil)

Feature Relationship UID Arch (*)

12. Arcs is Compulsory during the Investigation acting. Every ERD’s must have one or more Arch. Real otherwise False? True false (*)

13. In order to aesthetically show uniqueness between 2 or more matchmaking within the an enthusiastic ERD might probably have fun with an enthusiastic ________.

cuatro. And therefore of the following the carry out top feel portrayed by an arch? College student (Grade Students, Average College student) Professor (Girls, Bob) Delivery Target (Home, Office) (*) Parent (Lady, Bob)

5. To help you aesthetically show uniqueness anywhere between a couple of dating in the an enthusiastic ERD you might probably have fun with an enthusiastic ________. UID Arc (*) Trait Dating

6. Which of the following the do most readily useful be depicted from the an arch? Beginner (graduating, female) Student ( University, Technology School) (*) Beginner (Grade Students, Mediocre Student) Pupil (older, male)

7. Arcs are widely used to aesthetically depict _________ between two or more dating in a keen ERD. Uniqueness (*) Variations Heredity Sameness

8. Every single business keeps limits on what feature philosophy and you can and therefore relationship are allowed. Talking about also known as: Entities. Matchmaking Limitations. (*) Characteristics

nine. An individual relationships shall be both Recursive and you will Hierarchical within same time. Real or Not true? True-false (*)

11. Flowing UIDs is a component have a tendency to included in what sort of Matchmaking? Recursive Relationship Standard Relationships Hierarchical Matchmaking (*) Incorrect Relationship

12. An effective Hierarchical relationship try a few matchmaking one mirror organizations arranged to the straight profile. True otherwise Not the case? Correct (*) Not true

13. Good Recursive Relationships is portrayed into the an enthusiastic ERD of the a/an: Crow’s Base Single Toe Pig’s Ear canal (*) Pet’s Tail