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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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')

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum