What are the disadvantages of views in a database?



What are the disadvantages of views in a database?..

Answer / Shumaila Haque

Disadvantages of views include:n
1. Reduced Performance: Since views are processed each time they're accessed, they can lead to slower response times compared to direct table access.n
2. Lack of Control: Views may hide data or manipulate it in ways that the user might not be aware of, potentially leading to misinterpretation.n
3. Limited Modification Capabilities: Changes cannot be made directly through views; instead, you must alter the underlying table and then update the view.n

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Databases AllOther Interview Questions

Datatypes are unlimited,true or false?

2 Answers   Infosys,


what is Normalization means..?

8 Answers   AZTEC, Bank Of America, Infosys, TCS,


define primary key index, bitmap index, hash index,virtual indwx

1 Answers   Cap Gemini,


what is data set ?

1 Answers  


If the master device is full, how do I make the master database bigger?

1 Answers  


What is a database example?

1 Answers  


List some advantages of dbms.

1 Answers  


What happens when shared and exclusive locks are applied on data item?

1 Answers  


How to shrink a database?

1 Answers  


CLI stands for?

3 Answers   IBM,


What is lagging in DBMS ?

1 Answers   Hexaware,


List various types of log-based recovery in DBMS.

1 Answers   Verifone,


Categories