What is the main purpose of access control in a database?
Correct!
Wrong!
Access control restricts user access to sensitive data based on permissions.
What does authentication verify?
Correct!
Wrong!
Authentication ensures that the user is who they claim to be.
Which of the following is an example of multi-factor authentication?
Correct!
Wrong!
MFA uses two or more credentials like a password and a fingerprint.
What is the principle of least privilege?
Correct!
Wrong!
Users should have only the minimum level of access necessary to perform their duties.
Which SQL command controls user access to database objects?
Correct!
Wrong!
GRANT allows specific privileges to be assigned to users or roles.
What does role-based access control (RBAC) rely on?
Correct!
Wrong!
RBAC assigns permissions to users based on their roles within an organization.
Loading Questions...
What is the function of database auditing?
Correct!
Wrong!
Auditing tracks database activity and changes for security and compliance.
What risk does SQL injection pose?
Correct!
Wrong!
SQL injection allows attackers to manipulate database queries and access data.
How can you prevent SQL injection attacks?
Correct!
Wrong!
Using prepared statements and parameterized queries can help secure database access.