3-23.2

Question 1

What are the four DBMS security functions?

Answer 1

Integrity, Availability, Confidentiality, Privacy

Question 2

What are some techniques used to ensure database Integrity?

Answer 2

Commit Operation (ensures consistent change), Rollback (ends a corrupt or invalid transaction), and OLTP (Online Transaction Processing Systems - Designed to optimize concurrency)

Question 3

Describe the ACID model.

Answer 3

Atomicity (transactions in entirety or not at all), Consistency (transactions correct across all instances), Isolation (transactions cant interact until completed), and Durability (transactions can’t be rolled back once committed - errors fixed by new transactions).

Question 4

What are checkpoints vs savepoints?

Answer 4

Checkpoints are snapshots in time, Savepoints are intermediate markers within a transaction that can be rolled back to.

Question 5

What is data warehousing?

Answer 5

Combines data from multiple sources into a large DB for retrieval and trend analysis.

Question 6

Name some confidentiality access controls.

Answer 6

Need to know, Least Privilege, Content, Context, Cell Supression, and Database Views.

Question 7

What is data mining?

Answer 7

The process of analyzing data with tools that look for trends, correlations, or anomalies resulting in metadata.

Question 8

What is aggregation?

Answer 8

Aggregation is when individual pieces of data are combined to create a bigger picture that may have greater sensitivity than the individual parts.

Question 9

What is inference?

Answer 9

The ability to derive information that is not explicitly available. This has become increasingly dangerous with the use of AI.