Does a view occupy space in the database

Assignment Help Basic Computer Science

Reference no: EM13739690

Discuss the features of a database VIEW. Specifically, address the following:
1. What is a VIEW and what are its uses?
2. Does a view occupy space in the database? In other words, does a view contain any data?
3. When we execute a SELECT statement on a view, where does the data come from?
4. When we execute an INSERT, UPDATE or DELETE on a view, what data gets affected?
5. If we drop a view, what happens to its base tables?

Reference no: EM13739690

Questions Cloud

Want to confirm and verify prior to notifying users : The database administrator for your company. Your staff just informed you that they have noticed several unauthorized attempts to access the database. You are trying to decide how to address this issue to your management team. What type of informatio..

Major areas of responsibility : Review the organizational charts presented in your reading materials. The sample organization chart lists major areas of responsibility. Select one area under the CFO and indicate the additional levels of management that would fall under this area..

Write a profile of jonahs character is described in book : Write a profile of Jonah's character by looking at the way the character is described, his actions, his interactions with other characters, and his actions in comparison to others.

Capital investment plan proposal topic : A capital investment plan is a document that is typically prepared to obtain funding and/or financing. For your Final Project, which is due in Week Five, you will assume the role of a department manager who is seeking funding/financing for a capit..

Does a view occupy space in the database : What is a VIEW and what are its uses?2. Does a view occupy space in the database? In other words, does a view contain any data?3. When we execute a SELECT statement on a view, where does the data come from?

Proposal for the capital investment : In a one- to two-page paper, which will be included in your Final Project, explain why your manager or the board would or would not accept a proposal for the capital investment. List at least three arguments that could be used for or against the p..

How would you regard the story of jonah : How would you regard the story of Jonah, is it a story about Jonah and the Whale? Is it a story of the power of repentance? Or is it a story about a man running away from his destiny?

Analyze the agencys compensation for employees : Using the budget from the selected agency, write a three to five (3-5) page paper in which you use your agency's or organization's budget from the previous assignment (Huntsville City Schools): Analyze the agency's compensation for employees

What is the sharp ratio of the stock : Based on daily data of the past 5 years, What is the sharp ratio of the stock and What is the sharp ratio of SPY

User Account

All Pages