Question: Why is it not possible to update a base table via update commands against a view?

Why is it not possible to update a base table via update commands against a view?

Step by Step Solution

★★★★★

3.40 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

We cannot insert or update data using view The view is a virtual table W... View full answer

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 Modern Database Management 13th Edition Questions!

Q:

Why is it not possible to combine a global replacement policy and a fixed allocation policy?

Q:

Why is it not possible to enforce memory protection at compile time?

Q:

Why is it not possible to enforce memory protection at compile time?

Q:

. Why is it not possible to update a base table via update commands against a view?

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

Q:

Question 1: Triggers and Stored Procedures: Download the file named assignment4_database.sql from D2L. Run the file from MySQL workbench, putty or Terminal. If using Metrostate login via Putty or...

Q:

CIS-336: Lab7: Working with Views LAB OVERVIEW Lab 7 will introduce the concept of database views. This lab may be completed using either DeVrys Omnymbus EDUPE-APP lab environment, or a local copy of...

Q:

Problem Set 15 In this assignment you will be creating views. Views are a way to display information from various tables or views in a way that is easily comprehended by end-users. 1. Log on to your...

Q:

In this assignment you will be creating views. Views are a way to display information from various tables or views in a way that is easily comprehended by end-users. 1. Log on to your Oracle ApEx...

Q:

In this chapter you read how one act, such as the assault and battery by police upon the suspect Rodney King, could be both a state and a federal crime without violating the prohibition against...

Q:

Find a value of the standard normal random variable z, call it z0, such that a. P(z z0) = .2090 b. P(z z0) = .7090 c. P(-z0 z

Q:

Explain the concept of productivity. Also, discuss how the concept of productivity has gained worldwide attention.

Q:

1. No firm is completely sheltered from rivals; all firms compete for consumer dollars. If that is so, then pure monopoly does not exist. Do you agree? Explain. How might you use Chapter 6s concept...

Q:

Which product is ordered most frequently?

Q:

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...

Q:

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.

Q:

George Bailey is considering investing in Gower Pharmaceuticals. He has gathered the following information: Probability of the Se lo ha Economic Economy Stars VnGood 2014 Good 25 Tag 30 No Good 154...

Q:

The market price of a stock is $ 2 2 . 2 1 and it just paid a dividend of $ 1 . 0 9 . The required rate of return is 1 1 . 3 1 % . What is the expected growth rate of the dividend? Answer format:...

Q:

Bonus Assignment 1 - FINC1231 - Chapter 14 Prepare an amortization schedule for the mortgage of a house of 500,000 with 20% down payment. Interest rate is 5% compounded semiannually. The payments are...