Logical Database Design Questions and Answers

Practice Mode
Showing 10 of 15 questions
Q1
The entity integrity rule states that:
  • A no primary key attribute may be null.
  • B no primary key can be composite.
  • C no primary key may be unique.
  • D no primary key may be equal to a value in a foreign key.
Answer: Option A
Q2
When mapping a many-to-many unary relationship 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 B
Q3
If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
  • A First normal form
  • B Second normal form
  • C Third normal form
  • D Fourth normal form
Answer: Option B
Q4
A foreign key is which of the following?
  • A Any attribute
  • B The same thing as a primary key
  • C An attribute that serves as the primary key of another relation
  • D An attribute that serves no purpose
Answer: Option C
Q5
A transitive dependency is which of the following?
  • A A functional dependency between two or more key attributes
  • B A functional dependency between two or more nonkey attributes.
  • C A relation that is in first normal form.
  • D A relation that is in second normal form.
Answer: Option B
Q6
When mapping a multivalued attribute 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 B
Q7
If no multivalued attributes exist in a relation, then the relation is in what normal form?
  • A First normal form
  • B Second normal form
  • C Third normal form
  • D Fourth normal form
Answer: Option A
Q8
A primary key is which of the following?
  • A Any attribute
  • B An attribute that uniquely identifies each row
  • C An attribute that uniquely identifies each column
  • D A derived attribute
Answer: Option B
Q9
The relational model consists of:
  • A data in the form of tables.
  • B data redundancy.
  • C operations using non-SQL languages.
  • D unorganized data.
Answer: Option A
Q10
When mapping a binary many-to-many relationship 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 C

📚 More from Database

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