The Relational Model and Normalization Questions and Answers

Practice Mode
Showing 10 of 21 questions
Q1
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
  • A A ? B.
  • B A ? C.
  • C A ? (B,C).
  • D (B,C) ? A.
Answer: Option A
Q2
The different classes of relations created by the technique for preventing modification anomalies are called:
  • A normal forms.
  • B referential integrity constraints.
  • C functional dependencies.
  • D None of the above is correct.
Answer: Option A
Q3
A relation is in this form if it is in BCNF and has no multivalued dependencies:
  • A second normal form.
  • B third normal form.
  • C fourth normal form.
  • D domain/key normal form.
Answer: Option C
Q4
Row is synonymous with the term:
  • A record.
  • B relation.
  • C column.
  • D field.
Answer: Option A
Q5
The primary key is selected from the:
  • A composite keys.
  • B determinants.
  • C candidate keys.
  • D foreign keys.
Answer: Option C
Q6
Which of the following is a group of one or more attributes that uniquely identifies a row?
  • A Key
  • B Determinant
  • C Tuple
  • D Relation
Answer: Option A
Q7
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
  • A transitive dependency.
  • B insertion anomaly.
  • C referential integrity constraint.
  • D normal form.
Answer: Option C
Q8
A relation is considered a:
  • A Column.
  • B one-dimensional table.
  • C two-dimensional table.
  • D three-dimensional table.
Answer: Option C
Q9
In the relational model, relationships between relations or tables are created by using:
  • A composite keys.
  • B determinants.
  • C candidate keys.
  • D foreign keys.
Answer: Option D
Q10
A functional dependency is a relationship between or among:
  • A tables.
  • B rows.
  • C relations.
  • D attributes.
Answer: Option D

📚 More from Database

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