SQL Views MCQ

Test your knowledge with important SQL Views MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more SQL Views MCQs at Bissoy

• On the basis of number of tables constituted, a view can be classified in how many categories?
  ক

  2

  খ

  3

  গ

  4

  ঘ

  5
• Which of the following statement can be used to drop a view in SQL?
  ক

  DELETE VIEW view_name FROM Table_name;

  খ

  DROP VIEW view_name FROM Table_name;

  গ

  DROP VIEW view_name;

  ঘ

  DELETE VIEW view_name;
• In SQL, we can insert rows in a view in a similar way as we insert them in a table.
  ক

  True

  খ

  False
• All NOT NULL columns from the base table must be included in the view in order for the INSERT command to function.
  ক

  True

  খ

  False
• Which of the following can be used to ensure that all the update and insert satisfy the conditions in the view definition?
  ক

  WITH

  খ

  WITH CHECK

  গ

  CHECK

  ঘ

  IF
• Which of the following creates a virtual relation for storing a query?
  ক

  Table

  খ

  Function

  গ

  View

  ঘ

  Database
• In SQL, views can also call as which of the following?
  ক

  Simple Table

  খ

  Virtual Table

  গ

  Actual Table

  ঘ

  Duplicate Table