1.

Today, Mark for Review

all
industries (1) Points
have a
need for
database
systems.
True or
False?

True (*)
False

Correct

2. Which of the following transformations in computing led to the increase in Mark for Review
graphical user interface (GUI) applications?
(1) Points

Desktop computing (*)

Client/Server Computing
Mainframe computing
Grid Computing

Correct

3. Information is the result of combining, comparing and performing calculations on Mark for Review
data.
(1) Points

True (*)
False

Correct

4. A DBMS comprises of the following elements: (Choose 3) Mark for Review

(1) Points

(Choose all correct answers)

Data Dictionary (*)

Query language (*)
Client
Memory and Storage Management (*)

Correct
 5. The Oracle Academy courses are intended for self study. True or False? Mark for Review
(1) Points

True
False (*)

6. The Mark for Review

main
subject (1) Points
areas
taught
by the
Oracle
Academy
are:

Computer Repairs
Database performance tuning
Data Modeling, SQL, and PL/SQL (*)
Systems programming and computer architecture

Correct

7. A ___________ model describes a database in terms of tables, columns, and joins Mark for Review
between tables.
(1) Points

Network
Hierarchical
Relational (*)
Object Oriented

Correct

8. A network database comprises of a collection of records connected to one another Mark for Review
through links.
(1) Points

True (*)
False

Correct

9. In a hierarchical database model the data is stored as records that are connected Mark for Review
to one another through ________.
(1) Points
 links (*)
primary keys
databases
fields

Correct

10. The advantages of an object-oriented data model are: Mark for Review
(1) Points

Reduced Maintenance
Real-World Modeling
Both A and B. (*)
Neither A or B.

Correct

11. If information Mark for Review

requirements
are clearly (1) Points
communicated
during
conceptual
modeling the
following will
result:

Delays due to reworking model caused by incorrect assumptions

A well designed conceptual model (*)
A conceptual model that does not fully reflect the business will be
created.
Some business rules may not be taken into account

Correct

12. Business rules are important because_________. Mark for Review

(1) Points

They are complex and difficult to understand.

They allow the developer to understand the relationship and
constraints of the participating entities (*)
They can become outdated quickly.
They can all be incorporated into the database design structure.

Correct
 13. All Business Rules can be modeled. Mark for Review
(1) Points

True
False (*)

Incorrect. Refer to Section 1 Lesson 4.

14. The reason or drive for using databases rather than files has been … Mark for Review
(Choose 3)
(1) Points

(Choose all correct answers)

Availability of data to a diverse set of users (*)

Integration of data for easier access and modification for complex
transactions (*)
Use of blocks
Reduced redundancy of data (*)

Correct

15. Once you have learned how to write programs and build systems, you no Mark for Review
longer need any input or involvement from any users as you are perfectly
capable of delivering the systems that businesses need and want. (1) Points

True. The only requirement for creating a perfect system is a perfect

programmer.
True. Users delay the delivery of a system by changing their minds and
adding new requirements.
True. Users never know what they want anyway, so building systems is
best left to the professionals.
False. Business requirements can and will change. For instance new
legal requirements may arise. (*)

Correct

16. The Mark for Review

Physical
Model (1) Points
is
derived
from
the
Logical
Model.
True or
False?
 True (*)
False

Correct

17. The logical model becomes the blueprint for designing the ________ model Mark for Review
(1) Points

Network
Data Flow
Physical (*)
Data Integrity

Correct

18. The logical model's entities, attributes, unique identifiers and relationships map to Mark for Review
the physical model's _________________.
(1) Points

Files, records, fields and data values

Optionality and Cardinality
Tables, columns, primary keys and foreign keys (*)

Correct

19. Entity Boxes are drawn on an ERD using what type of shape? Mark for Review
(1) Points

Diamonds
Soft Boxes (*)
Rectangles
Hard Boxes

Correct

20. Entities are usually _____________. Mark for Review

(1) Points

Nouns (*)
Verbs
Adverbs
Adjectives
 Correct

21. To Mark for Review

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

True (*)
False

Correct

22. Which of the following statements about attributes are true? (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)

They are the primary container for data.

They are often adjectives. (*)
They must be single valued unless they belong to more than one entity.
They describe, qualify, quantify, classify, or specify an entity. (*)

Correct

23. People are not born with “numbers”, but a lot of systems assign student Mark for Review
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 (1) Points
one instance of the entity SHOE, a/an ______________ UID can be created.

Structured
Identification
Unrealistic
Artificial (*)
 Correct

24. The candidate UID that is chosen to identify an entity is called the Primary UID; Mark for Review
other candidate UIDs are called Secondary UIDs.
(1) Points

No, it is not possible to have more than one UID for an Entity.
No, each Entity can only have one UID, the secondary one.
No, after UIDs are first sorted, the first one is called the Primary UID, the
second is the Secondary UID, etc.
Yes, this is the way UID's are named. (*)

Correct

25. A Unique Identifier has a NULL value for each instance of the entity for the Mark for Review
lifetime of the instance. True or False
(1) Points

True
False (*)

Correct

26. What is Mark for Review

the
purpose (1) Points
of a
Unique
Identifier?

To identify one unique instance of an entity by using one or more attributes

