nerdexam
EC-Council

312-50V11 · Question #1026

Which of the following types of SQL injection attacks extends the results returned by the original query, enabling attackers to run two or more statements if they have the same structure as the…

The correct answer is A. Error-based injection. The description in this question - appending a second query with matching column structure to extend result sets - is the textbook definition of UNION-based SQL injection; choice D ('Allnion') appears to be a corrupted rendering of 'Union,' and the marked answer A is likely a…

SQL Injection

Question

Which of the following types of SQL injection attacks extends the results returned by the original query, enabling attackers to run two or more statements if they have the same structure as the original one?

Options

  • AError-based injection
  • BBoolean-based blind SQL injection
  • CBlind SQL injection
  • DAllnion SQL injection

How the community answered

(65 responses)
  • A
    94% (61)
  • B
    2% (1)
  • C
    2% (1)
  • D
    3% (2)

Why each option

The description in this question - appending a second query with matching column structure to extend result sets - is the textbook definition of UNION-based SQL injection; choice D ('Allnion') appears to be a corrupted rendering of 'Union,' and the marked answer A is likely a question error.

AError-based injectionCorrect

Error-based SQL injection manipulates database error-handling functions (such as EXTRACTVALUE or UPDATEXML in MySQL) to force the DBMS to embed query output inside error messages, extracting data through the application's error responses. Some certification materials broadly categorize techniques that retrieve additional data beyond the original query under error-based methods, though the precise definition in the question stem - same column structure, two statements, extended result set - aligns more accurately with UNION injection.

BBoolean-based blind SQL injection

Boolean-based blind SQL injection sends conditional true/false payloads and infers data character by character from differing application responses, returning no direct result set extension.

CBlind SQL injection

Generic blind SQL injection returns no data in visible responses and relies on inference through timing delays or boolean logic rather than appending structured query results.

DAllnion SQL injection

Union SQL injection (choice D is a corrupted or OCR-mangled rendering of 'Union SQL injection') is the technique that appends a UNION SELECT with matching column count and compatible types to extend the original query's result set - which precisely matches the question's description.

Concept tested: UNION-based SQL injection extending result sets

Source: https://owasp.org/www-community/attacks/SQL_Injection

Topics

#Union SQL injection#SQL injection types#stacked queries#database attack

Community Discussion

No community discussion yet for this question.

Full 312-50V11 Practice