• Post author:
  • Post category:Blog
  • Reading time:1 mins read
  • Post last modified:June 12, 2024

Which type of SQL query is in the SQL statement select * from users where user = “admin”;?

  • static query
  • stacked query 
  • out-of-band query 
  • parameterized query 

Explanation & Hint:

The best mitigation for SQL injection vulnerabilities is to use immutable queries, including:

  • Static queries
  • Parameterized queries
  • Stored procedures (if they do not generate dynamic SQL)

Immutable queries do not contain data that could be interpreted. Sometimes, they process the data as a single entity bound to a column without interpretation. In this case, it is an example of static queries.

For more Questions and Answers:

6.13.3 Quiz – Performing Post-Exploitation Techniques Answers Full 100%

Subscribe
Notify of
guest
0 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments