Modeling Data in the Organization Questions and Answers

Practice Mode
Showing 10 of 15 questions
Q1
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
Answer: Option B
Q2
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
Answer: Option D
Q3
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
Answer: Option C
Q4
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
Answer: Option B
Q5
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
Answer: Option C
Q6
A rectangle represents which of the following in an ERD?
  • A Attribute
  • B Entity
  • C Optional One
  • D Relationship
Answer: Option B
Q7
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.
Answer: Option D
Q8
An oval represents which of the following in an ERD?
  • A Attribute
  • B Entity
  • C Optional One
  • D Relationship
Answer: Option A
Q9
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
Answer: Option A
Q10
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.
Answer: Option B
Database
Back to Database
Questions and Answers for Competitive Exams Various Entrance Test