Question 1160
A login form creates database queries by concatenating browser inputs and has no parameter binding. Which TWO complementary steps provide the most defensible remediation and its supporting assessment? Select TWO.
Explanation
Correct Answers
Inspect dynamic SQL construction, query logs, supplied payloads, database role privileges, and application input paths. This checks the relevant condition before an engineer modifies production access or detection behavior. SQL injection exploits code/data confusion; input sanitization alone is weaker than parameterization plus least privilege. The controlled response would be: Prevent SQL injection by separating untrusted field values from query structure using parameter binding and constrained database privileges. This supplies the diagnostic evidence needed for the complementary action. Situation: A login form creates database queries by concatenating browser inputs and has no parameter binding.
Prevent SQL injection by separating untrusted field values from query structure using parameter binding and constrained database privileges. This control addresses the failure mechanism and narrows the enforcement boundary. SQL injection exploits code/data confusion; input sanitization alone is weaker than parameterization plus least privilege. Confirm pre-change conditions using: Inspect dynamic SQL construction, query logs, supplied payloads, database role privileges, and application input paths. This is the implementation portion of the complementary pair. Situation: A login form creates database queries by concatenating browser inputs and has no parameter binding.
Incorrect Answers
A permitted read returns validated records while unauthorized writes and non-success responses never masquerade as completed changes. This step could matter for Authenticated security API requests but is not part of the required complementary pair for this case. The paired steps are: Prevent SQL injection by separating untrusted field values from query structure using parameter binding and constrained database privileges. and Inspect dynamic SQL construction, query logs, supplied payloads, database role privileges, and application input paths. Situation: A login form creates database queries by concatenating browser inputs and has no parameter binding.
Inspect indicator type, observed confidence, publication time, false-positive records, allowed consumers, and expiration logic. This step could matter for Threat intelligence indicator lifecycle but is not part of the required complementary pair for this case. The paired steps are: Prevent SQL injection by separating untrusted field values from query structure using parameter binding and constrained database privileges. and Inspect dynamic SQL construction, query logs, supplied payloads, database role privileges, and application input paths. Situation: A login form creates database queries by concatenating browser inputs and has no parameter binding.
Apply context-aware output encoding, anti-CSRF protections, and correct cookie controls at the relevant trust boundary. This step could matter for Web injection and request forgery but is not part of the required complementary pair for this case. The paired steps are: Prevent SQL injection by separating untrusted field values from query structure using parameter binding and constrained database privileges. and Inspect dynamic SQL construction, query logs, supplied payloads, database role privileges, and application input paths. Situation: A login form creates database queries by concatenating browser inputs and has no parameter binding.


