Database administration and security are crucial for managing and safeguarding organizational data. Topics include user roles, access control, backups, disaster recovery, encryption, and SQL injection prevention. Mastering these concepts ensures robust database performance, minimizes risks, and secures sensitive data. Preparing with MCQs on these topics will help you confidently handle interview questions about database management and security strategies.
1.) What is the primary role of a database administrator (DBA)?
A) Designing user interfaces
B) Managing and securing the database system
C) Writing application code
D) Developing mobile applications
2.) Which SQL command is used to grant permissions to a user?
A) ALLOW
B) PERMIT
C) GRANT
D) ASSIGN
3.) What does the REVOKE command do?
A) Removes permissions from a user
B) Deletes user accounts
C) Denies access to the database
D) Creates a backup of permissions
4.) What is the purpose of database auditing?
A) To optimize query performance
B) To track and log database activities
C) To encrypt database files
D) To design database schemas
5.) Which method helps protect against SQL injection?
A) Using stored procedures
B) Input validation
C) Parameterized queries
D) All of the above
6.) What is the purpose of database encryption?
A) To compress data
B) To improve performance
C) To secure data from unauthorized access
D) To create database backups
7.) Which SQL command is used to create a user?
A) ADD USER
B) CREATE USER
C) NEW USER
D) INSERT USER
8.) How can unauthorized database access be prevented?
A) By enforcing strong authentication methods
B) By implementing firewalls
C) By regularly updating security patches
D) All of the above
9.) What does the term “role-based access control” (RBAC) mean?
A) Assigning permissions to individual users
B) Granting access based on predefined roles
C) Encrypting sensitive data
D) Backing up the database
10.) Which SQL command is used to modify a user’s password?
A) ALTER USER
B) UPDATE PASSWORD
C) CHANGE PASSWORD
D) MODIFY PASSWORD
Related
