E-Commerce Development Introduction to E-commerce Development 4

Question 1

Which approach best prevents SQL injection attacks in an e-commerce product search feature?

Accepted Answer

Using parameterized queries or prepared statements

Answer

Parameterized queries separate SQL code from user-supplied data, preventing malicious input from altering the query structure.

Question 2

What is the purpose of an inventory reservation system during checkout?

Accepted Answer

To temporarily hold stock for a customer while they complete payment, preventing overselling

Answer

Reserving inventory during checkout ensures two customers cannot simultaneously purchase the last unit of a product.

Question 3

Which caching strategy is most appropriate for caching product prices that change frequently?

Accepted Answer

Short TTL cache with invalidation on price update events

Answer

A short TTL combined with event-driven cache invalidation keeps prices fresh while still reducing database load.

Question 4

What is cross-site scripting (XSS) in the context of an e-commerce review system?

Accepted Answer

An attack where malicious scripts are injected into user-generated content and executed in victims' browsers

Answer

XSS allows attackers to inject scripts into pages viewed by other users, potentially stealing session tokens or redirecting customers.

Question 5

Why is lazy loading important for e-commerce product image galleries?

Accepted Answer

It defers loading off-screen images until the user scrolls to them, improving initial page load time

Answer

Lazy loading reduces the initial payload of a product page by only fetching images as they enter the viewport.

E-Commerce Development Practice Test