Modeling Data in the Organization

Q1: A good business rule is which of the following?

A Declarative

B Imprecise

C Redundant

D Compound

Q2: A binary relationship cannot be which of the following?

A One-to-One

B One-to-Many

C Many-to-Many

D Zero-to-Zero

Q3: When the minimum and maximum number of instances of an entity is one, you know which of the following?

A Mandatory one

B Optional one

C Mandatory many

D Cannot tell

Q4: A relationship is which of the following?

A A person, place, or thing

B Property or characteristic of an entity

C Link between entities

D Weak entity

Q5: When the minimum number of instances of an entity is one, you know which of the following?

A Mandatory one

B Optional one

C Mandatory many

D Cannot tell

Q6: A ternary relationship involves how many entities?

A 3 or less

B 3

C More than 3

D 3 or more

Q7: Which of the following conditions should exist if you want to convert a relationship to an associative entity?

A Some of the relationships for the participating entities are "many".

B The resulting associative entity has an independent meaning.

C The resulting associative entity has no attributes.

D All of the above

Q8: If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?

A Derived attribute

B Optional one cardinality

C Multi-valued attribute

D Weak entity

Q9: A rectangle represents which of the following in an ERD?

A Attribute

B Entity

C Optional One

D Relationship

Q10: An oval represents which of the following in an ERD?

A Attribute

B Entity

C Optional One

D Relationship

Q11: A good identifier is which of the following?

A One that can change over time

B Can be null

C One that is unique

D Be intelligent

Q12: An entity name should be which of the following?

A A singular noun

B Specific to the organization

C Concise

D All of the above.

Q13: An attribute name should be which of the following?

A Singular verb or verb phrase

B Follow a standard format

C Use a alias

D All of the above.

Q14: A composite attribute is which of the following?

A An attribute that can be broken into components

B An attribute that cannot be broken into components

C Multiple attributes

D An identifier

Q15: A binary relationship is which of the following?

A A relationship between two attributes

B A relationship between two entities

C An attribute with two different relationships

D An entity with two different relationships


img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.