What is a view?
What will be an ideal response?
A view is a mechanism in SQL that allows the structure of a query to be saved in the RDBMS. A view, which is also known as a virtual table, is not an actual table and does not have any data physically saved. Every time a view is invoked, it executes a query that retrieves the data from the actual tables. A view can be used in SELECT statements just like any other table from a database.
You might also like to view...
Which of the following is an example of a feasibility report?
A) A report to determine which of three firms to use for after-hours security B) A report to determine whether a company should provide an on-site gym for its employees C) A report about a firm's profitability to be sent to the company's shareholders D) A report on a meeting held with members of the local chamber of commerce
Which of the following methods would be appropriate for developing skills in revenue management, as discussed in the text?
A. behavioral modeling B. self-directed learning C. group-building methods D. apprenticeship
Rotan Corporation keeps careful track of the time required to fill orders. The times recorded for a particular order appear below: HoursMove time3.2Wait time10.9Queue time5.1Process time1.2Inspection time0.2?The delivery cycle time was:
A. 8.3 hours B. 3.2 hours C. 19.2 hours D. 20.6 hours
Which of the following is not a type of trust
a. credit shelter trust b. qualified terminable interest property trust c. crummey trust d. charitable remainder trust e. credible property sharing trust