Features of a database view

Assignment Help Data Structure & Algorithms

Reference no: EM13765036

SQL

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: EM13765036

Questions Cloud

What is the accounting and financial break-even quantity : A project has the following estimated data: price = $66 per unit; variable costs = $43 per unit; fixed costs = $16,500; required return = 8 percent; initial investment = $25,000; life = five years. What is the accounting break-even quantity? What is ..

Meaning of the term tax-planning strategy : Explain the meaning of the term "tax-planning strategy" as the term is used in SFAS No. 109.

How can we bring him back to the us : You have been asked to investigate the case. Please discuss the legal issues surrounding the case. Also, you have identified the individual involved. How can we bring him back to the U.S? Is it possible

Write a paper on causal analysis on texting and driving : Write a five page research paper on causal analysis on texting and driving.

Features of a database view : Does a view occupy space in the database? In other words, does a view contain any data

What is the meaning of procedural due process : What is the meaning of "procedural due process?" How did the expansion of the Bill of Rights change due process

What is each bonds expected capital gains yield today : Use the following corporate bond quote information to answer the questions that follows. since this is a corporate bond, assume the company makes semi-annual coupon payments and also assume the bond matures on today's date in its maturity year. What ..

Journal entry summarizing the payment : Prepare a journal entry summarizing the payment of Bob's total salary during the year. Prepare a journal entry summarizing the employer payroll tax expense on Bob's salary for the year.

Issues related to rbs brand : Ensure the pro forma income statement is complete and correct. Ensure you clearly identify the relevant long-term implications of your decision.

User Account

All Pages