MASALAH HIDUP

Sebuah Solusi Untuk Hidup Kamu

SECTION 2 QUIZ ORACLE

- October 14, 2019
SECTION 2 QUIZ

BASIS DATA

1. Primary UIDs are:

Optional in data modeling.

Useful as an alternative means of identifying instances of an entity, independent of their

datatype

Always comprised of numbers

Mandatory in data modeling (*)

2. A unique identifier must be made up of more than one attribute. True or False?

True

False (*)

3. In the relational model, relationships between relations or tables are created by using?

Candidate Keys

Composite Keys
Foreign Keys (*)

Primary Keys

 4. A logical model includes :  

Only Entities, Attributes and Unique Identifiers

Only Entities, Attributes and Relationships

Entities, Attributes, Unique Identifiers and Relationships (*)

Only Entities and Relationships

2.  A conceptual model includes :

Only Entities, Attributes and Unique Identifiers

Only Entities and Relationships (*)

Only Entities, Attributes and Relationships

Entities, Attributes, Unique Identifiers and Relationships

3.  Identify all of the incorrect statements that complete this sentence: A primary key is...
(Choose    three)

(Choose all correct answers)

A single column that uniquely identifies each column in a table. (*)

A set of columns in one table that uniquely identifies each row in another table. (*)

One or more columns in a table that uniquely identifies each row in that table.

Only one column that must be null. (*)

4.  Flat file databases avoids data duplication. True or False?

True

False (*)

5.  A candidate UID that does not get chosen to become the primary UID is called a
_________

Secondary UID (*)

Primary UID
Composite UID

Unique UID

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

True

False (*)

7.  A foreign key is a column or combination of columns in one table that uniquely identifies
a row of another table.

True (*)

False

8.  The optionality of a relationship must be either _______ or _______.  

Bidirectional or a single direction

Single or Multiple

Mandatory or Optional (*)

One or (One or More)

9.  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)

(Choose all correct answers)

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

Each FOOD TYPE may be given to 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. (*)

10.  Which symbol is used to show that a particular attribute is mandatory?

* (*)

&
 11. Attributes have Instances. True or False?

True

False (*)

12.  In this course, we use the __________ notation for ERD modeling.

Bachman
Barker (*)

Information Engineering

None of the above

13.  An ERD created using ERDish is a __________ representation of entities and their
relationships to each other.

hierarchical

textual

technical

graphical (*)

14.  Which of the following statements about entity relationship diagrams (ERD) is true?

Used to communicate the technical specifications of the database to users

Used to communicate the logical structure of the database to users. (*)

Used to communicate the physical structure of the database to users.

Is a hard and fast document that cannot be changed once development of the database
has begun.
15.  When mapping a relationship for an ERD relationship names must be included.

True (*)

False

4.  Which of the following statements are true? (Choose two)

(Choose all correct answers)

Flat file database systems pay more attention to retrieving data and making it accessible
to the user, whereas relational databases spend more energy updating indexes and data
pointers.

Relational database systems are the main thrust behind SQL since it provides the
language elements needed to tie together the information in the database. (*)

Flat file database structures help eliminate redundant information.

Relational systems pay more attention to retrieving data and making it accessible to the
user. (*)

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

It facilitates discussion; a picture is worth a thousand words

It forms important ideal system documentation

It takes into account government regulations and laws

It forms a sound basis for physical database design

All of the above (*)

6. A conceptual model includes :

Only Entities and Relationships (*)

Entities, Attributes, Unique Identifiers and Relationships

Only Entities, Attributes and Relationships

Only Entities, Attributes and Unique Identifiers

7.  Which of the following entities most likely contains invalid attributes?

Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of Children

Entity: Pet. Attributes: Name, Birthdate, Owner

Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built

Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed (*)

8.  Which of the following statements about attributes are true? (Choose Two)

(Choose all correct answers)

They describe, qualify, quantify, classify, or specify an entity. (*)

They are often adjectives. (*)

They must be single valued unless they belong to more than one entity.

They are the primary container for data.

9.  Entities are usually _____________.

Nouns (*)

Adjectives

Adverbs

Verbs

10.  A __________ relationship is a relationship between an entity and itself.

Hierarchical

One to one
Recursive (*)

Mandatory

1.     Data models are drawn to show users the actual Data that their new system will
contain; only Data listed on the Diagram can be entered into the Database. True or False?

True

False (*)

2.  ERDish is a language used to create database structures in SQL

True

False (*)

3.  Data modeling is performed for the following reasons: (Choose Two)

(Choose all correct answers)

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.

It helps discussions and reviews. (*)

The ERD becomes a blueprint for designing the actual system. (*)
We do not need datamodels; we can just start coding right away.

4.  Primary UIDs are:

Optional in data modeling.

Mandatory in data modeling (*)

Always comprised of numbers

Useful as an alternative means of identifying instances of an entity, independent of their

datatype

5.  Candidate UIDs must be made up of only one attribute.

True

False (*)

6.    The Physical Model is derived from the Logical Model. True or False?

True (*)

False

7.  In a relational database system, the next step after creating a conceptual data model is
to convert it to a _________ .
An entity-relation data model

External data model

Logical data model (*)

Internal data model

8.  An entity may have which of the following?

Experiences

Instances (*)

Tables

None of the above

9.  Attributes have Instances. True or False?

