Oracle Test Paper for Revision #1

1) Matrix Diagrams are mandatory when doing data modelling. 

a) True
b) False

2) 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) 

a) Each FOOD TYPE must be suitable for one or more ANIMALs. 
b) Each ANIMAL must be the seller of one or more FOOD TYPES.
c) Each FOOD TYPE may be made from one or more ANIMALs.
d) Each FOOD TYPE may be given to one or more ANIMALs. 

3) One Relationship can be both mandatory and optional at different ends. 

a) True
b) False

4) Matrix Diagrams are used to verify an ERD. 

a) True
b) False

5) Entity names are always singular.

a) True
b) False

6) Arcs are used to visually represent _________ between two or more relationships in an ERD. 

a) Sameness
b) Differences
c) Exclusivity 
d) Inheritance

7) Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. 

a) True
b) False

8) Which of the following is NOT a relationship type? 

a) Some to None 
b) One to One
c) One to Many
d) Many to Many

9) If Audit trail attributes are added to an entity they must be in the entities they are auditing. 

a) True
b) False

10) Modeling historical data can produce a unique identifier that always excludes dates. 

a) True
b) False

11) A recursive relationship must Mandatory at both ends. 

a) True
b) False

12) An arc can also be modeled as Supertype and Subtypes. 

a) True
b) False


Suggested Answers

1) b

2) a, d

3) a

4) a

5) a

6) c

7) b

8) a

9) a

10) b

11) b

12) a

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.