Multiple choice technology

Which of the following is TRUE about Views in SQL?

  1. Views are windows of existing table

  2. Creation of view is done by using CREATE VIEW statement

  3. Views do not contain data but table from which it is created contain data

  4. All the Above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

To answer this question, the user needs to have a basic understanding of Views in SQL.

A. This option is incorrect. Views are not windows of existing tables; rather, they are virtual tables that are created using a SELECT statement.

B. This option is correct. Views in SQL are created using the CREATE VIEW statement. This statement allows you to define a view based on a SELECT statement that retrieves data from one or more tables.

C. This option is also correct. Views do not contain any data themselves. Instead, they are virtual tables that are defined based on the data in one or more existing tables. Any changes made to the data in the underlying tables will be reflected in the view.

D. This option is correct. All of the above statements are true about views in SQL.

Therefore, the answer is: D. All the Above

Keep practicing — related questions