True

False (*)

10.  Which of the following statements about attributes are true? (Choose Two)

(Choose all correct answers)

They describe, qualify, quantify, classify, or specify an entity. (*)

They are the primary container for data.

They are often adjectives. (*)

They must be single valued unless they belong to more than one entity.

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

True (*)

False

12.  By defining ________ and _____ keys, you can ensure that the integrity of the data in
a table is maintained.

primary, unique

primary, secondary

foreign, unique

primary, foreign (*)

13.  Matrix Diagrams should be developed BEFORE the ERD. True or False?

True (*)
False

14.  A __________ relationship is a relationship between an entity and itself.

Recursive (*)

One to one

Hierarchical

Mandatory

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

True

False (*)

11. A foreign key is a column or combination of columns in one table that uniquely
identifies a row of another table.

True (*)

False
12.  Which of the following is NOT an example of cardinality?

How many employees can hold one specific job?

How many types of jobs are there? (*)

How many jobs can one employee hold?

All are examples of cardinality.

13.  ERDish includes the following except:

Relationship Names

Data Values. (*)

Cardinality

Optionality

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

It is acceptable to include information that is derivable. (*)

Capture all required information.

Ensure information appears only once.

 Locate information in a logical manner

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

Physical

Hierarchical

Conceptual

Logical (*)
 
1.      A _____ is a type of database that stores data in a single table.

Flat file (*)

Hierarchical

Relational

Network

2.  In the relational model, relationships between relations or tables are created by using?

Composite Keys
Primary Keys

Foreign Keys (*)

Candidate Keys

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

True

False (*)

4.  Primary UIDs are:

Optional in data modeling.

Useful as an alternative means of identifying instances of an entity, independent of their

datatype

Always comprised of numbers

Mandatory in data modeling (*)

5.  When creating entities in a logical model you must follow these rules: (Choose Two)

(Choose all correct answers)

Name them in Singular (*)

Exclude Attributes

Include Attributes (*)

Name them in Plural

6.     Entity names are always singular. True or False?

True (*)

False

7.  In this course, we use the __________ notation for ERD modeling.

Bachman

Barker (*)

Information Engineering

None of the above

8.  A conceptual model includes :

Only Entities and Relationships (*)

Only Entities, Attributes and Relationships

Only Entities, Attributes and Unique Identifiers

Entities, Attributes, Unique Identifiers and Relationships

9.  A logical model includes :

Only Entities and Relationships

Only Entities, Attributes and Unique Identifiers

Only Entities, Attributes and Relationships

Entities, Attributes, Unique Identifiers and Relationships (*)

10.  A relationship can be between ____________.

two entities

an entity and itself

multiple entities
 All of the above. (*)
 
11.   If a relationship is mandatory there must be at least one instance of the
corresponding entity related to it.

True (*)

False

12.  A __________ relationship is a relationship between an entity and itself.

Recursive (*)

Mandatory

Hierarchical

One to one

13.  Which of the following statements about entity relationship diagrams (ERD) is true?

Used to communicate the logical structure of the database to users. (*)

Used to communicate the physical structure of the database to users.

Is a hard and fast document that cannot be changed once development of the database
has begun.
Used to communicate the technical specifications of the database to users

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

Locate information in a logical manner

Ensure information appears only once.

It is acceptable to include information that is derivable. (*)

Capture all required information.

15.  Data modeling is performed for the following reasons: (Choose Two)

(Choose all correct answers)

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.

It helps discussions and reviews. (*)

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

The ERD becomes a blueprint for designing the actual system. (*)
Oracle   Ujian

Comments

Popular posts from this blog

MID SEMESTER ORACLE BASIS DATA
- October 14, 2019
MID SEMESTER ORACLE BASIS DATA 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.
Mark for Review (1) Points False. Business requirements can and will change. For
instance new legal requirements may arise. (*) True. The only requirement for creating a
perfect system is a perfect programmer. True. Users never know what they want anyway,
so building systems is best left to the professionals. True. Users delay the delivery of a
system by changing their minds and adding new requirements. Correct Correct 2. If
information requirements are clearly communicated during conceptual modeling the
following will result: Mark for Review (1) Points A well designed conceptual model (*)
Some business rules may not be taken into account A conceptual mo
READ MORE
Pengertian, Fungsi, dan Apapun Tentang Memori
- November 06, 2020
Dibuat Oleh  :  Abdul Basith Bahi Memori merupakan istilah generik yang merujuk pada
media penyimpanan data sementara pada komputer. Setiap program dan data yang
sedang diproses oleh prosesor akan disimpan di dalam memori fisik
READ MORE

 Powered by Blogger

ABDUL BASITH BAHI

Saya Abdul Basith Bahi, Pria Sukses Akan Harta, Tahta, Iman, dan Taqwa Aamiin
VISIT PROFILE

Pages

 About
 Contact Form
 Sitemap
 Disclaimer
 Terms & Conditions
 Privacy Policy
 Popular posts from this blog
MID SEMESTER ORACLE BASIS DATA
- October 14, 2019
MID SEMESTER ORACLE BASIS DATA 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. Mark for Review (1) Points False. Business requirements can and will
change. For instance new legal requirements may arise. (*) True. The only
requirement for creating a perfect system is a perfect programmer. True. Users never
know what they want anyway, so building systems is best left to the professionals.
True. Users delay the delivery of a system by changing their minds and adding new
requirements. Correct Correct 2. If information requirements are clearly
communicated during conceptual modeling the following will result: Mark for Review
(1) Points A well designed conceptual model (*) Some business rules may not be
taken into account A conceptual mo
READ MORE
Pengertian, Fungsi, dan Apapun Tentang Memori
- November 06, 2020
Dibuat Oleh  :  Abdul Basith Bahi Memori merupakan istilah generik yang merujuk
pada media penyimpanan data sementara pada komputer. Setiap program dan data
yang sedang diproses oleh prosesor akan disimpan di dalam memori fisik
READ MORE
Langkah - Langkah Memudarkan Bekas Jerawat
- May 05, 2020
 A . F acial Wash        L angkah awal agar dapat membuat bekas jerawat memudar
atau ialah salah satunya memilih facial wash yang tepat untuk tipe kulit kamu.
Dibawah ini kita akan merekomendasikan ke kamu beberapa produk yang cocok
untuk tipe kulit kamu  1. K ulit Berminyak dan Berjerawat        P ond's Acne Solution
Anti-Acne Facial Foam                                                                                                  U
ntuk Tipe kulit berminyak dan berjerawat kita saranin ke kamu untuk memakai produk
pond's yang satu ini karena Pond's Acne Solution Anti-Acne Facial Foam adalah
facial wash yang memiliki teknologi mutakhir Thymo-T Essence, yang dapat
melindungi kulit kamu dari bakteri penyebab jerawat, dan salah satu admin kita juga
memakai produk ini loh. jerawat dan bekasnya hilang dalam kurun waktu seminggu
aja. Worth IT banget kan untuk dibeli. 2. K ulit Kering          F oam Cleanser
Moisture_EX                                                
READ MORE
- January 06, 2021
 Basith Bahi
READ MORE
Pengikut
Archive
Labels
Report Abuse
Contact Form
Name

Email *
1. An Entity Relationship model is independent of the hardware or software used for
implementation. True or False? Mark for Review

(1) Points

True (*)

False

2. A well structured ERD will show only some parts of the finished data model. You should never
try to model the entire system in one diagram, no matter how small the diagram might be. True or
False? Mark for Review

(1) Points

True

False (*)

3. The purpose of an ERD is to document the proposed system and facilitate discussion and
understanding of the requirements captured by the developer. True or False? Mark for Review

(1) Points

True (*)

False

4. 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?
Mark for Review

(1) Points

True (*)

False

5. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or
False? Mark for Review
(1) Points

True (*)

False

6. Data modeling is performed for the following reasons: (Choose Two) Mark for Review

(1) Points

(Choose all correct answers)

It helps discussions and reviews. (*)

The ERD becomes a blueprint for designing the actual system. (*)

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.

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

7. Data modeling is performed for the following reasons: (Choose Two) Mark for Review

(1) Points

(Choose all correct answers)

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.

It helps discussions and reviews. (*)

The ERD becomes a blueprint for designing the actual system. (*)

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

8. Which of the following entities most likely contains valid attributes? (Choose two) Mark
for Review

(1) Points

(Choose all correct answers)

Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built (*)

Entity: Pet. Attributes: Name, Birthdate, Owner (*)

Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed

Entity: Mother. Attributes: Name, Birthdate, Occupation, Start Date

9. Which of the following are examples of ENTITY: Instance ? (Choose Two) Mark for Review

(1) Points
 (Choose all correct answers)

ANIMAL: Dog (*)

MEAT PRODUCT: Lettuce

BODY PART: Larry Ellison

TRANSPORTATION METHOD: Car (*)

10. Unique Identifiers: Mark for Review

(1) Points

Distinguish one instance of an entity from all other instances of that entity (*)

Distinguish all entities in a database

Distinguish one entity from another

Distinguish nothing

11. Which of the following statements about Entities are true? Mark for Review

(1) Points

(Choose all correct answers)

"Something" of significance to the business about which data must be known. (*)

They never have Instances

They are usually a noun. (*)

A name for a set of similar "things" (*)

12. In the following statements, find two good examples of ENTITY: Instance. (Choose Two)
Mark for Review

(1) Points

(Choose all correct answers)

VEGETABLE: grows

BOOK: Biography of Mahatma Gandhi (*)

TRAIN: runs

DAIRY PRODUCT: milk (*)

13. 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 entity. Mark for Review

(1) Points

Table
 ERD

Process

Attribute (*)

14. The word "Volatile" means: Mark for Review

(1) Points

Limited quantity

Changing constantly; unstable (*)

Large quantity

Static; unlikely to change

15. Entities are usually verbs. True or False? Mark for Review

(1) Points

True

False (*)

1. Unique Identifiers: Mark for Review

(1) Points

Distinguish one entity from another

Distinguish nothing

Distinguish all entities in a database

Distinguish one instance of an entity from all other instances of that entity (*)

2. The word "Volatile" means: Mark for Review

(1) Points

Large quantity

Static; unlikely to change

Limited quantity

Changing constantly; unstable (*)

3. Which of the following entities most likely contains valid attributes? (Choose two) Mark
for Review

(1) Points

(Choose all correct answers)

 Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed

Entity: Pet. Attributes: Name, Birthdate, Owner (*)

