Why do we use views instead of tables?



Why do we use views instead of tables?..

Answer / Pranai Toppo

"We use views to simplify querying, provide multiple ways to look at the same data (as derived tables), restrict access to sensitive data by defining views with limited columns, and enforce security policies"

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

Explain the storage engines in mysql?

1 Answers  


What are mysql functions?

1 Answers  


Write a query to count the number of rows of a table in mysql.

1 Answers  


What is difference between schema and table?

1 Answers  


What are the advantages and disadvantages of MySQL?

0 Answers   Satyam,


How to delete an existing column in a table?

1 Answers  


How do I setup mysql?

1 Answers  


How can we convert between Unix & MySQL timestamps?

1 Answers  


Is there an object-oriented version of MySQL library functions?

1 Answers  


How do I run a query in mysql?

1 Answers  


What is a deterministic function?

1 Answers  


Explain multi-version concurrency control in MySQL?

2 Answers  


Categories