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 |
Datatypes are unlimited,true or false?
what is Normalization means..?
8 Answers AZTEC, Bank Of America, Infosys, TCS,
define primary key index, bitmap index, hash index,virtual indwx
what is data set ?
If the master device is full, how do I make the master database bigger?
What is a database example?
List some advantages of dbms.
What happens when shared and exclusive locks are applied on data item?
How to shrink a database?
CLI stands for?
What is lagging in DBMS ?
List various types of log-based recovery in DBMS.
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)