and/or relationships. (*)
Create an entity that is unlike any other entity aside from itself.
To identify a specific row within a table, using one or more columns and/or
foreign keys.
To uniquely determine a table and columns within that table.

Correct

27. The conceptual model does all of the following except: Mark for Review
(1) Points

Takes into account regulations and laws goverining the industry being
addressed.
Documents type of operating system to be used. (*)
Describes the needs of the business.
Prevents mistakes and misunderstandings.
 Correct

28. In an ERD diagram how is cardinality represented ? (Choose two) Mark for Review
(1) Points

(Choose all correct answers)

With a crow's foot (*)

With a dotted line
With a single toe (*)
With a solid line

Correct

29. ERDish is a language used to create database structures in SQL Mark for Review
(1) Points

True
False (*)

Correct

30. When mapping a relationship for an ERD diagram both sides of the relationship Mark for Review
have to be mapped.
(1) Points

True (*)
False

Correct

31. A _____ Mark for Review

is a type
of (1) Points
database
that
stores
data in a
single
table.

Hierarchical
Network
Relational
 Flat file (*)

Correct

32. What does single table refer to? (Choose Two) Mark for Review
(1) Points

(Choose all correct answers)

A fully-relational database system like Microsoft's SQL Server or Oracle's

database systems.
A database where all of the data is stored in one large table. (*)
Non-relational systems that typically store each table and index in separate
files and often do not support the SQL language. (*)
A type of database storage method where all of the data elements are
stored on top of each other.

Correct

33. A foreign key is a column or combination of columns in one table that uniquely Mark for Review
identifies a row of another table.
(1) Points

True (*)
False

Correct

34. A relationship can be between ____________. Mark for Review

(1) Points

two entities
an entity and itself
multiple entities
All of the above. (*)

Incorrect. Refer to Section 2 Lesson 5.

35. In a business that sells pet food, choose the best relationship name between Mark for Review
FOOD TYPE and ANIMAL (e.g. dog, horse, or cat). (Choose Two)
(1) Points

(Choose all correct answers)

Each FOOD TYPE may be given to one or more ANIMALs. (*)

Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
 Each ANIMAL must be the seller of one or more FOOD TYPES.
Each FOOD TYPE may be made from one or more ANIMALs.

Correct

36. In an ERD, Mark for Review

optionality is
depicted (1) Points
using
__________.

solid or dashed lines (*)

soft boxes
single toe or crows foot
names of relationships

Correct

Section 3
(Answer all questions in this section)

37. How many subtypes can a supertype have? Mark for Review
(1) Points

two
one
zero
any number (*)

Correct

38. Which of the following statements about subtypes is not true? Mark for Review
(1) Points

Must have subtypes of its own. (*)

Inherits all attributes of the supertype.
Inherits all relationships of the supertype.
Never exists alone.

Correct
 39. Arcs are used to visually represent _________ between two or more Mark for Review
relationships in an ERD.
(1) Points

Differences
Exclusivity (*)
Sameness
Inheritance

Correct

40. Transferable relationships can only be mandatory, not optional. True or Mark for Review
False?
(1) Points

True
False (*)

Correct

41. The Mark for Review

"Other"
subtype is (1) Points
mandatory.
True or
False?

True
False (*)

Correct

42. When converting attribute names to columns __________ are frequently used. Mark for Review
(1) Points

abbreviations (*)
special characters
spaces
numbers

Correct

43. When mapping a barred relationship a primary key and foreign key can be the Mark for Review
same field.
(1) Points
 True (*)
False

Correct

44. In a physical data model, a relationship is represented as a combination of: Mark for Review
(Choose Two)
(1) Points

(Choose all correct answers)

Column
Check Constraint or Unique Key
Primary Key or Unique Key (*)
Foreign Key (*)

Incorrect. Refer to Section 3 Lesson 4.

45. Modeling historical data is optional. True or False? Mark for Review
(1) Points

True (*)
False

Correct

46. A table is in 3NF if it has met all database requirements for both 1NF and 2NF and all Mark for Review
transitive dependencies are eliminated.
(1) Points

True (*)
False

Correct

47. When is an entity in 2nd Normal Form? Mark for Review

(1) Points

When all non-UID attributes are dependent upon the entire UID. (*)
When attributes with repeating or multi-values are removed.
When no attritibutes are mutually independent and all are fully dependent on the
primary key.
 None of the Above.

Correct

48. Can all constraints be modeled on an ER diagram? Mark for Review

(1) Points

No, in which case you should let the database administrator handle them
No, but you just explain them to the users so they can enforce them
Yes, all constraints must be modeled and shown on the ER diagram
No, and those that cannot be modeled should be listed on a separate document to
be handled programmatically (*)

Correct

49. Sources of business rules include all of the following except: Mark for Review
(1) Points

Standards
Operational manuals
Word of mouth (*)
Procedures

Correct

50. Why is it important to follow the rules of normalization? Mark for Review
(1) Points

To reduce redundant data in the existing design

To increase the integrity of data and the design's stability
To eliminate other types of data inconsistencies and anomalies
To identify missing tables, columns, and constraints
All of the above. (*)

Incorrect.
Refer to
Section 3
Lesson 3.