Sail E0 Webinar

MCQs

Total Questions : 65 | Page 4 of 7 pages
Question 31. A key is a group of one or more attributes that uniquely identifies a row.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 32. A functional dependency is a relationship between or among attributes.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 33. Keys made up of two or more attributes are called composite keys.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 34. Relations are categorized into normal forms according to the referential integrity constraints that they have.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 35. A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 36. A functional dependency is always an equation.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 37. A relation has cells that hold multi-value entries.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 38. In a relation, the rows are sometimes called "fields".
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 39. A primary key is a composite key that was selected to be the main identifier for the relation.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 40.  
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:
  1.    A → B.
  2.    A → C.
  3.    A → (B,C).
  4.    (B,C) → A.
 Discuss Question
Answer: Option A. -> A → B.

Latest Videos

Latest Test Papers