CREATE PROCEDURE createAccount IN inputFirst VARCHAR(40) IN inputLast VARCHAR(40
ID: 3738298 • 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) Consider the following Stored Procedure O true Ofalse - The user only needs so supply the email address to create the account O true Ofalse - The stored procedure user just supply the generatedPid value O true Ofalse - The insert into the people table and the insert into the password table can be done in any order true false-This procedure assumes the email field in the people table is UN?QUEExplanation / 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: the stored procedure use only generated PID for the password
3) False: the order will be maintained in first the people table will insert then the password table, because it depends on the people table.
4) True:- here the procudure assuming that the email field in people table in UNIQUE.