CREATE PROCEDURE createAccount IN inputFirst VARCHAR(40) IN inputLast VARCHAR(40
ID: 3738317 • Letter: C
Question
CREATE PROCEDURE createAccount IN inputFirst VARCHAR(40) IN inputLast VARCHAR(40) IN inputEmail VARCHAR(40) IN inputPassword VARCHAR(40) BEGIN DECLARE generatedPid INT INSERT INTO people (first, last, email) VALUES (inputFirst, inputLast, inputEmail) SELECT pid INTO generatedPid FROM people where email-inputEmail INSERT INTO password (people_id, password) VALUES (generatedPid, inputPassword) END Consider the following Stored Procedure true false - The user only needs so supply the email address to create the account true false - The stored procedure user must know which table the passwords are contained in false -The stored procedure user just supply the generatedPid value false - The insert into the people table and the insert into the password table can be done in any order trueExplanation / Answer
//if you have any query then comment below.please rate the answer
Answer:-
1) false: the user needs to supply all field data to create the account
2) True:
3) False: user have to pass generated pid and password value also
4) False: the order will be maintained in first the people table will insert then the password table, because it depends on the people table.