Oracle Database Quiz Section 2 Quiz Answer
 |
| Image Source : dqindia.com |
1.
An
Entity Relationship model is independent of the hardware or software used for
implementation. True or False?
True (*)
False
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?
True
False (*)
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?
True (*)
False
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?
True (*)
False
True (*)
False
5.
A Conceptual
Model is not concerned with how the Physical Model will be implemented. True or
False?
True (*)
False
True (*)
False
6.
Data
modeling is performed for the following reasons: (Choose Two)(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.
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)
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.
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?
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
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)
ANIMAL: Dog (*)
MEAT PRODUCT: Lettuce
BODY PART: Larry Ellison
TRANSPORTATION METHOD: Car (*)
ANIMAL: Dog (*)
MEAT PRODUCT: Lettuce
BODY PART: Larry Ellison
TRANSPORTATION METHOD: Car (*)
10.
Unique
Identifiers:
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
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?
"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" (*)
"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.
VEGETABLE: grows
BOOK: Biography of Mahatma Gandhi (*)
TRAIN: runs
DAIRY PRODUCT: milk (*)
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.
Table
ERD
Process
Attribute (*)
Table
ERD
Process
Attribute (*)
14.
The
word "Volatile" means:
Limited quantity
Changing constantly; unstable (*)
Large quantity
Static; unlikely to change
Limited quantity
Changing constantly; unstable (*)
Large quantity
Static; unlikely to change
15.
Entities
are usually verbs. True or False?
True
False (*)
True
False (*)
1.
Unique
Identifiers:
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 (*)
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:
Large quantity
Static; unlikely to change
Limited quantity
Changing constantly; unstable (*)
Large quantity
Static; unlikely to change
Limited quantity
Changing constantly; unstable (*)
3.
Which
of the following entities most likely contains valid attributes?
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 (*)
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?
Weight
Gender
Haircolor
Natacha Hansen (*)
Weight
Gender
Haircolor
Natacha Hansen (*)
5.
Attributes
can only have one value at any point for each instance in the entity. True or
False?
True (*)
False
True (*)
False
6.
A/an
_________'s value can be a number, a character string, a date, an image, a
sound.
ERD
Table
Attribute (*)
Entity
ERD
Table
Attribute (*)
Entity
7.
What is
the purpose of a Unique Identifier?
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.
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?
Address
First name
Last name
Social Security Number (*)
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?
True (*)
False
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?
True
False (*)
True
False (*)
11.
Which
of the following can be found in an ERD? (Choose Two)
Entities. (*)
Attributes. (*)
Tables.
Instances.
Entities. (*)
Attributes. (*)
Tables.
Instances.
12.
A
Conceptual Model is not concerned with how the Physical Model will be
implemented. True or False?
True (*)
False
True (*)
False
13.
Data
modeling is performed for the following reasons: (Choose Two)
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. (*)
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?
True
False (*)
True
False (*)
15.
The
Physical Model is derived from the Conceptual Model. True or False?
True (*)
False
True (*)
False
1.
Which
of the following statements about Entities are true?
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" (*)
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?
Date of Birth
Hire Date
Name
Age (*)
Date of Birth
Hire Date
Name
Age (*)
3.
All of
the following would be instances of the entity PERSON except which?
Male (*)
Grace Abinajam
David Jones
Angelina Rosalie
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?
True (*)
False
True (*)
False
5.
All of
the following would be instances of the entity ANIMAL SPECIES, except which
one?
Elephant
Bird
Dog
Leaf (*)
Elephant
Bird
Dog
Leaf (*)
6.
A/an
_________'s value can be a number, a character string, a date, an image, a
sound
ERD
Entity
Attribute (*)
Table
ERD
Entity
Attribute (*)
Table
7.
A/an
_________ is defined as "Something" of significance to the business
about which data must be known.
Instance
Relationship
Entity (*)
None of the above
Instance
Relationship
Entity (*)
None of the above
8.
Attributes
can be either mandatory or optional. True or False?
True (*)
False
True (*)
False
9.
Data
models show users the data that their Physical Model will contain. True or
False?
True (*)
False
True (*)
False
10.
A
Conceptual Model is not concerned with how the Physical Model will be
implemented. True or False?
True (*)
False
True (*)
False
11.
Many
reasons exist for creating a conceptual model. Choose three appropriate reasons
from the options below.
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.
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?
True (*)
False
True (*)
False
13.
Which
of the following statements about ERD's is false?
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.
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?
True
False (*)
True
False (*)
15.
Which of
the following statements are true about ERD's? (Choose Two)
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.
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.
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. (*)
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)
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.
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?
True (*)
False
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?
True (*)
False
True (*)
False
5.
Which
of the following attributes is suitable to be a Unique Identifier?
Last name
First name
Address
Social Security Number (*)
Last name
First name
Address
Social Security Number (*)
6.
Which
of the following statements about Entities are true?
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" (*)
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.
Instance
Relationship
Entity (*)
None of the above
Instance
Relationship
Entity (*)
None of the above
8.
Which
of the following are examples of ENTITY: Instance ?
ANIMAL: Dog (*)
TRANSPORTATION METHOD: Car (*)
MEAT PRODUCT: Lettuce
BODY PART: Larry Ellison
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
Attribute (*)
Table
Entity
ERD
Attribute (*)
Table
Entity
ERD
10.
Entities are usually verbs. True or False?
True
False (*)
True
False (*)
11.
All of the following would be instances of the
entity PERSON except which?
David Jones
Angelina Rosalie
Male (*)
Grace Abinajam
David Jones
Angelina Rosalie
Male (*)
Grace Abinajam
12.
The word "Volatile" means:
Limited quantity
Static; unlikely to change
Large quantity
Changing constantly; unstable (*)
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?
True (*)
False
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?
True (*)
False
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?
True
False (*)
True
False (*)