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

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,))

Access more questions from this quiz

Continue to PCES Practice Questions - OpenEDG PCES - Certified Entry-Level Security Professional with Python Exam for more practice questions and the full quiz experience.

Access More Questions