DBMS: Questions With Precise Solutions (Graded A+)
In a relational database a table is referred to as Right Ans - None of the
above
Each column in a relation is called an entity. True or False Right Ans - False
The Candidates UIDs must be made up of only one attribute Right Ans -
False
One to One relationships have ________ of one to one in both directions Right
Ans - Cardinality
The optionally of a relationship must be either _____ or ______ Right Ans -
Mandatory or Optional
In an ERD, optionality is depicted using ______ Right Ans - Solid or dashed
lines
Which symbol is used to show that a particular attribute is optional Right
Ans - o
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 specified the
entity Right Ans - Attribute
Attribute that can be divided into smaller sub parts are called Right Ans -
Composite Attributes
In an ERD diagram how is an optional relationship represented Right Ans -
With a dotted line
Which of the following statements is true regarding Implementation-Free
logical models Right Ans - The model stays the same regardless of the
DBMS or operating system used
The conceptual model does all of the following except Right Ans -
Documents types of operating system to be used
In a relational database a table is referred to as Right Ans - None of the
above
Each column in a relation is called an entity. True or False Right Ans - False
The Candidates UIDs must be made up of only one attribute Right Ans -
False
One to One relationships have ________ of one to one in both directions Right
Ans - Cardinality
The optionally of a relationship must be either _____ or ______ Right Ans -
Mandatory or Optional
In an ERD, optionality is depicted using ______ Right Ans - Solid or dashed
lines
Which symbol is used to show that a particular attribute is optional Right
Ans - o
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 specified the
entity Right Ans - Attribute
Attribute that can be divided into smaller sub parts are called Right Ans -
Composite Attributes
In an ERD diagram how is an optional relationship represented Right Ans -
With a dotted line
Which of the following statements is true regarding Implementation-Free
logical models Right Ans - The model stays the same regardless of the
DBMS or operating system used
The conceptual model does all of the following except Right Ans -
Documents types of operating system to be used