Entity: Mother. Attributes: Name, Birthdate, Occupation, Start Date

Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built (*)

4. All of the following could be attributes of an ENTITY called PERSON, except which one? Mark for
Review

(1) Points

Weight

Gender

Haircolor

Natacha Hansen (*)

5. Attributes can only have one value at any point for each instance in the entity. True or False?
Mark for Review

(1) Points

True (*)

False

6. A/an _________'s value can be a number, a character string, a date, an image, a sound Mark
for Review

(1) Points

ERD

Table

Attribute (*)

Entity

7. What is the purpose of a Unique Identifier? Mark for Review

(1) Points

To identify a specific row within a table, using one or more columns and/or foreign keys.

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 uniquely determine a table and columns within that table.

8. Which of the following attributes is suitable to be a Unique Identifier? Mark for Review

(1) Points

Address

First name

Last name

Social Security Number (*)

9. An Entity Relationship model is independent of the hardware or software used for

implementation. True or False? Mark for Review

(1) Points

True (*)

False

10. A well structured ERD will show only some parts of the finished data model. You should never
try to model the entire system in one diagram, no matter how small the diagram might be. True or
False? Mark for Review

(1) Points

True

False (*)

11. Which of the following can be found in an ERD? (Choose Two) Mark for Review

(1) Points

(Choose all correct answers)

Entities. (*)

Attributes. (*)

Tables.

Instances.

12. A Conceptual Model is not concerned with how the Physical Model will be implemented. True
or False? Mark for Review

(1) Points

True (*)
 False

13. Data modeling is performed for the following reasons: (Choose Two) Mark for Review

(1) Points

(Choose all correct answers)

It helps discussions and reviews. (*)

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.

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

The ERD becomes a blueprint for designing the actual system. (*)

14. An ERD is an example of a Physical Model. True or False? Mark for Review

(1) Points

True

False (*)

15. The Physical Model is derived from the Conceptual Model. True or False? Mark for Review

(1) Points

True (*)

False

1. Which of the following statements about Entities are true? Mark for Review

(1) Points

(Choose all correct answers)

They are usually a noun. (*)

"Something" of significance to the business about which data must be known. (*)

They never have Instances

A name for a set of similar "things" (*)

2. Which of the following is an example of a volatile attribute? Mark for Review

(1) Points

Date of Birth
 Hire Date

Name

Age (*)

3. All of the following would be instances of the entity PERSON except which? Mark for Review

(1) Points

Male (*)

Grace Abinajam

David Jones

Angelina Rosalie

4. Attributes can only have one value at any point for each instance in the entity. True or False?
Mark for Review

(1) Points

True (*)

False

5. All of the following would be instances of the entity ANIMAL SPECIES, except which one?
Mark for Review

(1) Points

Elephant

Bird

Dog

Leaf (*)

6. A/an _________'s value can be a number, a character string, a date, an image, a sound Mark
for Review

(1) Points

ERD

Entity

Attribute (*)

Table

7. A/an _________ is defined as "Something" of significance to the business about which data
must be known. Mark for Review
(1) Points

Instance

Relationship

Entity (*)

None of the above

8. Attributes can be either mandatory or optional. True or False? Mark for Review

(1) Points

True (*)

False

9. Data models show users the data that their Physical Model will contain. True or False? Mark
for Review

(1) Points

True (*)

False

10. A Conceptual Model is not concerned with how the Physical Model will be implemented. True
or False? Mark for Review

(1) Points

True (*)

False

11. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the
options below. Mark for Review

(1) Points

(Choose all correct answers)

They capture current and future needs. (*)

They model the information flow of data.

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

They model functional and informational needs. (*)

They capture the implementation details of the physical model.

12. Data models are drawn to show users the actual Data that their new system will contain; only
Data listed on the Diagram can be entered into the Database. True or False? Mark for Review
(1) Points

True (*)

False

13. Which of the following statements about ERD's is false? Mark for Review

(1) Points

Ensure that information appears only once.

Capture all required information.

Model all information that is derivable from other information already modeled. (*)

Locate information in a predictable, logical place.

14. A well structured ERD will show only some parts of the finished data model. You should never
try to model the entire system in one diagram, no matter how small the diagram might be. True or
False? Mark for Review

(1) Points

True

False (*)

15. Which of the following statements are true about ERD's? (Choose Two) Mark for Review

(1) Points

(Choose all correct answers)

You should not model derivable data. (*)

A piece of information should only be found in one place on an ERD. (*)

A piece of information can be shown multiple times on an ERD.

All data must be represented on the ERD, including derived summaries and the result of
calculations.

1. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the
options below. Mark for Review

(1) Points

(Choose all correct answers)

They capture the implementation details of the physical model.

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

They model the information flow of data.

They model functional and informational needs. (*)

 They capture current and future needs. (*)

2. Data modeling is performed for the following reasons: (Choose Two) Mark for Review

(1) Points

(Choose all correct answers)

It helps discussions and reviews. (*)

The ERD becomes a blueprint for designing the actual system. (*)

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.

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

3. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or
False? Mark for Review

(1) Points

True (*)

False

4. Data models are drawn to show users the actual Data that their new system will contain; only
Data listed on the Diagram can be entered into the Database. True or False? Mark for Review

(1) Points

True (*)

False

5. Which of the following attributes is suitable to be a Unique Identifier? Mark for Review

