placeholder image to represent content

M2-UF1-A

Quiz by Miquel Carvall

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
20 questions
Show answers
  • Q1
    How many primary keys should have any relational table?
    1
    n
    at least 1
    2
    30s
  • Q2
    How many foreign keys can have any relational table as a minimum?
    2
    1
    n
    0
    30s
  • Q3
    How many foreign keys can have any relational table as a maximum?
    number of attributes -1
    1
    number of attributes
    2
    30s
  • Q4
    The integrity of entity is given by the...
    DB
    FK
    PK
    DBA
    30s
  • Q5
    The referential integrity is given by the...
    FK
    DBA
    DB
    PK
    30s
  • Q6
    The behavior of a foreign key depends on...
    the DB
    its configuration
    number of its attributes
    its PK
    30s
  • Q7
    The resulting table of a binary N:M relationship has...
    2 PKs
    2 FKs
    1 FK
    2 attributes
    30s
  • Q8
    The PK coming from a weak entity, how many attributes has as a minimum?
    1
    n
    2
    it depends
    30s
  • Q9
    A candidate key can have subsets being candidate keys?
    Yes if it is FK
    No
    Yes if it is PK
    Yes
    30s
  • Q10
    The table derived from a reflexive entity always receives attributes
    No
    Yes
    Yes, the FKs
    Yes, the PK
    30s
  • Q11
    If you have 4 candidate keys, how many PKs can you have?
    2
    1
    4
    3
    30s
  • Q12
    If you have 4 candidate keys, how many AKs will you have?
    4
    3
    2
    1
    30s
  • Q13
    Can you think of an overlapped specialization as being an exclusive relationship?
    Yes, sometimes
    No, most of the times
    No, never
    Yes, always
    30s
  • Q14
    Can you think of a disjoint specialization as being an exclusive relationship?
    No, never
    Yes, always
    Yes, sometimes
    No, most of the times
    30s
  • Q15
    A table that fulfills 1NF and has no attributes outside the key
    has no FKs
    doesn't fulfill 2NF
    can fulfill 2NF
    sure fulfills 2NF
    30s

Teachers give this quiz to your class