Logical Database Design Questions and Answers

Practice Mode
Showing 10 of 15 questions
Q11
A relation has which of the following properties?
  • A Each row is not unique.
  • B Attributes can have the same name within a given table.
  • C Each relation has a unique name.
  • D The order of the columns is significant.
Answer: Option C
Q12
When mapping a ternary relationship with an associative entity into a relation which of the following is true?
  • A One relation is created.
  • B Two relations are created.
  • C Three relations are created.
  • D Four relations are created.
Answer: Option D
Q13
 When mapping a regular entity into a relation which of the following is true?
  • A One relation is created.
  • B Two relations are created.
  • C Three relations are created.
  • D Four relations are created.
Answer: Option A
Q14
When mapping a supertype/subtype relationship which of the following is true?
  • A The supertype primary key is assigned to each subtype.
  • B The subtype primary key is assigned to each supertype.
  • C There is no link between the supertype/subtype entities.
  • D There is no primary key/foreign key relationship between a supertype/subtype.
Answer: Option A
Q15
Relations are:
  • A two-dimensional tables.
  • B three-dimensional tables.
  • C four-dimensional tables.
  • D five-dimensional tables.
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test