Oracle Test Paper for Revision #6

1) Two entities can ONLY have one relationship between them. True or False? 

a) True
b) False
 

2) Matrix Diagrams are developed BEFORE the ERD. True or False? 

a) True
b) False
 

3) One Relationship can be both mandatory and optional at different ends. True or False? 

a) True
b) False
 

4) Relationship Names are optional. True or False? 

a) True
b) False
 

5) To identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False? 

a) True
b) False
 

6) As a database designer you do not need to worry about where in the datamodel you store a particular attribute, as long as you get it onto the ERD your job is done. True or False? 

a) True
b) False
 

7) People are not born with "numbers", but a lot of systems assign student numbers, customer IDs, etc. 
A shoe has a color, a size, a style, but may not have a descriptive "number". So, to be able to uniquely and efficiently identify one instance of the entity SHOE, a/an ______________ UID can be created. 

a) Artificial 
b) Unrealistic
c) Structured
d) Identification
 

8) All entities must be given a new artificial UID. True or False? 

a) True
b) False
 

9) Any Non-UID must be dependant on the entire UID. True or False? 

a) True
b) False
 

10) When is an entity in 2nd Normal Form? 

a) When all bon-UID attributes are dependent upon the entire UID. (*)
b) When no attritibutes are mutually independant and fully independent on the primary key.
c) When no attritibutes are mutually independent and all are fully dependent on the primary key.
d) None of the Above.
 

11) An entity without repeated values is said to be on 1st Normal Form. True or False? 

a) True
b) False
 

12) When data is only stored in one place in a database, the database conforms to the rules of ___________. 
 
a) Normality
b) Reduction
c) Normalization
d) Multiplication

---

Suggested Answers

1) b

2) b

3) a

4) b

5) a

6) b

7) a

8) b

9) a

10) a

11) a

12) c

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 © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com 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
www.erpgreat.com or the content authors.