Understanding Database Security and Management

What is the main objective of database security?

• To protect the integrity, confidentiality, and availability of data.

• To enhance the speed of data retrieval.

• To increase data redundancy and duplication.

• To allow unrestricted access to all users.

Name two common threats that can affect a database system.

• Network latency

• Backup failures

• Data encryption

• SQL injection, data breaches

Which hardware component is most vulnerable and requires RAID for fault tolerance?

• RAM

• Hard drives

• Motherboard

• CPU

What does RAID stand for?

• Redundant Array of Internal Drives

• Redundant Array of Independent Disks

• Redundant Array of Inexpensive Disks

• Redundant Array of Integrated Disks

List two main purposes of using RAID in database management.

• Data encryption for enhanced security.

• User access control for database permissions.

• Backup scheduling for regular data copies.

• 1. Data redundancy to protect against data loss. 2. Performance improvement for faster data access.

Name one method for securing a Microsoft Access database.

• Store the database on a public server

• Use a firewall to block access

• Disable all user accounts

• Set a password for the database file.

What is the difference between system security and data security in MS Access?

• System security is only about user authentication.

• System security is focused on network security measures.

• Data security includes system performance optimization.

• System security protects the database system as a whole, while data security focuses on protecting the data within the database.

What is the purpose of setting user and group permissions in a database?

• To control access to data and enhance security.

• To simplify data entry

• To improve query performance

• To increase database size

Why is TCP/IP not secure for database communication by default?

• TCP/IP is inherently secure with built-in encryption.

• TCP/IP uses strong authentication methods by default.

• TCP/IP is not secure for database communication by default due to lack of encryption and authentication.

• Database communication is always secure over any network.

Give one example of a web security technology used in DBMS.

• SQL injection prevention techniques

• Firewall configurations

• Cross-site scripting techniques

• Data encryption methods