[Solved] Which of the following is a key reason to use stored procedures for database security? — Ans: They allow hiding the underlying table structures from users | SQL

SQL - Stored Procedures and Functions

Which of the following is a key reason to use stored procedures for database security?

AThey automatically encrypt all data in the database

BThey allow hiding the underlying table structures from users

CThey prevent any user from running queries

DThey replace the need for user authentication

Step-by-Step Solution

Solution:

Step 1: Understand stored procedure security
Stored procedures can restrict direct access to tables by exposing only controlled operations.
Step 2: Compare with other options
Stored procedures do not encrypt data automatically, nor do they replace authentication or block all queries.
Final Answer:
They allow hiding the underlying table structures from users -> Option B
Quick Check:
Security by abstraction = B [OK]

Quick Trick: Stored procedures can hide table details for security [OK]

Common Mistakes:

Master "Stored Procedures and Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is a key reason to use stored procedures for database security?