Q#1: Database security primarily ensures:
(A) Confidentiality, integrity, and availability of data
(B) Faster queries
(C) Normalization
(D) Backup only
Answer: (A) Confidentiality, integrity, and availability of data
Q#2: Authentication in DBMS refers to:
(A) Verifying the identity of a user
(B) Encrypting data
(C) Backup of data
(D) Normalizing tables
Answer: (A) Verifying the identity of a user
Q#3: Authorization in DBMS is:
(A) Granting privileges to access database objects
(B) Encrypting database
(C) Backing up tables
(D) Normalizing database
Answer: (A) Granting privileges to access database objects
Q#4: A common method for user authentication is:
(A) Username and password
(B) SQL query only
(C) Backup verification
(D) Index scanning
Answer: (A) Username and password
Q#5: Role-based access control (RBAC) assigns:
(A) Permissions to roles rather than individual users
(B) Permissions to every user individually
(C) Only backup privileges
(D) Only encryption keys
Answer: (A) Permissions to roles rather than individual users
Q#6: Discretionary access control (DAC) allows:
(A) Owners of objects to control access
(B) Central administrator control only
(C) Automatic encryption
(D) Backup operations only
Answer: (A) Owners of objects to control access
Q#7: Mandatory access control (MAC) is based on:
(A) Security labels assigned to users and data
(B) User preferences
(C) Query optimization
(D) Backup schedules
Answer: (A) Security labels assigned to users and data
Q#8: SQL injection attack targets:
(A) Input fields to execute malicious SQL statements
(B) Database backup
(C) Index structure
(D) Only primary keys
Answer: (A) Input fields to execute malicious SQL statements
Q#9: Encryption in DBMS provides:
(A) Confidentiality of data
(B) Faster query execution
(C) Normalization
(D) Backup efficiency
Answer: (A) Confidentiality of data
Q#10: Column-level encryption encrypts:
(A) Specific sensitive columns in a table
(B) Entire table only
(C) Only primary keys
(D) Only indexes
Answer: (A) Specific sensitive columns in a table
Q#11: Backup and recovery help in:
(A) Protecting data against loss or corruption
(B) Encrypting data
(C) Normalization
(D) Role-based access
Answer: (A) Protecting data against loss or corruption
Q#12: Database auditing involves:
(A) Recording user activities and operations on data
(B) Encrypting all queries
(C) Backup scheduling
(D) Index optimization
Answer: (A) Recording user activities and operations on data
Q#13: Views in DBMS can provide:
(A) Access control by restricting columns or rows
(B) Encryption only
(C) Backup only
(D) Indexing only
Answer: (A) Access control by restricting columns or rows
Q#14: Trigger-based security can:
(A) Enforce constraints automatically on data operations
(B) Encrypt data
(C) Backup tables
(D) Normalize tables
Answer: (A) Enforce constraints automatically on data operations
Q#15: Network security for distributed databases includes:
(A) Using SSL/TLS, firewalls, and VPNs
(B) Backup only
(C) Normalization only
(D) Index optimization only
Answer: (A) Using SSL/TLS, firewalls, and VPNs
Q#16: Multi-factor authentication (MFA) improves security by:
(A) Requiring multiple proofs of identity
(B) Encrypting tables
(C) Backup verification only
(D) Indexing only
Answer: (A) Requiring multiple proofs of identity
Q#17: Data masking is used to:
(A) Hide sensitive information from unauthorized users
(B) Backup data
(C) Normalize tables
(D) Optimize queries
Answer: (A) Hide sensitive information from unauthorized users
Q#18: Least privilege principle ensures:
(A) Users have only the access necessary to perform their tasks
(B) Users have full access
(C) Backup only
(D) Encryption only
Answer: (A) Users have only the access necessary to perform their tasks
Q#19: Threats to database security include:
(A) SQL injection, privilege abuse, malware
(B) Only indexing errors
(C) Only backup failure
(D) Normalization issues
Answer: (A) SQL injection, privilege abuse, malware
Q#20: Auditing logs should be:
(A) Protected and tamper-proof
(B) Publicly accessible
(C) Only for indexes
(D) Only for primary keys
Answer: (A) Protected and tamper-proof
Q#21: Steganography in databases is used for:
(A) Hiding data within other data
(B) Backup
(C) Encryption only
(D) Index optimization
Answer: (A) Hiding data within other data
Q#22: SQL GRANT command is used to:
(A) Give privileges to users
(B) Revoke privileges
(C) Encrypt data
(D) Backup database
Answer: (A) Give privileges to users
Q#23: SQL REVOKE command is used to:
(A) Remove previously granted privileges
(B) Grant privileges
(C) Encrypt data
(D) Backup database
Answer: (A) Remove previously granted privileges
Q#24: Database firewalls can:
(A) Monitor and block malicious queries
(B) Encrypt only
(C) Backup only
(D) Normalize tables
Answer: (A) Monitor and block malicious queries
Q#25: Data integrity ensures:
(A) Accuracy and consistency of data
(B) Faster queries
(C) Backup only
(D) Encryption only
Answer: (A) Accuracy and consistency of data
Q#26: Row-level security restricts:
(A) Access to specific rows of a table
(B) Entire database access
(C) Only indexes
(D) Only backup
Answer: (A) Access to specific rows of a table
Q#27: Threat modeling in DBMS security helps to:
(A) Identify potential security vulnerabilities
(B) Optimize queries
(C) Backup tables
(D) Normalize tables
Answer: (A) Identify potential security vulnerabilities
Q#28: Database sandboxing isolates:
(A) Test environments from production systems
(B) Encrypts all queries
(C) Backup scheduling
(D) Index optimization
Answer: (A) Test environments from production systems
Q#29: Security patches in DBMS:
(A) Fix known vulnerabilities
(B) Encrypt database
(C) Backup tables only
(D) Normalize tables only
Answer: (A) Fix known vulnerabilities
Q#30: Main goal of database security is:
(A) Protect data from unauthorized access, corruption, and loss
(B) Optimize queries
(C) Normalize tables
(D) Backup only
Answer: (A) Protect data from unauthorized access, corruption, and loss