(1) Points

Last name

First name

Address

Social Security Number (*)

6. Which of the following statements about Entities are true? Mark for Review

(1) Points

(Choose all correct answers)

They are usually a noun. (*)

 They never have Instances

"Something" of significance to the business about which data must be known. (*)

A name for a set of similar "things" (*)

7. A/an _________ is defined as "Something" of significance to the business about which data
must be known. Mark for Review

(1) Points

Instance

Relationship

Entity (*)

None of the above

8. Which of the following are examples of ENTITY: Instance ? (Choose Two) Mark for Review

(1) Points

(Choose all correct answers)

ANIMAL: Dog (*)

TRANSPORTATION METHOD: Car (*)

MEAT PRODUCT: Lettuce

BODY PART: Larry Ellison

9. A/an _________'s value can be a number, a character string, a date, an image, a sound Mark
for Review

(1) Points

Attribute (*)

Table

Entity

ERD

10. Entities are usually verbs. True or False? Mark for Review

(1) Points

True

False (*)

11. All of the following would be instances of the entity PERSON except which? Mark for Review
(1) Points

David Jones

Angelina Rosalie

Male (*)

Grace Abinajam

12. The word "Volatile" means: Mark for Review

(1) Points

Limited quantity

Static; unlikely to change

Large quantity

Changing constantly; unstable (*)

13. An Entity Relationship model is independent of the hardware or software used for implementation.
True or False? Mark for Review

(1) Points

True (*)

False

14. The purpose of an ERD is to document the proposed system and facilitate discussion and
understanding of the requirements captured by the developer. True or False? Mark for Review

(1) Points

True (*)

False

15. Entity Relationship modeling is dependent on the hardware or software used for
implementation, so you will need to change your ERD if you decide to change Hardware Vendor. True
or False? Mark for Review

(1) Points

True

Test: DFo Section 1 Quiz

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

(Answer all questions in this section)

1. In a hierarchical database model the data is stored as records that

are connected to one another through .
Mark for Review

(1) Points
databases
primary keys
fields
links (*)
Incorrect. Refer to Section 1 Lesson 3.

2. 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 column names that are the same.
Mark for Review

(1) Points
True (*)
False
Incorrect. Refer to Section 1 Lesson 3.

3. 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.
Mark for Review

(1) Points
Relational
Hierarchical (*)
Network
Object Oriented
Correct

4. Which of the following is not a stage in the Database

Development Process?
Mark for Review

(1) Points
Strategy and Analysis
Reporting (*)
Design
 Build
Correct

5. A database interacts with the data and provides the following facilities:
Mark for Review

(1) Points
Retrieving data
Inserting data
Deleting data
All of the above. (*)
Correct

Test: DFo Section 1 Quiz

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

Section 1

(Answer all questions in this section)

6. DBMS stands for :

Mark for Review

(1) Points
Database Memory System
Database Management Software
Database Manipulation System
Database Management System (*)
Correct

7. The transformations that have occurred in the computing

world progressing in this order:
Mark for Review

(1) Points
Grid Computing, Desktop Computing, Mainfram Computing, Client/Server
Computing
Desktop computing, Grid computing, Client/Server computing, Mainframe
computing.
Mainframe Computing, Desktop Computing, Grid Computing,
Client/Server Computing.
Mainframe computing, Desktop computing, Client/Server Computing, Grid
computing. (*)
Correct

8. Select the business or industry that would not have a need for
a database.
Mark for Review
(1) Points
Banking
Retail
Scientific Research
All these businesses could benefit from using a database. (*)
Correct

9. If information requirements are clearly communicated

during conceptual modeling the following will
result:
Mark for Review

(1) Points
A well designed conceptual model (*)
Some business rules may not be taken into account
A conceptual model that does not fully reflect the business will be created.
Delays due to reworking model caused by incorrect assumptions
Incorrect. Refer to Section 1 Lesson 4.

10. Business rules are important because .

Mark for Review

(1) Points
They allow the developer to understand the relationship and constraints of
the participating entities (*)
They are complex and difficult to understand.
They can become outdated quickly.
They can all be incorporated into the database design structure.
Correct
Previous Page 2 of 3 Next

Test: DFo Section 1 Quiz

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

Section 1

(Answer all questions in this section)

11. 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.
Mark for Review

(1) Points
True. Users delay the delivery of a system by changing their minds and
adding new requirements.
True. The only requirement for creating a perfect system is a perfect
programmer.
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

12. Business are used to understand business processes, and the

nature, role, and scope of the data.
Mark for Review

(1) Points
Goals
Rules (*)
Processes
Mission Statements
Incorrect. Refer to Section 1 Lesson 4.

13. All Business Rules can be modeled.

Mark for Review

(1) Points
True
False (*)
Incorrect. Refer to Section 1 Lesson 4.

14. The strategies for learning used in this course include:

Mark for Review

(1) Points
Instructor led training
Industry recognized certification
Project driven curriculum
All of the above (*)
Correct

15. The main subject areas taught by the Oracle Academy are:
Mark for Review

(1) Points
Data Modeling, SQL, and PL/SQL (*)
Database performance tuning
Systems programming and computer architecture
Computer Repairs
Correct
Previous Page 3 of 3

Test: DFo Section 2 Quiz

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

(Answer all questions in this section)

1. In the relational model, data is organized in a basic storage

structure called a .
Mark for Review

(1) Points
Field
Tuples
Table (*)
Row
Correct

2. A is a collection of records.
Mark for Review

(1) Points
table (*)
row
field
column
Incorrect. Refer to Section 2 Lesson 1.

3. In an ERD diagram how is an optional relationship represented ?

Mark for Review

(1) Points
With a solid line
With a dotted line (*)
With an arrow
With a crows foot
Incorrect. Refer to Section 2 Lesson 6.

4. When mapping a relationship for an ERD diagram both sides of

the relationship have to be mapped.
Mark for Review

(1) Points
True (*)
False
Correct

5. Which of the following statements about entity relationship

diagrams (ERD) is true?
Mark for Review

(1) Points
Used to communicate the logical structure of the database to users. (*)
 Used to communicate the technical specifications of the database to users
Used to communicate the physical structure of the database to users.
Is a hard and fast document that cannot be changed once development of
the database has begun.
Correct
Page 1 of 3 Next

Test: DFo Section 2 Quiz

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

Section 2

(Answer all questions in this section)

6. What is the purpose of a Unique Identifier?

Mark for Review

(1) Points
To identify one unique instance of an entity by using one or more
attributes and/or relationships. (*)
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.
Create an entity that is unlike any other entity aside from itself.
Correct

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

Mark for Review

(1) Points
True
False (*)
Incorrect. Refer to Section 2 Lesson 4.

8. Matrix Diagrams are used to verify that all have been

identified for an ERD.
Mark for Review

(1) Points
entities
relationships (*)
keys
attributes
Correct

9. In an ERD, optionality is depicted using .

Mark for Review
(1) Points
 single toe or crows foot
solid or dashed lines (*)
names of relationships
soft boxes
Incorrect. Refer to Section 2 Lesson 5.

10. The optionality of a relationship must be either or .

Mark for Review

(1) Points
One or (One or More)
Single or Multiple
Bidirectional or a single direction
Mandatory or Optional (*)
Correct
Previous Page 2 of 3 Next

Test: DFo Section 2 Quiz

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

Section 2

(Answer all questions in this section)

11. The logical model becomes the blueprint for designing the
model
Mark for Review

(1) Points
Physical (*)
Network
Data Integrity
Data Flow
Correct

12. The logical model's entities, attributes, unique identifiers

and relationships map to the physical model's .
Mark for Review

(1) Points
Optionality and Cardinality
Files, records, fields and data values
Tables, columns, primary keys and foreign keys (*)
Correct

13. Entities are usually .

Mark for Review
(1) Points
 Nouns (*)
Verbs
Adjectives
Adverbs
Incorrect. Refer to Section 2 Lesson 3.

14. Which of the following entities most likely contains invalid attributes?
Mark for Review

(1) Points
Entity: Pet. Attributes: Name, Birthdate, Owner
Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of
Children
Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed(*)
Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date
Built
Correct

15. Which symbol is used to show that a particular attribute

is mandatory?
Mark for Review

(1) Points
#
* (*)
&
o
Incorrect. Refer to Section 2 Lesson 3.
Previous Page 3 of 3

Test: DFo Section 2 Quiz

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

Section 2

(Answer all questions in this section)

1. Which of the following statements about attributes are true?

(Choose Two)
Mark for Review

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

They are the primary container for data. They are

often adjectives.(*)
Incorrect. Refer to Section 2 Lesson 3.
 2. When creating entities in a logical model you must follow these
rules: (Choose Two)
Mark for Review

(1) Points
Include Attributes(*)
Name them in Plural
Exclude Attributes

Name them in Singular(*)

Incorrect. Refer to Section 2 Lesson 3.

3. An entity may have which of the following?

Mark for Review

(1) Points
Experiences
Instances (*)
Tables
None of the above
Correct

4. Which of the following statements is true regarding

Implementation- Free logical models?
Mark for Review

(1) Points
The model changes depending on operating system that is being used.
The model stays the same regardless of the DBMS or operating
system used. (*)
The model changes depending on the relational database software
being used
The model does not need to implemented on a DBMS.
Incorrect. Refer to Section 2 Lesson 6.

5. When mapping a relationship for an ERD diagram both sides of

the relationship have to be mapped.
Mark for Review

(1) Points
True (*)
False
Correct

Test: DFo Section 2 Quiz

Review your answers, feedback, and question scores below. An asterisk
(*) indicates a correct answer.
Section 2
(Answer all questions in this section)

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

Mark for Review

(1) Points
Locate information in a logical manner
Ensure information appears only once.
It is acceptable to include information that is derivable. (*)
Capture all required information.
Incorrect. Refer to Section 2 Lesson 6.

7. Which of the following would be good as a Unique Identifier for

its Entity? (Choose Three)
Mark for Review

(1) Points
Vehicle Registration Number for Car(*) ISBN
Number for Book(*)

Personal Identification number for Person(*) Date of

birth for Baby

Incorrect. Refer to Section 2 Lesson 4.

8. Primary UIDs are:

Mark for Review

(1) Points
Useful as an alternative means of identifying instances of an entity,
independent of their datatype
Always comprised of numbers
Optional in data modeling.
Mandatory in data modeling (*)
Incorrect. Refer to Section 2 Lesson 4.

9. A is a collection of records.
Mark for Review

