Self-assessment questions

1. What is the purpose of encryption in database security?
   1. Data compression
   2. Data obfuscation
   3. Data integrity
   4. Data confidentiality
2. What does SQL injection target in a database system?
   1. Application layer vulnerabilities
   2. Data integrity
   3. Authentication system
   4. Database schema
3. What is the purpose of role-based access control (RBAC) in database security?
   1. Encrypting data at rest
   2. Detecting and preventing SQL injection
   3. Filtering network traffic
   4. Controlling access based on user roles
4. Which database construct enforces correctness?
   1. Constraints
   2. Tables
   3. Stored Procedures
   4. Views
5. What tool in DBMSs helps with dynamic queries based on user input?
   1. Prepared statements
   2. Isolation levels
   3. Select statements
   4. Update statements