Oracle Test Paper for Revision #4

1) All systems must include functionality to provide logging or journaling in conceptual data models. True or False? 

a) True
b) False

2) When you add the concept of time to your data model, your model becomes more complex. True or False? 

a) True
b) False

3) Modeling historical data is Optional. True or False? 

a) True
b) False

4) If a system includes the concept of time and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False? 

a) True
b) False

5) A non-transferable relationship means the detail can be changed to point to a new master. True or False? 

a) True
b) False

6) If two entities have two relationships between them, these relationships can be either _____________ or _____________ ? 

a) Redundant or Required
b) Replicated or Required
c) Resourced and Really Good
d) Redundant and Replicated

7) A relationship from an entity back to itself is called a ___________ relationship. 

a) Mandatory
b) Recursive 
c) Many to Many Optional
d) Transferrable

8) How do you include a relationship as part of the UID for an entity? 

a) By barring the relationship in question 
b) By reporting it in an external document
c) By including the UID from the parent entity as an attribute in the entity
d) You cannot model that.

9) Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False? 

a) True
b) False

10) What do you call the entity created when you resolve a M:M relationship? 

a) Intersection entity 
b) Inclusion entity
c) Recursive entity
d) M:M entity

11) Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? 

a) True
b) False

12) Intersection Entities are at the Master end in the relationships between it and the original entities. So the original entities are details or children of the newly created intersection entity. True or False? 

a) True
b) False


Suggested Answers

1) b

2) a

3) a

4) b

5) b

6) a

7) b

8) a

9) b

10) a

11) a

12) b

Oracle Database

See Also

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of or the content authors.