Introduction to Security unit test
A test on this unit alone, marked as a percentage and a letter grade — for the test your class is actually sitting, rather than for May. Answer everything, then submit once: seeing the answer to question 3 before attempting question 4 makes the final percentage meaningless.
Shoulder surfing
Advanced persistent threat (APT)
Zero-day vulnerability
CIA triad
Separation of duties
Acceptable use policy
Pretexting
False acceptance vs false rejection
Principles social engineering exploits
Accounting (auditing)
Security policy
AI in cybersecurity, both directions
Short answer 1. Define or explain: Non-repudiation
3 ptsShort answer 2. Define or explain: Vishing and smishing
3 ptsShort answer 3. Define or explain: Availability
3 ptsShort answer 4. Define or explain: Authentication vs authorization
3 ptsFree response
6 ptsThis course has no free-response prompt tagged to this unit, so one from elsewhere in the course is used. It is still worth writing — the skill transfers.
A student-built web application lets users search a course catalog. The developer builds the database query by concatenating the user's search text directly into a SQL string, and displays the search term back on the results page exactly as typed. (a) Name the vulnerability created by the query construction and explain the mechanism by which it is exploited. (b) Explain why parameterized queries fix it, and why filtering out the word "DROP" does not. (c) Name the separate vulnerability created by echoing the search term back to the page, and describe its impact on other users. (d) Explain what defense in depth means and apply it to this application with two distinct layers.