Why is it not possible to update a base table via update commands against a view?
Question:
Why is it not possible to update a base table via update commands against a view?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 60% (10 reviews)
We cannot insert or update data using view The view is a virtual table W...View the full answer
Answered By
Hardik Dudhat
I am semi-qualified Chemical Engineering ,I have scored centum in accounting in my senior secondary and in my graduation. I have always helped my fellow students with their concerns on the subject, i have tutored on various tutoring sites in the past and also have taken home tuitions for degree and MBA students. As a tutor, I don't want my students to just get a solution, I want them to understand the concept and never have a doubt in that area thereon and i believe in excelling and not in educating.
0.00
0 Reviews
10+ Question Solved
Related Book For
Modern Database Management
ISBN: 9780134773650
13th Edition
Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman
Question Posted:
Students also viewed these Computer science questions
-
Why is it not possible to combine a global replacement policy and a fixed allocation policy?
-
Why is it not possible to enforce memory protection at compile time?
-
Why is it not possible to enforce memory protection at compile time?
-
Consider the plane stress inhomogeneous case with only variation in elastic modulus given by E = E(y) = 1/ (Ay + B). Further assume that the Airy function depends only on y, = (y). Show that...
-
Estimating the volume of loans that will be made at a credit union is crucial to effective cash management in those institutions. In the table that follows are quarterly data for a real credit union...
-
Determine if the \(\mathrm{W} 14 \times 22\) beam will safely support a loading of \(w=1.5 \mathrm{kip} / \mathrm{ft}\). The allowable bending stress is \(\sigma_{\text {allow }}=22 \mathrm{ksi}\)...
-
The transactions for Dancing Antz, Inc., for the month of September 2010 have been posted to the accounts as follows: Requirements 1. Prepare the journal entries that served as the sources for the...
-
A jewelry store makes necklaces and bracelets from gold and platinum. The store has developed the following linear programming model for determining the number of necklaces and bracelets (x1 and x2)...
-
Collier's Hat Inc. has just opened and needs to calculate the desired price to optimize sales efforts. He has spent the following money to open the store and purchase inventory. Variable Costs per...
-
The manufacturer of a certain brand of auto batteries claims that the mean life of these batteries is 45 months. A consumer protection agency that wants to check this claim took a random sample of 24...
-
What can Persistent Stored Modules be used for?
-
When should we use joining and sub-query techniques?
-
Place a number, 1 through 7, in front of each of the following balance sheet categories to designate the order in which they are to be presented in a classified balance sheet. Long-term investments...
-
java code ReadFile Create-a linked list from an input file (input.txt) that contains an even number of first names. The number of items in the file is unknown. Split Create-a split function that...
-
Please provide your prediction for Apple sales for the year ending in September 2 0 2 4 ? Do you think Apple will generate more sales this current year, than they have in prior years? Why yes or why...
-
Consider a two-period binomial model in which a stock currently trades at a price of$70. The stock price can go up 15% or down 15% each period. The risk-free rate is 5%.Calculate the price of a...
-
You are just 25 years old and you have $50,000 in your retirement saving accounts. You expect to retire at the age of 65 (work for 40 more years) and expect to live for another 25 years after your...
-
Write the torque equation you would use to find the force F extered by the second support. Do not solve the equation T 1 m F=? 4 m long, 15 kg beam 20 kg person
-
The Canton Corporation shows the following income statement. The firm uses FIFO inventory accounting. a. Assume in 20X2 that the same 17,600-unit volume is maintained, but that the sales price...
-
The relationship described in question 7 does not always appear to hold. What factors, besides the number of firms in the market, might affect margins?
-
Which product is ordered most frequently?
-
For each salesperson, list the total number of orders by month for the year 2015. (Hint: If you are using Access, use the Month function. If you are using Oracle, convert the date to a string, using...
-
List MaterialName, Material, and Width for raw materials that are not cherry or oak and whose width is greater than 10 inches. Show how you constructed this query using a Venn diagram.
-
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Submit Date March 1 March 5 March 9 March 18 March 25 March 29...
-
Wilmington Company has two manufacturing departments-Assembly and Fabrication. It considers all of its manufacturing overhead costs to be fixed costs. The first set of data that is shown below is...
-
What are the fundamental differences between preemptive and cooperative multitasking in an operating system, and in which scenarios would each be most effective ?
Study smarter with the SolutionInn App