Question 1 of 6- Subject: D Topic: Stored Procedures Time Remaining I bounis) an

Question

Question 1 of 6- Subject: D Topic: Stored Procedures Time Remaining I bounis) and minutr CREATE PROCEDURE createAccount IN inputFirst VARCHAR(40) IN inputLast VARCHAR(40) IN inputEmail VARCIIAR(40) EN inputPhissword VARCHAR(40) BEGIN DECL.ARE generatedPid INT INSERT INTO people (first, last, email) VALUES (inputFirst, inputL ast, inputEmail) SELECT pid INTO generatedPid FROM people where email-inputEmail INSERT INTO password (peoplo id, password) VALUES (generatedPid, inputPassword) END Consider the following Stored Procedure tme l The uner aly needs so upply the cnai awkress to create the accoss true false - h n Record Answer

Explanation / Answer

false - to create an account the user must supply atleast email and password, it can't create account with just email.

false - the user has to just pass the required fields, he doesn't need any knowledge on the tables that are used in the stored procedure.

true - yes the procedure is assuming the email field as UNIQUE, we can say it easily because it is used to select pid from people table which resembles it as UNIQUE and primary key as well.

false - they have to be done in an order, insert into people has to be done first then insert into password has to be done because the generatedPid has value of pid which is selected from people table with email is generated after inserting into people table is done. The generatedPid is then inserted into password table. Hence they have to be done in order.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.