Which is the correct way to prevent SQL injection ...

PCES Practice Questions - OpenEDG PCES - Certified Entry-Level Security Professional With Python Exam

Question Number 5

Which is the correct way to prevent SQL injection in Python with sqlite3?

cursor.execute(f'SELECT * FROM users WHERE name="{name}"') cursor.execute('SELECT * FROM users WHERE name=?', (name,)) cursor.execute('SELECT * FROM users WHERE name=' + name) cursor.execute('SELECT * FROM users WHERE name=%s' % name)

✔ Correct Answer:

cursor.execute('SELECT * FROM users WHERE name=?', (name,))

PCES Practice Questions - OpenEDG PCES - Certified Entry-Level Security Professional With Python Exam

Question Number 5

Count Down:

Related questions :