Consider the table Customers(CustomerID, Name, Address, CreditLimit) You want to automatically update the credit limit of...

Transcribed Image Text:

Consider the table Customers(CustomerID, Name, Address, CreditLimit) You want to automatically update the credit limit of the customer 5 using the following update statement. UPDATE customers SET credit limit - 5000 WHERE customer_id = 5: The developer has written the following trigger to automatically update CREATE OR REPLACE TRIGGER customers_credit_policy_trg AFTER INSERT OR UPDATE ON customers FOR EACH ROW DECLARE 1 max credit customers.credit_limit TYPE: BEGIN SELECT MIN (credit_limit) - S INTO 1 max credit FROM customers WHERE credit limit > 0: IF 1_max_credit < NEW.credit_limit THEN UPDATE customers SET credit limit=1_max_credit WHERE customer_id INEW.customer_id: END 17: END: Is there anything wrong that the developer is doing? The developer is not doing anything wrong. After the trigger is fired, if the credit is greater than 5 times of the lowest non-zero credit, the system automatically assigns this credit to the customer. The update statement is incorrect. The trigger is incorrect. The developer is not doing anything wrong. After the trigger is fired, customer 5's credit limit will be increased. Consider the table Customers(CustomerID, Name, Address, CreditLimit) You want to automatically update the credit limit of the customer 5 using the following update statement. UPDATE customers SET credit limit - 5000 WHERE customer_id = 5: The developer has written the following trigger to automatically update CREATE OR REPLACE TRIGGER customers_credit_policy_trg AFTER INSERT OR UPDATE ON customers FOR EACH ROW DECLARE 1 max credit customers.credit_limit TYPE: BEGIN SELECT MIN (credit_limit) - S INTO 1 max credit FROM customers WHERE credit limit > 0: IF 1_max_credit < NEW.credit_limit THEN UPDATE customers SET credit limit=1_max_credit WHERE customer_id INEW.customer_id: END 17: END: Is there anything wrong that the developer is doing? The developer is not doing anything wrong. After the trigger is fired, if the credit is greater than 5 times of the lowest non-zero credit, the system automatically assigns this credit to the customer. The update statement is incorrect. The trigger is incorrect. The developer is not doing anything wrong. After the trigger is fired, customer 5's credit limit will be increased.

Answer rating: 100% (QA)

The detailed answer for the above question is provided below The correct answer is option 3 The tr... View the full answer