Database Recovery and Security Essentials

What is a common strategy for data backup?

• 4-3-1 backup strategy

• 1-1-1 backup strategy

• 2-1-2 backup strategy

• 3-2-1 backup strategy

Explain the concept of ACID in transaction management.

• ACID is a set of properties (Atomicity, Consistency, Isolation, Durability) that ensure reliable transaction management in databases.

• ACID refers to a programming language for database queries.

• ACID is a method for data encryption in transactions.

• ACID stands for Advanced Control in Data management.

What is the purpose of access control in databases?

• To enhance database performance by optimizing queries.

• To create backups of the database regularly.

• The purpose of access control in databases is to restrict unauthorized access and ensure data security.

• To allow all users unrestricted access to data.

Name a widely used encryption method for database security.

• DES

• AES

• Blowfish

• RSA

What is the role of database auditing?

• The role of database auditing is to monitor and record database activities for security, compliance, and performance purposes.

• To enhance database performance by optimizing queries.

• To create backups of the database regularly.

• To design the database schema for better data organization.

Describe a fault tolerance approach in database systems.

• Data encryption for security

• Replication and transaction logging are key techniques for fault tolerance in database systems.

• Single point of failure management

• Regular software updates for performance

What is incremental backup in data backup strategies?

• Incremental backup saves all data regardless of changes.

• Incremental backup deletes previous backups after each run.

• Incremental backup requires a full backup every time.

• Incremental backup saves only the changes made since the last backup.

How does a transaction log help in recovery processes?

• A transaction log is used to permanently delete all data from the system.

• A transaction log prevents all transactions from being executed.

• A transaction log helps in recovery by allowing the system to replay completed transactions and roll back incomplete ones.

• A transaction log only stores user credentials for security purposes.

What are the different types of access control mechanisms?

• Identity-Based Access Control (IBAC)

• Physical Access Control (PAC)

• Network Access Control (NAC)

• Discretionary Access Control (DAC), Mandatory Access Control (MAC), Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC), Rule-Based Access Control

What is symmetric encryption and how does it work?

• Asymmetric encryption uses the same key for both encryption and decryption.

• Symmetric encryption requires multiple keys for secure communication.

• Symmetric encryption is only used for digital signatures.

• Symmetric encryption is a type of encryption where the same key is used for both encrypting and decrypting data.