Home / CSE MCQs / DBMS MCQs :: Views - DBMS

CSE MCQs :: DBMS MCQs

  1. Which of the following creates a virtual relation for storing the query ?
  2. A.
    Function
    B.
    View
    C.
    Procedure
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Materialised views make sure that
  4. A.
    View definition is kept stable
    B.
    View definition is kept up-to-date
    C.
    View definition is verified for error
    D.
    View is deleted after specified time

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. Updating the value of the view
  6. A.
    Will affect the relation from which it is defined
    B.
    Will not change the view definition
    C.
    Will not affect the relation from which it is defined
    D.
    Cannot determine

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?
  8. A.
    The from clause has only one database relation.
    B.
    The query does not have a group by or having clause.
    C.
    The select clause contains only attribute names of the relation, and does not have any expressions, aggregates, or distinct specification.
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause ?
  10. A.
    With
    B.
    Check
    C.
    With check
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum