Quiz 1

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

 False. Business requirements can and will change. For instance new legal requirements
may arise. (*)

2. Business rules are important because_________.

 They allow the developer to understand the relationship and constraints of the participating entities

3. Documenting Business Requirements helps developers control the scope of the system and prevents
users from claiming that the new system does not meet their business requirements. True or False?

 True

4. When completing the conceptual modeling process we must take into account the following:
 All of the above

5. All Business Rules can be modeled.

 True

6. In a _______ database model the data is organized into a tree-like structure and to retrieve data the
whole tree needs to be traversed starting from the root node.

 Hierarchical

7. A ___________ model describes a database in terms of tables, columns, and joins between tables.
 Relational

8. In a hierarchical database model the data is stored as records that are connected to one another
through ________.

 links

9. A flat file may contain many fields, often, with duplicate data that are prone to data corruption.
 True

10. The transformations that have occurred in the computing world progressing in this order:
 Desktop computing, Grid computing, Client/Server computing, Mainframe computing. // ragu

11. What is the difference between "information" and "data"?

 Data turns into useful information. It is stored in a database and accessed by systems
and users.

12. Which of the following transformations in computing led to the increase in graphical user interface
(GUI) applications ?

 Desktop Computing

13. Which transformation in computing allows for storage and delivery of applications and data over the
internet?

 Cloud Computing

14. SQL *Plus is being used in the Oracle Academy courses to run SQL code. True or False?
  True

15. The main subject areas taught by the Oracle Academy are:
 Data Modeling, SQL, and PL/SQL

Score: 12 out of 15
Percentage Scored: 80 %
Mastery Score: 70 %
 Quiz 2

1. The __________ model includes entities, attributes, UIDs, relationships as well as optionality and
cardinality of these items.

 Logical

2. When mapping a relationship for an ERD diagram both sides of the relationship have to be mapped.
 True

3. Which of the following is not a goal of ER modeling:

 It is acceptable to include information that is derivable.

4. A conceptual model includes :

 Only Entities and Relationships

5. Which of the following are reasons we create conceptual models?

 All of the above

6. Primary UIDs are:

 Mandatory in data modeling

7. A Unique Identifier has a NULL value for each instance of the entity for the lifetime of the instance. True
or False

 False

8. Each column in a relation is called an entity. True or False?

 False

9. A relational database stores information in tables with rows and columns.

 False

10. Which of the attributes is a volatile attribute?

 age

11. When creating entities in a logical model you must follow these rules: (Choose Two)
 Name them in singular, and include attributes

12. In this course, we use the __________ notation for ERD modeling.
 None of the above

13. One-to-Many relationships have cardinality of one or more in both directions. True or False?
 False

14. In a relationship , _________ are used to helped describe the meaning of the connection between the
entities.

 Arrows

15. The cardinality of a relationship can be _____________. (Choose two)

 One to one, and one and only one
 Score: 11 out of 15
Percentage Scored: 73.3 %
Mastery Score: 70 %
 Quiz 3

Section 3 Quiz
(Answer all questions in this section)

1. A ___________ relationship is created when the UID for an entity includes the
relationship with another entity. Mark for Review
(1) Points

barred

recursive

many to many

one to one

2. Which of the following statements about subtypes is not true?

Mark for Review
(1) Points

Inherits all attributes of the supertype.

Never exists alone.

Inherits all relationships of the supertype.

Must have subtypes of its own.

3. All ER diagrams must have one of each of the following: (Choose two)
Mark for Review
(1) Points

(Choose all correct answers)

Relationships between entities

One or more Entities

Arcs

At least one supertype and subtype

4. Transferable relationships can only be mandatory, not optional. True or False?

Mark for Review
(1) Points

True

False

5. An arc can also be modeled as Supertype and Subtypes. True or False?

Mark for Review
(1) Points

True
False
 6. Which of the following is not true regarding
normalization: Mark for Review
(1) Points

It is the process of organizing the attributes

and tables of a relational database to
minimize redundancy.
It helps with the performance of the
database.
It does not impact the performance of
the database.
It assists in handling insert, update and
delete anomalies.

7. When data is only stored in one place in a

database, the database conforms to the rules of Mark for Review
___________. (1) Points

Multiplication

Reduction

Normalization

Normality

8. 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

9. Would it be a good idea to model age as an

attribute of STUDENT? Mark for Review
(1) Points

Yes, it would prevent our having to calculate

someone's age every time we need it.
Sometimes, but not all of the time

Yes

No - it is a volatile attribute

10. 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.

11. Which of the following would be a logical constraint when modeling time for a City
entity? Mark for Review
(1) Points

Daily traffic patterns must be monitored to determine how many law

enforcement officers are needed.
People are born in the city and people die in the city.

Cites may change their names and/or country association if the

borders of a country change.
If you are doing a system for any French City, you would need security
clearance.

12. Which of the following scenarios should be modeled so that historical data is kept?
(Choose two) Mark for Review
(1) Points

(Choose all correct answers)

CUSTOMER and PAYMENTS

BABY and AGE

TEACHER and AGE

CUSTOMER and ORDERS

13. Attribute names are converted to column names by _________________.

Mark for Review
(1) Points

Replacing numbers with letters.

Replacing spaces with underscores.

Replacing periods with commas.

Replacing underscores with dashes.

14. _____________ are converted to rows in the physical design.

Mark for Review
(1) Points

columns

entities

instances

attributes

15. The transformation from an ER diagram to a physical design involves changing

terminology. Secondary Unique Identifiers become _____. Mark for Review
(1) Points

Columns
Tables

Unique Constraints

Primary Key Constraints

Score: 11 out of 15
Percentage Scored: 73.3 %
Mastery Score: 70 %