Relational Model in DBMS - Quiz

  • AManipulative components
  • BIntegrity constraints
  • CStructural components
  • DAll of these
  • ATuples
  • BSet of attributes
  • CRelation name
  • DBoth (b) and (c)
  • AThe primary key consists of more than one attribute.
  • BReferential integrity is violated when attempting to enter data.
  • CIt contains multiple foreign keys.
  • DAll of these.
  • ASuperkey
  • BIrreducible superkey
  • CForeign key
  • DPrimary key
  • ABe numeric.
  • BMatch the field value of a primary key in a related table.
  • CBe defined in all tables in the database.
  • DBe unique.
  • ARecursive joins
  • BLoss of data from employee sabotage
  • CLoss of data from any one corrupted table
  • DData redundancy
  • APrimary key attribute cannot have null value.
  • BPrimary key constraint enforces entity integrity.
  • CUnique key constraint is preferable over primary key constraint.
  • DMultiple primary key constraints can be defined on a relation.