22 Mar Practice Test Question-Database Security
Preparing for your next security certification exam? After trying your hand at this practice test question, join the FREE CertMike Study Group for the CISSP, Security+, CySA+, PenTest+, CISM+ or SSCP certification to receive new questions each week. You’ll also receive free access to my customized study strategies.
Which one of the following processes improves the consistency and longevity of a database structure?
A. Input validation
B. Query Parametrization
C. Stored Procedures
D. Normalization
Correct Answer: D
All of the activities listed here are good practices for database administration. Stored procedures, query parameterization, and input validation all protect against injection attacks. Normalization ensures that the database has a consistent structure and reduces the need to redesign the database in the future.
No Comments