0
Advantages:
•Data isn't dependent on structure of the database.
•Restrict access to a database.
•Subset of data contained in a table.
•Join and simplify multiple tables into a single virtual table.
•Acts as aggregated tables, where aggregated data (sum, average etc.) are calculated and presented as part of the data.
•Gives real time data.
Disadvantages:
•Rows available through a view are not sorted and are not ordered either.
•Cannot use DML operations on a View.
•When table is dropped view becomes inactive, it depends on the table objects.
•It affects performance, querying from view takes more time than directly querying from the table
Pratyush7
What else can I help you with?
Advantages and disadvantages of foxpro?
discuss database and field functions
Advantages and disadvantages Flat file database?
No one knows
Advantages and disadvantages of clustering?
Advantages: • High performance • Large capacity • High availability • Incremental growth Disadvantages: • Complexity • Inability to recover from database corruption
What are the advantages and disadvantages of a computer base database?
if there's a power cut then don't use it
Advantages and disadvantages of lotus notes?
There are many advantages and disadvantages of Lotus Notes. Advantages include the extensive database options that lotus notes has to offer. A disadvantage is it's clunky interface which needs to be modernized.
What are the advantages and disadvantages of using a paper based database?
you could get your head stapled to the paper and will die....
The advantages and disadvantages of using Microsoft Excel Cube Function to extract data from a database?
None
What are the advantages and disadvantages of PHP with mysql?
Ultimately PHP is a programming language and MySQL is a database language. Using PHP with MySQL is a nice combination with built-in support and the simplicity of it all. However, there aren't a lot of disadvantages of using PHP with a database, it just allows for better data organization and whatnot. There are definitely advantages and disadvantages to using a database other than MySQL (such as MongoDB or PostgreSQL).
Explain three disadvantages of centralized database and distributed database?
what are the disadvantages of centralized database system
What are the Advantages and disadvantages of Entity Relationship Model?
Entity-relationship model advantages and disadvantages AdvantagesDisadvantagesConceptual simplicityVisual representationEffective communicationIntegration with the relational database modelLimited constraint representationLimited relationship representationNo representation of data manipulationLoss of information
What are the advantages disadvanteges of using database?
Advantages of using a database include efficient data organization, easy data retrieval, and data security. However, disadvantages can include high initial setup costs, potential for data redundancy, and complexity of managing and maintaining the database system.
What is a cloud computing database?
A cloud computing database is one in which a user's information is stored remotely for a fee. There are advantages and disadvantages to this. An advantage is that your information can be retrieved from any site, but a downfall is in the security of a user's information.
