Question: Which statement is true regarding views? a . Only simple views can use indexes existing on the underlying tables b . Both simple and complex

Which statement is true regarding views?
a.
Only simple views can use indexes existing on the underlying tables
b.
Both simple and complex views can use indexes existing on the underlying tables
c.
Complex views can be created only on multiple tables that exists in the same schema
d.
If a view is dropped with the DROP VIEW command, the data in the original table will get affected.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

Sundar G. Bharadwaj, P. Rajan Varadarajan, & John Fahy Sustainable Competitive Advantage in Service Industries: A Conceptual Model and Research Propositions The purpose of competitive strategy is to...

Q:

I need the multiple choice questions answers from chapter 4 and 5 of the attached & Monograph...

Q:

Please find attached assignment and see if you can help me in that and provide me the main points (in the article of spencer and web (2015) as attached) that need to be criticized, also I need an...

Q:

Hello question 40 for this file and the answer is $372,850. but i try to get this answer but i couldnot it find the way if you explain to me if you explain to me ?? ch4 1. For business combinations...

Q:

I have questions in page 44 m/c from 35 to 64 if you explain to me the answers for company pell ch4 1. For business combinations involving less than 100 percent ownership, the acquirer recognizes and...

Q:

5, Putting Together an Evaluation Matrix An evaluation plan is a written document that describes the cWill/mat\Questions to ask yourself when putting together an evaluation matrix: Evaluation...

Q:

4) Parktown Realty Inc developed an upscale condominium complex. On October 1, Miranda Wine signed an offer to purchase one of the units. Part of that document said, "This offer is irrevocable by the...

Q:

Which of the following statements is correct? Statement 1. Of all the techniques used in finance, the least important is the concept of the time value of money. Statement 2. Compounding is the...

Q:

Please scan the SEC Plain English that I've attached. Please visit to this link.http://www.sec.gov/Archives/edgar/data/320193/000119312513416534/d590790d10k.htm#toc590790_9 Please read pages 25...

Q:

Module 9 Assignment: TOC Answer all the questions and submit your answer report to Module 9 Assignment in Dropbox by the deadline . The report should be typed, single spaced, in one MS Word file. You...

Q:

a. What is a process? b. What is the relationship between a process and its subprocesses? c. What is statistical process control?

Q:

Contrast and compare the WACC and the APV methods and critically evaluate strengths and weaknesses of the two methods. What are the underlying assumptions of the two methods? Refer to the existing...

Q:

A bond that may be converted entirely to shares of stock at the discretion of the bondholder is called a Blank______ bond. Multiple choice question. optionable stock convertible warrantable

Q:

Captain John has retired and wishes to make a tax-free contribution from his IRA to his church. To do this without a penalty, certain rules must be met. Which of the following is incorrect? Question...