Midterm 1 - Database Security Quiz

What is the primary goal of database security in an enterprise?

• To increase database performance

• To protect sensitive data from unauthorized access

• To reduce database storage costs

• To simplify database management

Which of the following is NOT a core component of information systems security?

• Confidentiality

• Integrity

• Availability

• Scalability

Why is database security critical for organizations?

• It ensures compliance with regulations like GDPR

• It improves user interface design

• It reduces hardware costs

• It automates database backups

What is the primary purpose of a security architecture?

• To design user-friendly database interfaces

• To define a structured approach to protect systems and data

• To optimize database query performance

• To automate software updates

How many phases are typically involved in creating and maintaining a security architecture?

• Two

• Three

• Four

• Five

Which step in a disaster recovery plan reinstates a network after a disaster?

• Risk assessment

• Backup scheduling

• Restoration and recovery

• User training

What should a database administrator verify before installing a DBMS?

• The color scheme of the user interface

• The compatibility of the DBMS with the operating system

• The number of database users

• The database query language

Which of the following is a critical pre-installation step for database security?

• Disabling default accounts

• Increasing database storage size

• Designing database tables

• Optimizing query performance

Why should an administrator review network configurations before DBMS installation?

• To ensure fast query execution

• To secure database connections against external threats

• To reduce database licensing costs

• To simplify user access

How many main database models are commonly used in DBMSs?

• Two

• Three

• Four

• Five