Home / CSE MCQs / DBMS MCQs :: Constraints - DBMS

CSE MCQs :: DBMS MCQs

  1. To include integrity constraint in a existing relation use :
  2. A.
    Create table
    B.
    Modify table
    C.
    Alter table

  3. Which of the following is not a integrity constraint ?
  4. A.
    Not null
    B.
    Positive
    C.
    Unique
    D.
    Check 'predicate'

  5. Foreign key is the one in which the ________ of one relation is referenced in another relation.
  6. A.
    Foreign key
    B.
    Primary key
    C.
    References
    D.
    Check constraint

  7. Domain constraints, functional dependency and referential integrity are special forms of _________.
  8. A.
    Foreign key
    B.
    Primary key
    C.
    Assertion
    D.
    Referential constraint

  9. Which of the following is the right syntax for assertion?
  10. A.
    Create assertion 'assertion-name' check 'predicate';
    B.
    Create assertion check 'predicate' 'assertion-name';
    C.
    Create assertions 'predicates';
    D.
    All of the mentioned

  11. Data integrity constraints are used to:
  12. A.
    Control who is allowed access to the data
    B.
    Ensure that duplicate records are not entered into the table
    C.
    Improve the quality of data entered for a specific property (i.e., table column)
    D.
    Prevent users from changing the values stored in the table

  13. Which of the following can be addressed by enforcing a referential integrity constraint?
  14. A.
    All phone numbers must include the area code
    B.
    Certain fields are required (such as the email address, or phone number) before the record is accepted
    C.
    Information on the customer must be known before anything can be sold to that custome
    D.
    When entering an order quantity, the user must input a number and not some text (i.e., 12 rather than 'a dozen')

  15. _____________, express the number of entities to which another entity can be associated via a relationship set.
  16. A.
    Mapping Cardinality

  17. An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as
  18. A.
    One-to-many
    B.
    One-to-one
    C.
    Many-to-many
    D.
    Many-to-one

  19. An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A.
  20. A.
    One-to-many
    B.
    One-to-one
    C.
    Many-to-many
    D.
    Many-to-one