9) Consider the following (amateur) PHP script for a login page: $username = $_GET[user]; $password = $_GET[pwd]; $= "SELECT FROM usertable WHERE username = '$username' AND password = '$password" "; $result = $db-query($sql); if ($result->num rows > 0) { /* Success */ } slas / Failure */ } a. Give a value that an attacker can enter in the field called user that will result in a successful login. Assume the attacker does not know any usernames or passwords for the site.

Create a MySQL stored procedure to validate an attempt to create a new submission. The stored procedure should have parameters for the user, the user’s password, the id of the problem, the programming language (as a varchar), and the source code. An output parameter returns the result of the submission, which is one of the strings that can return or “Bad Parameters”, which handles cases such as incorrect password for the user, or the attempt to submit using a language that the program does not support (e.g., Malbolge or Visual Basic). The stored procedure can simulate the program judging process: if there is no Bad Parameters error, then randomly choose between Accepted, Wrong Answer, Time Limit Exceeded, and Run Time Error with equal probability. The submission should gets recorded in the database.

I am having an issue creating this function with a trigger using postgreSQL (plpgsql). Could someone please help me solve this? Thank you!   CREATE OR REPLACE FUNCTION Moreno_03_bankTriggerFunction()RETURNS TRIGGERLANGUAGE PLPGSQLAS$$BEGINCREATE TRIGGER Moreno_03_bankTriggerAFTER DELETE ON accountFOR EACH ROWWHERE depositor.account_number = account.account_numberEXECUTE PROCEDURE Moreno_15_bankTriggerFunction();END;$$ Database Schema: branch ( branch_name, branch_city, assets ) customer ( ID, customer_name, customer_street, customer_city ) loan ( loan_number, branch_name, amount ) borrower ( ID, loan_number ) account ( account_number, branch_name, balance ) depositor ( ID, account_number )

q20- Choose ALL that apply.