Question: which of the following scripts will create (logic) to be executed when records have been deleted from the table CondoUnit (choose 1) a) Create procedure

which of the following scripts will create (logic) to be executed when records have been deleted from the table CondoUnit (choose 1)

a) Create procedure MyFunction on CondoUnit (logic)

b)Create procedure MyFunction on CondoUnit After Delete (logic)

c)Create trigger MyFunction on CondoUnit when Delete (logic)

d)Create trigger MyFunction on CondoUnit after delete (logic)

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 Databases Questions!

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:

Step 1: Create table audits via triggers The system must log any insertion, deletion, or updates to the following tables: Employee table (project 1) create table Employee ( empNumber char(8) not...

Q:

In this assignment, we will create an application which runs on the sample database from the Forta textbook. We will code it in the spirit of three-tier architecture. You will set up the data tier...

Q:

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

Q:

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Q:

Can someone please help me with coding this using Visual Basic? ISC/TE 285 Chapter 5 & 7 Programming Project Due Date: February 24, 2020 by 11:55 pm This program will be used to track the seats...

Q:

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

Q:

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Q:

Project 3 In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop database. We need to transition the logical...

Q:

Continuing with the employee database you created for Group Project #2, youll need to address the concerns raised within this document by your supervisor, Matt Kozi. If you are working with a new...

Q:

A bird travels from island A to island B flying in a straight horizontal line. The distance between the two islands is 1 km. When there is no wind, the bird usually spends 2.50 kcal of energy for...

Q:

Suppose that f is defined on the real line and satisfies 3 f(x) 3+ (x - 1). There is one value a where we may use the Squeeze Theorem to show that the limit lim f(x) = L exists and has the value L....

Q:

Question 5 1 pts In a simple CAPM world which of the following statements is ( are ) correct? All investors will choose to hold the market portfolio, which includes all risky wots in the world. II ....

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

If the tax rate is 40 percent, compute the beforetax real interest rate and the after-tax real interest rate in each of the following cases. a. The nominal interest rate is 10 percent and the...

Q:

Assume that the reserve requirement is 20%. Also assume that banks do not hold excess reserves and there is no cash held by the public. The Federal Reserve decides that it wants to expand the money...

Q:

It is often suggested that the Federal Reserve try to achieve zero inflation. If we assume that velocity is constant, does this zero-inflation goal require that the rate of money growth equal zero?...