Database Foundations Midterm Exam

Test: Database Foundations Midterm Exam

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1
(Answer all questions in this section)
1. What is the difference between "information" and "data"?
Mark for Review
(1) Points
Information and data have no differences - they are two words for the same
thing.
Information is held and understood only by users.

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

systems and users. (*)
Data is held and understood only by users.

Correct
2. A database is a centralized and structured set of data stored on a computer system
and provides facilities for retrieving, adding, modifying, and deleting the data when Mark for Review
required. (1) Points

True (*)

False

Correct
3. In the relational database model, each table name must be unique. The column
names in the table must be unique too. You can have two different tables that have Mark for Review
column names that are similar. (1) Points

True (*)

False

Correct
4. The advantages of object-oriented data model are:
Mark for Review
(1) Points
Reduced Maintenance

Real-World Modeling

Both (*)

None

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

False

Correct
Page 1 of 10 Next Summary

Test: Database Foundations Midterm Exam

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1
(Answer all questions in this section)
6. A database can be considered only from a physical storage perspective.
Mark for Review
(1) Points
True

False (*)

Correct
7. The Oracle Database stores data logically in tablespaces, and physically in
datafiles associated with the corresponding tablespace. Mark for Review
(1) Points
True (*)

False

Correct
8. The smallest logical storage unit of a database is ...
Mark for Review
(1) Points
Data Blocks (*)

Tablespaces

Segments

Extents

Correct
9. The main subject areas taught by the Oracle Academy are:
Mark for Review
(1) Points
Data Modeling, SQL, and PL/SQL (*)

Computer Repairs

Systems programming and computer architecture

Database performance tuning

Correct
10. Data Integrity ensures the duplication of information.
Mark for Review
(1) Points
True

False (*)

Correct
Previous Page 2 of 10 Next Summary

Test: Database Foundations Midterm Exam

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1
(Answer all questions in this section)
11. In a relational database a table is referred to as ..
Mark for Review
(1) Points
Cardinality

Relation (*)

Attribute

None

Correct
12. Business rules help you understand the standardization procedure an organization
follows when handling huge data. Mark for Review
(1) Points
True (*)

False

Correct
13. Business rules are used to understand business processes, and the nature, role,
and scope of the data. Mark for Review
(1) Points
True (*)

False

Correct

Section 2
(Answer all questions in this section)
14. An entity may have which of the following?
Mark for Review
(1) Points
Experiences

Instances (*)

Tables

None of the above

Correct
15. The transformation from an ER diagram to a physical design involves changing
terminology. Secondary Unique Identifiers become Mark for Review
(1) Points
 Unique Constraints (*)

Primary Key Constraints

Columns

Tables

Correct

Previous Page 3 of 10 Next Summary

Test: Database Foundations Midterm Exam

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2
(Answer all questions in this section)
16. A/an _________ is a piece of information that in some way describes an entity. It
is a property of the entity and it quantifies, qualifies, classifies, or specifies the Mark for Review
entity. (1) Points

ERD

Table

Process

Attribute (*)

Correct
17. Primary Key can contain null values.
Mark for Review
(1) Points
True

False (*)

Correct
18. What is the purpose of a Unique Identifier?
Mark for Review
(1) Points
Create an entity that is unlike any other entity aside from itself.

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

and/or relationships. (*)
To uniquely determine a table and columns within that table.

To identify a specific row within a table, using one or more columns and/or
foreign keys.
Correct
19. One-to-One relationships are transformed into Foreign Keys in the tables created
at either end of that relationship. True or False? Mark for Review
(1) Points
True

False (*)
 Correct
20. A foreign key cannot refer to a primary key in the same table. True or False?
Mark for Review
(1) Points
True

False (*)

Correct

Previous Page 4 of 10 Next Summary

Test: Database Foundations Midterm Exam

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2
(Answer all questions in this section)
21. The Physical Model is derived from the Conceptual Model. True or False?
Mark for Review
(1) Points
True (*)

False

Correct
22. Data modeling is performed for the following reasons: (Choose Two)
Mark for Review
(1) Points
(Choose all correct answers)
The ERD becomes a blueprint for designing the actual system. (*)

It helps discussions and reviews. (*)

We do not need datamodels; we can just start coding right away.

We draw an ERD solely to please the users; once completed, the ERD is
never referred to again as it serves no purpose in the real world.
Correct
23. Many reasons exist for creating a conceptual model. Choose three appropriate
reasons from the options below. Mark for Review
(Choose 3) (1) Points

(Choose all correct answers)

They model functional and informational needs. (*)

They capture current and future needs. (*)

They capture the implementation details of the physical model.

They model the information flow of data.

They accurately describe what a physical model will contain. (*)

Correct
 24. In the relational model, data is organized in two-dimensional tables called
___________. Mark for Review
(1) Points
Relations (*)

Row

Tuples

Field

Correct
25. A table must have a primary key. True or False?
Mark for Review
(1) Points
True

False (*)

Correct

Previous Page 5 of 10 Next Summary

Test: Database Foundations Midterm Exam

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2
(Answer all questions in this section)
26. Flat file databases are generally in plain-text form, where each line holds only one
record. True or False? Mark for Review
(1) Points
True (*)

False

Correct
27. Flat file databases avoids data duplication. True or False?
Mark for Review
(1) Points
True

False (*)

Incorrect. Refer to Section 2 Lesson 1.

Section 3
(Answer all questions in this section)
28. Age is a Non-volatile attribute. True or False.
Mark for Review
(1) Points
True

False (*)

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

False

Correct
30. A unique identifier must be made up of more than one attribute. True or False?
Mark for Review
(1) Points
True

False (*)

Correct

Previous Page 6 of 10 Next Summary

Test: Database Foundations Midterm Exam

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 3
(Answer all questions in this section)
31. 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 Mark for Review
(1) Points
descriptive "number". So, to be able to uniquely and efficiently identify one
instance of the entity SHOE, a/an ______________ UID can be created.
Artificial (*)

Unrealistic

Identification

Structured

Correct
32. 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) Mark for Review
(1) Points
(Choose all correct answers)
Each FOOD TYPE may be given to one or more ANIMALs. (*)

Each FOOD TYPE may be made from one or more ANIMALs.

Each ANIMAL must be the seller of one or more FOOD TYPES.

Each FOOD TYPE must be suitable for one or more ANIMALs. (*)

Correct
33. A Matrix Diagram should be developed by the end-users of your database. True or
False? Mark for Review
(1) Points
 True

False (*)

Correct
34. Matrix Diagrams are used to verify that all relationships have been identified for an
ERD. True or False? Mark for Review
(1) Points
True (*)

False

Correct
35. Relationships represents something of significance to the business. True or False?
Mark for Review
(1) Points
True (*)

False

Correct

Previous Page 7 of 10 Next Summary

Test: Database Foundations Midterm Exam

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 3
(Answer all questions in this section)
36. Documenting Business Requirements helps developers control the scope of the
system and prevents users from claiming that the new system does not meet their Mark for Review
business requirements. True or False? (1) Points

True (*)

False

Correct
37. The Physical Model is derived from the Conceptual Model. True or False?
Mark for Review
(1) Points
True (*)

False

Correct
38. Would it be a good idea to model age as an attribute of STUDENT?
Mark for Review
(1) Points
Yes

No - it breaks the Normalization rules (*)

Yes, it would prevent our having to calculate someone's age every time we
need it.
 Sometimes, but not all of the time

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

False

Correct
40. If Audit trail attributes are added to an entity, they must be in the entities they are
auditing. True or False? Mark for Review
(1) Points
True (*)

False

Correct

Previous Page 8 of 10 Next Summary

Test: Database Foundations Midterm Exam

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 3
(Answer all questions in this section)
41. Which of the following would be a logical constraint when modeling time for a City
entity? Mark for Review
(1) Points
Cites may change their names and/or country association if the borders of a
country change. (*)
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.

If you are doing a system for any French City, you would need security
clearance.
Correct
42. Why is it important to identify and document structural rules?
Mark for Review
(1) Points
Ensures we know what data to store and how that data works together. (*)

Ensures nothing. There are no benefits to be gained from documenting your

Structural Business Rules. We need to concentrate on the Procedural
Business Rules only.
Ensures we know what processes are in place and how to program them.

All of the Above.

Correct
43. Business rules are important to data modelers. True or False?
Mark for Review
 (1) Points
True (*)

False

Correct
44. "Only teachers may supervise exams" is an example of which of the following?
Mark for Review
(1) Points
An attribute that should be stored on the PERSON entity

A procedural business rule (*)

A structural business rule

An attribute that is not be inherited from the PERSON supertype and is

unique to the TEACHER subtype
Correct
45. Which of the following is true about subtypes?
Mark for Review
(1) Points
Subtypes should not be exhaustive.

Subtypes must not be mutually exclusive.

Subtypes must be mutually exclusive. (*)

One instance of a supertype may belong to two subtypes.

Correct

Previous Page 9 of 10 Next Summary

Test: Database Foundations Midterm Exam

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 3
(Answer all questions in this section)
46. A supertype can only have two subtypes and no more. True or False?
Mark for Review
(1) Points
True

False (*)

Correct
47. Entity Boxes are drawn with 90 degree angles, also known as Hard Boxes. True or
False? Mark for Review
(1) Points
True

False (*)

Incorrect. Refer to Section 3 Lesson 3.

 48. A single relationship can be both Recursive and Hierachal at the same time. True
or False? Mark for Review
(1) Points
True

False (*)

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

Sameness

Inheritance

Differences

Correct
50. An arc can also be modeled as Supertype and Subtypes. True or False?
Mark for Review
(1) Points
True (*)

False

Correct

Previous Page 10 of 10 Summary