Explain why INSTEAD OF triggers are needed for join views.
Question:
Explain why INSTEAD OF triggers are needed for join views.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 90% (10 reviews)
They are used because it is impossible to write ge...View the full answer
Answered By
PALASH JHANWAR
I am a Chartered Accountant with AIR 45 in CA - IPCC. I am a Merit Holder ( B.Com ). The following is my educational details.
PLEASE ACCESS MY RESUME FROM THE FOLLOWING LINK: https://drive.google.com/file/d/1hYR1uch-ff6MRC_cDB07K6VqY9kQ3SFL/view?usp=sharing
3.80+
3+ Reviews
10+ Question Solved
Related Book For
Database Processing Fundamentals, Design, and Implementation
ISBN: 978-0133876703
14th edition
Authors: David M. Kroenke, David J. Auer
Question Posted:
Students also viewed these Computer science questions
-
Discuss the differences between BEFORE, AFTER, and INSTEAD OF triggers. Give examples to illustrate your answers.
-
Explain the purpose of BEFORE, AFTER, and INSTEAD OF triggers.
-
Explain why the lack of an INSTEAD OF trigger disallows updating views in MySQL.
-
Izmir A.S. issued convertible bonds at their face value of 100,000 lira on December 31, 2020. The bonds have a 10-year life with interest of 10 percent payable annually. At the date of issue, the...
-
Opal Limited owns 80% of the common shares of Fashion Runway Inc. What is the presumed level of influence for this investment? What kind of financial statements should Opal prepare to properly...
-
Truro Excavating Co., owned by Raul Truro, began operations in July and completed these transactions during that first month of operations. July 1 R. Truro invested $80,000 cash in the company. 2 The...
-
Olympic Village Enterprises lost its entire inventory in a hurricane that occurred on July 31,2010. Over the past five years, gross profit has averaged 30% of net sales. The companys records reveal...
-
Robotics Inc. contracts with a customer to build a custom robot to be used in the customers manufacturing operations for $ 2,000,000. If the robot is delivered and operational by January 1, the...
-
Mayburns, a brand of mass produced sunglasses are made using metal frames (which are added at the beginning of production), plastic lens (added when the units are 50% complete) and paint (added when...
-
Consider the following workload: a. Show the schedule using shortest remaining time, non-preemptive priority (a smaller priority number implies higher priority) and round robin with quantum 30 ms....
-
Explain a limitation on the use of AFTER triggers.
-
When an update is in progress, how can the trigger code obtain the value of a column, say C1, before the update began? How can the trigger code obtain the value that the column is being set to?
-
The other trigonometric functions (tangent, cotangent, secant, and cosecant) are defined in terms of sin and cos by Calculate the value of each of these functions at the following angles (all in...
-
What restrictions can be placed on founder stock, and why?
-
What are the challenges of closing a deal? Why do some companies have two closings?
-
What are the most common sources of internal conflict around exit decisions?
-
Complete the table below for a converging lens. Object Location Between lens and focus At focus Between focus and twice the focal length At twice the focal length Beyond twice the focal length At...
-
How are exit decisions affected by market forces?
-
What is the purpose of the preapproach? What are the two prescriptions included in the preapproach?
-
The water in tank A is at 270 F with quality of 10% and mass 1 lbm. It is connected to a piston/cylinder holding constant pressure of 40 psia initially with 1 lbm water at 700 F. The valve is opened,...
-
An AP in a wireless network plays the same role as a link-layer switch in a wired network. However, a link-layer switch has no MAC address, but an AP normally needs a MAC address. Explain the reason.
-
In Figure 15.25 (previous problem), assume that the host with IP address 24.12.10.3 needs to send an IP datagram to the host with IP address 128.41.23.12 somewhere in the world (not shown in the...
-
What is the reason that Bluetooth is normally called a wireless personal area network (WPAN) instead of a wireless local area network (WLAN)?
-
During Year 1, Chung Corporation earned $6,900 of cash revenue and accrued $3,800 of salaries expense. Required: (Hint. Record the events in general ledger accounts under an accounting equation...
-
Prepare Cash Budget from Budgeted Transactions Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $89,000 on May 1, 2019. The following budgeted...
-
The monthly salaries for December and the year-to-date earnings of the employees of Bush Consulting Company as of November 30 follow. Determine the amount of Medicare tax to be withheld from each...
Study smarter with the SolutionInn App