312-50V12 · Question #59
SQL injection (SQLi) attacks attempt to inject SQL syntax into web requests, which may bypass authentication and allow attackers to access and/or modify data attached to a web application. Which of…
The correct answer is C. Out-of-band SQLi. Out-of-band SQLi uses alternative channels like DNS or HTTP requests to exfiltrate data, leveraging database server features such as DNS lookups to send data to an attacker-controlled server.
Question
Options
- AIn-band SQLi
- BUnion-based SQLi
- COut-of-band SQLi
- DTime-based blind SQLi
How the community answered
(37 responses)- A3% (1)
- B3% (1)
- C86% (32)
- D8% (3)
Why each option
Out-of-band SQLi uses alternative channels like DNS or HTTP requests to exfiltrate data, leveraging database server features such as DNS lookups to send data to an attacker-controlled server.
In-band SQLi retrieves data through the same communication channel used to inject the malicious SQL, such as error messages or query results returned directly in the HTTP response, not through DNS.
Union-based SQLi is a subtype of in-band SQLi that uses the UNION SQL operator to append a second SELECT query and return its results within the same HTTP response, not via an external DNS channel.
Out-of-band SQLi relies on the database server's ability to make outbound network requests - commonly DNS or HTTP - to transmit extracted data to an external attacker-controlled destination. This technique is used when the attacker cannot retrieve data directly through the web application's response channel. Functions like Oracle's UTL_HTTP or SQL Server's xp_dirtree can trigger DNS/HTTP requests that encode and exfiltrate data out-of-band.
Time-based blind SQLi infers data by measuring the database's response delay (e.g., using SLEEP() or WAITFOR DELAY), which does not involve DNS requests or any out-of-band communication channel.
Concept tested: Out-of-band SQL injection via DNS exfiltration
Source: https://owasp.org/www-community/attacks/SQL_Injection
Topics
Community Discussion
No community discussion yet for this question.