Database Security

What is the primary goal of database security?

• To increase database performance.

• To protect the database from unauthorized access.

• To simplify database management.

• To reduce database storage costs.

Which SQL command is used to grant privileges to a user?

• REVOKE

• GRANT

• DENY

• ALLOW

What is a view in database security?

• A physical table.

• A subset of the database presented to specific users.

• A backup of the database.

• A log of database activities.

What is the purpose of an Access Control List (ACL)?

• To encrypt data.

• To define which users have access to which objects.

• To optimize database queries.

• To monitor database performance.

Which type of authorization allows a user to modify existing tuples but not delete them?

• Read

• Insert

• Update

• Delete

What is SQL injection?

• A method to improve database performance.

• A technique to encrypt database data.

• A malicious technique to exploit vulnerabilities in SQL queries.

• A way to backup database data.

Which database security measure involves encoding data into an unreadable format?

• Authentication

• Authorization

• Encryption

• Auditing

What is the Caesar cipher?

• A complex encryption algorithm.

• A simple substitution cipher.

• A database indexing technique.

• A network security protocol.

What is the purpose of a database trigger?

• To improve query performance.

• To enforce security policies and constraints.

• To backup database data.

• To manage user accounts.

Which of the following is a common threat to database security?

• Data normalization.

• Unauthorized access.

• Database indexing.

• Data warehousing.