Question

Which of the options below accurately reflect the difference of setting a trigger to go off...

Which of the options below accurately reflect the difference of setting a trigger to go off BEFORE as opposed to AFTER an event? Select all that apply.

Hint: You want want to read up the details of triggers on the mysql.dev website before answering.

1.

A BEFORE trigger has access to the NEW keyword but not the OLD keyword, while an AFTER trigger has access to the OLD keyword but not the NEW keyword.

2.

A BEFORE trigger can change values that are about to be updated or inserted to ensure data integrity.

3.

An AFTER trigger can be used to change data that has just been updated or inserted to ensure data integrity.

4.

If the only two triggers on a table are a BEFORE INSERT and an AFTER INSERT trigger, the BEFORE trigger always gets set off when data is inserted but the AFTER trigger only activates if the insertion actually succeeds.

5.

None of the above.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1)

BEFORE trigger has access to the NEW keyword but not the OLD keyword, while an AFTER trigger has access to the OLD keyword but not the NEW keyword.

(this is true because BEFORE trigger can access the new values before they go into the table by using the NEW keyword but not the old values and AFTER trigger can access the old values which are already there in the table using OLD keyword but not the new values)

2)

A BEFORE trigger can change values that are about to be updated or inserted to ensure data integrity

(true because Before triggers are used to update or change values before they're saved in the tables)

3)

An AFTER trigger can be used to change data that has just been updated or inserted to ensure data integrity

( true because AFTER triggers are used to update or change data that are saved in the databases)

4) if  the only two triggers on a table are a BEFORE INSERT and an AFTER INSERT trigger, the BEFORE trigger always gets set off when data is inserted but the AFTER trigger only activates if the insertion actually succeeds

(true because before trigger works before insertion but when insertion it sets off and after insertion after trigger activates)

Add a comment
Know the answer?
Add Answer to:
Which of the options below accurately reflect the difference of setting a trigger to go off...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. This trigger is from Figure 16.2 of the text. Copy and run this trigger so it is created in th...

    1. This trigger is from Figure 16.2 of the text. Copy and run this trigger so it is created in the ap database. You can run the UPDATE below to test it. Notice two things. The error message appears as a pink screen just like a syntax error would. Also, if you then query the invoices table, the UPDATE statement did not execute. The trigger prevented the erroneous UPDATE from changing the data.                 DELIMITER // CREATE TRIGGER invoices_before_update    BEFORE UPDATE...

  • 14) Which of the following statements about life income settlement options is (are) true 1. Under...

    14) Which of the following statements about life income settlement options is (are) true?I. Under a joint-and-survivor life income option, payments cease at the death of the second (last) surviving) annuitant,II. Under a life income with guaranteed period, a contingent beneficiary is guaranteed a minimum number of payments regardless of when the primary beneficiary dies.A) I onlyB) II onlyC) both I and II]D) neither I nor II15) Bruce left a question about heart disease blank on his life insurance application...

  • Overview This lab provides you the opportunity to insert and update data with the use of SQL comm...

    Overview This lab provides you the opportunity to insert and update data with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current schema. In order to start this lab, you must have successfully completed Lab # 6. In Lab # 6, you executed a script that was provided to you. This script created 7 of the FLIX2YOU tables as documented in the Entity Relationship Diagram in the FLIX2YOU problem document. The second part of lab...

  • PYTHON. Continues off another code(other code is below). I don't understand this. Someone please help! Comment...

    PYTHON. Continues off another code(other code is below). I don't understand this. Someone please help! Comment the lines please so I can understand. There are short and med files lengths for each the list of names/ids and then search id file. These are the input files: https://codeshare.io/aVQd46 https://codeshare.io/5M3XnR https://codeshare.io/2W684E https://codeshare.io/5RJwZ4 LinkedList ADT to store student records(code is below). Using LinkedList ADT instead of the Python List. You will need to use the Student ADT(code is below) Imports the Student class...

  • Case 2.2-Baskin-Robbins: Can It Bask in the Good 'Ole Days? QUESTIONS ARE AT THE BOTTOM CASE:...

    Case 2.2-Baskin-Robbins: Can It Bask in the Good 'Ole Days? QUESTIONS ARE AT THE BOTTOM CASE: BASKIN-ROBBINS Can it bask in the good ‘ole days? It was early December 2003, and Baskin-Robbins Brand Officer Ken Kimmel had just returned from lunch. To his surprise, his walk from the parking lot to the Randolph, MA headquarters building had quickly turned into a sprint. Kimmel was trying to avoid the chilly effects of a Nor’easter that was whipping most of New England...

  • The discussion: 150 -200 words. Auditing We know that computer security audits are important in business....

    The discussion: 150 -200 words. Auditing We know that computer security audits are important in business. However, let’s think about the types of audits that need to be performed and the frequency of these audits. Create a timeline that occurs during the fiscal year of audits that should occur and “who” should conduct the audits? Are they internal individuals, system administrators, internal accountants, external accountants, or others? Let me start you: (my timeline is wrong but you should use some...

  • PYTHON. Continues off another code. I don't understand this. Someone please help! Comment the lines please...

    PYTHON. Continues off another code. I don't understand this. Someone please help! Comment the lines please so I can understand LinkedList ADT: class myLinkedList:     def __init__(self):         self.__head = None         self.__tail = None         self.__size = 0     def insert(self, i, data):         if self.isEmpty():             self.__head = listNode(data)             self.__tail = self.__head         elif i <= 0:             self.__head = listNode(data, self.__head)         elif i >= self.__size:             self.__tail.setNext(listNode(data))             self.__tail = self.__tail.getNext()         else:             current = self.__getIthNode(i - 1)             current.setNext(listNode(data,...

  • Multiple Choice Multiple Choice Section 4.1 Pointers and Dynamic Memory Consider the following statements: int *p;...

    Multiple Choice Multiple Choice Section 4.1 Pointers and Dynamic Memory Consider the following statements: int *p; int i; int k; i = 42; k = i; p = &i; After these statements, which of the following statements will change the value of i to 75? A. k = 75; B. *k = 75; C. p = 75; D. *p = 75; E. Two or more of the answers will change i to 75. Consider the following statements: int i =...

  • Please Use your keyboard (Don't use handwriting) Thank you.. PHC 231 I need new and unique...

    Please Use your keyboard (Don't use handwriting) Thank you.. PHC 231 I need new and unique answers, please. (Use your own words, don't copy and paste)*** Discuss Central Line-Associated Bloodstream Infection (CLABI) "or" Ventilator-Associated Pneumonia (VAP) outbreak in long-term acute care hospital settings. Address the following in your report: Characterize the epidemiology and microbiology Describe the agent and identify the host and the environment that is favorable for the infection. Discuss how the infections spread and the types of prevention...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT