Week 4 - Spreadsheet Storage

Question 1

What are prepared statements?

Answer 1

SQL statements that are used a lot stored as a variable

Question 2

What are two benefits of using prepared statements?

Answer 2

Increased security, as the database engine can be sure that placeholders only contain data, and need not be parsed as a full SQL statement

Increased speed, as the database engine can compile a statement once and then execute it many times