(1) Points
column
row
field
table (*)
Correct

10. What does single table refer to? (Choose Two)

Mark for Review

(1) Points
A type of database storage method where all of the data elements are stored on top of each other. A database where all of
the data is stored in one large table.(*)
A fully-relational database system like Microsoft's SQL Server or Oracle's database systems.
 Non-relational systems that typically store each table and index in separate files and often do not support the SQL language.
(*)
Incorrect. Refer to Section 2 Lesson 1.
Previous Page 2 of 3 Next

Test: DFo Section 2 Quiz

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

Section 2

(Answer all questions in this section)

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

Mark for Review

(1) Points
It facilitates discussion; a picture is worth a thousand words
It forms important ideal system documentation
It takes into account government regulations and laws
It forms a sound basis for physical database design
All of the above (*)
Correct

12. The logical model determines relationship optionality and cardinality

Mark for Review

(1) Points
True (*)
False
Correct

13. The optionality of a relationship must be either or .

Mark for Review

(1) Points
Single or Multiple
Mandatory or Optional (*)
One or (One or More)
Bidirectional or a single direction
Correct

14. Which of the following is NOT a relationship type?

Mark for Review

(1) Points
One to One
One to Many
Many to Many
Some to None (*)
Correct

15. A relationship is a relationship between an entity and

itself.
Mark for Review

(1) Points
Recursive (*)
One to one
Mandatory
Hierarchical
Correct
Previous Page 3 of 3

Test: DFo Section 2 Quiz

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

Section 2

(Answer all questions in this section)

1. Which symbol is used to show that a particular attribute is optional?

Mark for Review

(1) Points
o (*)
&
*
#
Correct

2. Attributes have Instances. True or False?

Mark for Review

(1) Points
True
False (*)
Incorrect. Refer to Section 2 Lesson 3.

3. Entities are usually .

Mark for Review

(1) Points
Verbs
Adjectives
Adverbs
Nouns (*)
Correct
4. A candidate UID that does not get chosen to become the primary
UID is called a .
Mark for Review

(1) Points
Secondary UID (*)
Primary UID
Composite UID
Unique UID
Incorrect. Refer to Section 2 Lesson 4.

5. 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 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
Page 1 of 3 Next

Test: DFo Section 2 Quiz

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

Section 2

(Answer all questions in this section)

6. Data Integrity ensures in the information.

Mark for Review

(1) Points
duplication
anomalies
no duplication (*)
errors
Incorrect. Refer to Section 2 Lesson 1.

7. Flat file databases avoids data duplication. True or False?

Mark for Review

(1) Points
True
False (*)
Correct
 8. A conceptual model includes :
Mark for Review

(1) Points
Only Entities and Relationships (*)
Only Entities, Attributes and Unique Identifiers
Only Entities, Attributes and Relationships
Entities, Attributes, Unique Identifiers and Relationships
Incorrect. Refer to Section 2 Lesson 2.

9. In a relational database system, the next step after creating a

conceptual data model is to convert it to a .
Mark for Review

(1) Points
An entity-relation data model
External data model
Internal data model
Logical data model (*)
Correct

10. Data models are drawn to show users the actual Data that their new
system will contain; only Data listed on the Diagram can be entered
into the Database. True or False?
Mark for Review

(1) Points
True
False (*)
Incorrect. Refer to Section 2 Lesson 6.
Previous Page 2 of 3 Next

Test: DFo Section 2 Quiz

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

Section 2

(Answer all questions in this section)

11. The model includes entities, attributes, UIDs,

relationships as well as optionality and cardinality of these
items.
Mark for Review

(1) Points
Physical
Hierarchical
 Conceptual
Logical (*)
Incorrect. Refer to Section 2 Lesson 6.
 12. ERDish is a language used to create database structures in SQL
Mark for Review

(1) Points
True
False (*)
Incorrect. Refer to Section 2 Lesson 5.

13. The components of a relationship include all of the following except :

Mark for Review

(1) Points
Cardinality
Relational Integrity (*)
Names
Optionality
Incorrect. Refer to Section 2 Lesson 5.

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

Mark for Review

(1) Points
one to one

one or more(*)
many to many

one and only one(*)

Incorrect. Refer to Section 2 Lesson 5.

15. One-to-Many relationships have cardinality of one or more in

both directions. True or False?
Mark for Review

(1) Points
True
False (*)
Incorrect. Refer to Section 2 Lesson 5.
Previous Page 3 of 3

Test: DFo Section 2 Quiz

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

Section 2

(Answer all questions in this section)

1. A relational database stores information in tables with rows
and columns.
Mark for Review
 (1) Points
True (*)
False
Correct

2. Flat file databases avoids data duplication. True or False?

Mark for Review

(1) Points
True
False (*)
Correct

3. When mapping a relationship for an ERD relationship names must

be included.
Mark for Review

(1) Points
True (*)
False
Correct

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

Mark for Review

(1) Points
Capture all required information.
It is acceptable to include information that is derivable. (*)
Ensure information appears only once.
Locate information in a logical manner
Incorrect. Refer to Section 2 Lesson 6.

5. Using ERDish, which wording represents cardinality? (Choose Two)

Mark for Review

(1) Points
one only

one or more(*)

one and only one(*) one

or multiple

Incorrect. Refer to Section 2 Lesson 6.

Page 1 of 3 Next

