Fundamentals of InfoSecintermediate
Rejecting every input that contains a quotation mark is always a complete defense against SQL injection.
Answer
false
Explanation
### Why this is right
The material says filtering input for quotation marks or words such as `DROP` and `INSERT` is not always possible. Such filtering is not a complete substitute for prepared statements.
### The concept
Attackers may use different inputs or exploit other weaknesses in filtering logic. Prepared statements address the underlying problem by keeping parameter values separate from SQL syntax. Validation still has value for enforcing expected formats and limits.
### The other options
- **The claim that quotation-mark rejection is complete**: It is false because input filtering can be incomplete and does not reliably enforce the boundary between code and data.
### Terms
- **SQL injection**: Altering a database command through improperly handled input.
- **Prepared statement**: A database command that separates its structure from input values.
### Remember
Validate input, but use prepared statements to separate data from commands.
Related Questions
- Explain why computer security is described as a process rather than a product. Include the roles of technology, people, and environment.(intermediate)
- Select ALL items the review identifies as possible security risks or losses.(intermediate)
- Arrange these broad security activities in a sensible cycle, beginning with identifying what needs protection.(intermediate)
- A security product can replace the continuing work of managing people, technology, and the operating environment.(intermediate)
- Which statement best captures the course review’s view of computer security?(intermediate)
Want to practice more questions like this?
Join myBenkio free and practice past questions for your Nigerian university courses with AI explanations for every answer.
Start Practicing Free