Chapter 2 Database as Shared Storage

What is the primary purpose of a database?

• To provide statistical information

• To control the flow of information

• To manage user accounts and passwords

• To store data as a collection of files

What is the main function of a data dictionary in a database system?

• Store information about relations and attributes

• Control access to statistical databases

• Manage buffer space in main memory

• Encrypt sensitive data during transmission

Which type of storage is volatile and loses contents when power is switched off?

• Flash memory

• Magnetic disk

• Main memory

• Optical storage

What is the purpose of encryption in database security?

• To control access to statistical databases

• To store information about relations and attributes

• To manage user accounts and passwords

• To protect sensitive data during transmission

Which type of storage is used primarily for backup and archival data?

• Tape storage

• Flash memory

• Magnetic disk

• Optical storage

What is the main countermeasure to prevent loss of integrity in databases?

• Flow control

• Inference control

• Encryption

• Access control

What is the fastest and most costly form of storage?

• Flash memory

• Main memory

• Magnetic disk

• Cache

Which type of storage has the slowest access time in the storage hierarchy?

• Tertiary storage

• Main memory

• Secondary storage

• Primary storage

What is the main function of a buffer manager in a database system?

• Encrypt sensitive data during transmission

• Store information about relations and attributes

• Control access to statistical databases

• Allocate buffer space in main memory

Which command in SQL is used to grant privileges to a specific user account?

• CREATE SCHEMA

• ALTER USER

• GRANT

• CREATE TABLE