Bird
0
0

Which of the following best describes the function of an audit logging trigger in a database?

easy📝 Conceptual Q1 of 15
SQL - Triggers
Which of the following best describes the function of an audit logging trigger in a database?
APrevent unauthorized users from modifying data
BAutomatically record changes made to data for tracking purposes
COptimize query performance by caching results
DEncrypt sensitive data before storage
Step-by-Step Solution
Solution:

  1. Step 1: Understand audit logging

    Audit logging is used to keep track of data changes for accountability and troubleshooting.

  2. Step 2: Role of triggers

    Triggers can automatically capture and record these changes when data is inserted, updated, or deleted.

  3. Final Answer:

    Automatically record changes made to data for tracking purposes -> Option B

  4. Quick Check:

    Audit triggers log changes, not prevent or optimize [OK]
Quick Trick: Audit triggers capture data changes automatically [OK]
Common Mistakes:
  • Confusing audit triggers with security or encryption features
  • Assuming triggers improve query speed
  • Thinking triggers block unauthorized access

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
CASE Expressions - COALESCE and NULLIF as CASE shortcuts - Quiz 12easy CASE Expressions - CASE in ORDER BY - Quiz 12easy Database Design and Normalization - Why normalization matters - Quiz 4medium Database Design and Normalization - Database design best practices - Quiz 1easy Indexes and Query Performance - Composite index and column order - Quiz 4medium SQL Security Basics - Why prepared statements exist - Quiz 11easy Stored Procedures and Functions - CREATE PROCEDURE syntax - Quiz 6medium Stored Procedures and Functions - WHILE loops in procedures - Quiz 8hard Transactions and Data Integrity - Why transactions are needed - Quiz 1easy Transactions and Data Integrity - Savepoints within transactions - Quiz 13medium