Which of the following devices could potentially stop a Structured Query Language (SQL) injection attack?

A.
An intrusion prevention system (IPS)

B.
An intrusion detection system (IDS)

C.
A host-based intrusion detection system (HIDS)

D.
A host-based firewall

Explanation:

SQL injection attacks occur at the application layer. Most IPS vendors will detect at least basic sets of SQL
injection and will be able to stop them. IDS will detect, but not prevent I IIDS will be unaware of SQL injection problems. A host-based firewall, be it on the web server or the database server, will allow the connection because firewalls do not check packets at an application layer.