Test: DFo Section 2 Quiz

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

(Answer all questions in this section)

6. 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 entity.
Mark for Review

(1) Points
Attribute (*)
ERD
Table
Process
Incorrect. Refer to Section 2 Lesson 3.

7. Which of the attributes is a volatile attribute?

Mark for Review

(1) Points
Age (*)
Race
Eye color
Date of birth
Correct

8. When creating entities in a logical model you must follow these

rules: (Choose Two)
Mark for Review

(1) Points
Include Attributes(*)
Exclude Attributes

Name them in Singular(*) Name

them in Plural

Correct

9. The optionality of a relationship must be either or .

Mark for Review

(1) Points
One or (One or More)
Single or Multiple
Bidirectional or a single direction
Mandatory or Optional (*)
Correct

10. In a relationship , are used to helped describe the

meaning of the connection between the entities.
Mark for Review

(1) Points
names (*)
descriptions
 arrows
crows feet
Correct
Previous Page 2 of 3 Next

Test: DFo Section 2 Quiz

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

Section 2

(Answer all questions in this section)

11. The components of a relationship include all of the following except :

Mark for Review

(1) Points
Optionality
Relational Integrity (*)
Names
Cardinality
Correct

12. The physical model shows all table structures. True or False.
Mark for Review

(1) Points
True (*)
False
Correct

13. Many reasons exist for creating a conceptual model. Choose

three appropriate reasons from the options below.
Mark for Review

(1) Points
They capture the data values.

They accurately describe what a physical model will contain. (*) They capture
the implementation details of the physical model. They capture current and
future needs.(*)

They model functional and informational needs.(*)

Incorrect. Refer to Section 2 Lesson 2.

14. All entities must be given a new artificial UID. True or False?
Mark for Review
(1) Points
True
False (*)
Correct
 15. The candidate UID that is chosen to identify an entity is called
the Primary UID; other candidate UIDs are called Secondary UIDs.
Mark for Review

(1) Points
No, after UIDs are first sorted, the first one is called the Primary UID, the
second is the Secondary UID, etc.
No, each Entity can only have one UID, the secondary one.
No, it is not possible to have more than one UID for an Entity.
Yes, this is the way UID's are named. (*)
Incorrect. Refer to Section 2 Lesson 4.
Previous Page 3 of 3

Test: DFo Section 3 Quiz

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

Section 3

(Answer all questions in this section)

1. Until all attributes are single-valued, the database model is said to be:
Mark for Review

(1) Points
Normalized
in 1st Normal Form
in 2nd Normal Form
Not Normalized (*)
Incorrect. Refer to Section 3 Lesson 3.

2. 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 (*)
Correct

3. Sources of business rules include all of the following except:

Mark for Review

(1) Points
Procedures
Word of mouth (*)
Operational manuals
Standards
Correct

4. Can all constraints be modeled on an ER diagram?

Mark for Review

(1) Points
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 (*)
No, in which case you should let the database administrator handle them
Incorrect. Refer to Section 3 Lesson 3.

5. Business rules are important to data modelers. True or False?

Mark for Review

(1) Points
True (*)
False
Correct
Page 1 of 3 Next

Test: DFo Section 3 Quiz

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

Section 3

(Answer all questions in this section)

6. All instances of the supertype be an instance of one of the

subtypes.
Mark for Review

(1) Points
cannot
must (*)
may
will sometimes
Correct

7. You can only create relationships to a Supertype, not to a

Subtype. True or False?
Mark for Review

(1) Points
True
False (*)
Correct
8. If a relationship can NOT be moved between instances of the entities
it connects, it is said to be:
Mark for Review

(1) Points
Transferable
Non-Transferable (*)
Mandatory
Optional
Correct

9. Which of the following pairs of entities is most likely to be modeled as

a M:M relationship?
Mark for Review

(1) Points
TEACHER and SUBJECT AREA (*)
CAR and WHEEL
TREE and BRANCH
PERSON and FINGERPRINT
Correct

10. A recursive relationship has cardinality of .

Mark for Review

(1) Points
Many to Many
One to One
Cannot be determined without more information. (*)
One to Many
Incorrect. Refer to Section 3 Lesson 1.
Previous Page 2 of 3 Next

Test: DFo Section 3 Quiz

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

Section 3

(Answer all questions in this section)

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.
If you are doing a system for any French City, you would need security
clearance.
Cites may change their names and/or country association if the borders of
a country change. (*)
People are born in the city and people die in the city.
Incorrect. Refer to Section 3 Lesson 2.

12. Modeling historical data is optional. True or False?

Mark for Review

(1) Points
True (*)
False
Incorrect. Refer to Section 3 Lesson 2.

13. Attribute names are converted to column names by

.
Mark for Review

(1) Points
Replacing numbers with letters.
Replacing spaces with underscores. (*)
Replacing underscores with dashes.
Replacing periods with commas.
Correct

14. Table names can contain all of the following except:

Mark for Review

(1) Points
Letters
Numbers
Some special characters
Spaces (*)
Correct

15. When mapping entities containing supertypes and subtypes a

table implementation is used when most of the attributes and
relationships are shared at the supertype level.
Mark for Review

(1) Points many

to many
multiple-table
two-table
 single-table (*)
Incorrect. Refer to Section 3 Lesson 4.
Previous Page 3 of 3