Note AcademyNote Academy

Computer Science · May / June 2023 · Paper 2 HL · Question 10

Adapt for 2027Only the SQL INSERT part fits A3.3.3; CGI, search engine optimization, web crawlers and the deep web are no longer taught.

IBCS

As printed in the paper

The question as text

10. Below is a fragment of the code from a web page. $sql = "INSERT INTO GuestsTable (FirstName,Surname,Email,Cellphone) VALUES('Sonia','Smith','sonia@smith.com','+61231456789')"; if ($conn->query($sql) === TRUE) { echo "New record created successfully"; } else { Echo "Error.".$sql."<br>".$conn->error; }

Read automatically from the paper; the printed page above is exact.

Show the answer and mark scheme
  • 10(a)(i)[3]

  • 10(a)(ii)[3]

  • 10(b)(i)[2]

  • 10(b)(ii)[4]

  • 10(c)[3]

  • 10(d)[4]

Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.