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...
Explain the four common elements of organizations proposed by Edgar Schein.
What will be an ideal response?
During the year, Dempsey Corporation's current ratio increased while its quick ratio decreased. Which of the following could help explain this situation?
A) A decrease in accounts receivable during the year B) An increase in accounts payable during the year C) The sale of short-term investments during the year D) An increase in inventory levels during the year
All of the following are advantages of using trucks EXCEPT
A. handling a variety of goods. B. fast delivery speed. C. serving a limited number of locations. D. reliability in meeting delivery schedules. E. flexibility.
A union is attempting to organize clerical and factory workers at a local manufacturing plant in Oshkosh. The NLRB makes a determination to include the clerical and factory workers in the same bargaining unit because they have indicated that their demands are very similar. The NLRB is applying a principle of:
A. Community of interests. B. Geographical proximity. C. Interdependence of jobs. D. Exchange of labor.