Mastercard Interview Question | View

Question

For what purpose we are using view? How is it created to get the job done?

in progress 2
Dhruv2301 55 years 2 Answers 1046 views Great Grand Master 0

Answers ( 2 )

  1. Ognish
    0
    Reply

    Views are virtual tables that can be a great way to optimize your database experience. Not only are views good for defining a table without using extra storage, but they also accelerate data analysis and can provide your data extra security.

    CREATE VIEW V_Customer
    AS SELECT *
    FROM Customer;

  2. swap007
    0
    Reply

    One of the things is to support legacy code.
    If you want to change the structure of your table which can break the old code
    in lot of different ways, you can create a view from the table and give the same name to
    the view as of the table. This will help in not breaking the code.

Leave an answer

Browse
Browse