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...
-
Let's go back to the ongoing case you selected. This will be either your current employer, a specific organization you want to work in, or one of the two hypothetical organizations described in...
-
Gallagher Counter Co. produces quartz countertops in two sequential production departments: Forming and Polishing. The Polishing Department calculated the following costs per equivalent unit (square...
-
Where would you put Ford in terms of competitive position? Why? The old phrase, The bigger they are, the harder they fall, perfectly describes what has happened to the U.S. auto industry over the...
-
10.Carp Co has announced that it will pay an annual dividend equal to 55% of earnings. Its earnings per share is $0.80, and it has ten million shares in issue. The return on equity of Carp Co is 20%...
-
During peak periods, Temporary Employment Corporation (TEC) places temporary workers in companies. TECs manager gives you the following description of the business: TEC has a file of candidates who...
-
What can Persistent Stored Modules be used for?
-
When should we use joining and sub-query techniques?
-
Imari Brown is attending community college. She has $2,000 of education expenses. She claims herself on her tax return. She is trying to decide between the tuition and fees deduction or an education...
-
5 job descriptions for the accounting and payroll admin that you would apply for with a couple of sentences explaining why you chose them. Identify technical and specific skills as well as keywords...
-
Forty-six mountains in the Adirondacks of upstate New York are known as the High Peaks with elevations near or above 4000 feet. Below is some R output from a linear regression model of Y= Time...
-
What are scruples? Describe a situation where you demonstrated scruples. What are the dangers of social media for law enforcement officers? In what ways do police departments regulate social media...
-
Determine which values of x would cause the function g(x)=(1)/(x-(-2)) to be undefined.
-
Halbert is an international student who came to study in Australia. After 2 years, he went back home for a holiday and was given 21,000 AUD by his parents as family support funds. Later on, he wired...
-
What is the absolute configuration (R or S) of L-glycerol 3- phosphate? What must be the absolute configuration of the naturally occurring phosphatidic acids biosynthesized from it?
-
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.
-
What is the "CSI effect"? What impact can it have on the criminal justice system and the police? How do you think it can be managed? Be Sure to use (in text citations) cite your sources
-
Suppose a typical consumer market basket in a region is weighted 20 percent for food, 15 percent for energy, and 65 percent for everything else. Suppose the rate of inflation for food is 10 percent,...
-
To Monitor or Not Problem Adapted from Furrow et al. Health Law: Cases, Materials and Problems (8th ed. 2018). You are the chief compliance officer for the Columbia Hospital for Women. The hospital's...
Study smarter with the SolutionInn App