Sail E0 Webinar

MCQs

Total Questions : 30 | Page 1 of 3 pages
Question 1. 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?
  1.    Optional one cardinality
  2.    Derived attribute
  3.    Multi-valued attribute
  4.    Weak entity
 Discuss Question
Answer: Option D. -> Weak entity
Question 2. Which of the following conditions should exist if you want to convert a relationship to an associative entity?
  1.    The resulting associative entity has no attributes.
  2.    The resulting associative entity has an independent meaning.
  3.    Some of the relationships for the participating entities are 'many'.
  4.    All of these
 Discuss Question
Answer: Option B. -> The resulting associative entity has an independent meaning.
Question 3. A good identifier is which of the following?
  1.    Be intelligent
  2.    One that can change over time
  3.    Can be null
  4.    One that is unique
 Discuss Question
Answer: Option D. -> One that is unique
Question 4. A binary relationship is which of the following?
  1.    A relationship between two attributes
  2.    An entity with two different relationships
  3.    A relationship between two entities
  4.    An attribute with two different relationships
 Discuss Question
Answer: Option C. -> A relationship between two entities
Question 5. A relationship is which of the following?
  1.    Weak entity
  2.    Link between entities
  3.    A person, place, or thing
  4.    Property or characteristic of an entity
 Discuss Question
Answer: Option B. -> Link between entities
Question 6. When the minimum and maximum number of instances of an entity is one, you know which of the following?
  1.    Mandatory one
  2.    Cannot tell
  3.    Optional one
  4.    Mandatory many
 Discuss Question
Answer: Option A. -> Mandatory one
Question 7. An oval represents which of the following in an ERD?
  1.    Optional One
  2.    Relationship
  3.    Attribute
  4.    Entity
 Discuss Question
Answer: Option C. -> Attribute
Question 8. An entity name should be which of the following?
  1.    Specific to the organization
  2.    Concise
  3.    A singular noun
  4.    All of these
 Discuss Question
Answer: Option D. -> All of these
Question 9. A rectangle represents which of the following in an ERD?
  1.    Optional One
  2.    Entity
  3.    Relationship
  4.    Attribute
 Discuss Question
Answer: Option B. -> Entity
Question 10. An attribute name should be which of the following?
  1.    Singular verb or verb phrase
  2.    All of these
  3.    Follow a standard format
  4.    Use a alias
 Discuss Question
Answer: Option C. -> Follow a standard format

Latest Videos

Latest Test Papers