Home / CSE MCQs / DBMS MCQs :: Discussion

Discussion :: DBMS MCQs

  1. Which of the following closely resembles Create view ?
  2. A.
    Create table . . .like
    B.
    Create table . . . as
    C.
    With data
    D.
    Create view as

    View Answer

    Workspace

    Answer : Option B

    Explanation :

    Create table . . . as

    The 'create table . . . as' statement closely resembles the create view statement and both are defined by using queries.The main difference is that the contents of the table are set when the table is created, whereas the contents of a view always reflect the current query result.


Be The First To Comment