Discuss the pros and cons of using dynamic views
What will be an ideal response?
A dynamic view is useful, since it provides a way to access part of a table or a combination of columns from multiple tables. A view can simplify query commands, since much of the complicated syntax of a query can be done to create the view. A view can also improve programmer productivity, since programmers can access views rather than have to rewrite the SQL commands for a query. Security is increased, since users can only see what the view presents. Also, views use little or no storage space. On the downside, views use processing time each time that the view is recreated for reference. Also, the views may or may not be recreatable.
You might also like to view...
Ultimate ________ of a firm depends on who owns the major portion of the common shares and thus controls the direction of the firm through voting power
A) managerial control B) creditor control C) shareholder control D) government control
An organization using HDFS realizes that hardware failure is a(n):
A) norm. B) irregularity. C) anomaly. D) inconsistency.