Domain 8: Database pt 2

Question 1

Data is stored in more than one database, but those databases are logically connected (many-to-many)

Answer 1

Distributed data model

Question 2

Mixing data in a database with different classification levels and/or need-to-know requirements

Answer 2

Database contamination

Question 3

Number of rows (tuples) in a relational database

Answer 3

Cardinality

Question 4

Number of columns (attributes) in a relational database

Answer 4

Degree

Question 5

Set of allowable values that the attribute can take

Answer 5

Domain

Question 6

All database transactions have what four characteristics?

Bonus what’s the name of this model?

Answer 6

1. Atomicity
2. Consistency
3. Isolation
4. Durability

Bonus
ACID mode

Question 7

• Database transaction characteristic

- If any part of the transactions fails the entire transaction must be rolled back as if it never occurred

Answer 7

Atomicity

Question 8

• Database transaction characteristic

- All transactions must begin operating in an environment that is consistent with all of the database’s rules

Answer 8

Consistency

Question 9

• Database transaction characteristic

- Requires that transactions operate separately from each other

Answer 9

Isolation

Question 10

• Database transaction characteristic

- Once transactions are committed to the database, they must be preserved

Answer 10

Durability

Question 11

Preventative security mechanism that ensures certain info stored in the database is always correct (integrity and availability protected)

Answer 11

Concurrency

Question 12

• Failure when concurrency is not implemented

- Occurs when two different process make updates to a database unaware of each other’s activity

Answer 12

Lost updates

Question 13

• Failure when concurrency is not implemented

- Occurs when a process reads a record from a transaction that did not successfully commit

Answer 13

Dirty reads

Question 14

• Database security mechanism

- Hiding individual database fields or cells or imposing more security restrictions on them

Answer 14

Cell suppression

Question 15

• Database security mechanism

- Evaluates the big picture to make access control decisions

Answer 15

Context-dependent access control

Question 16

• Database security mechanism
• Process of splitting a single database into multiple parts, each with a unique and distinct security level or type of content

Answer 16

Database partitioning

Question 17

• Database security mechanism
• Two or more rows in the same relational database table appear to have identical primary key elements but contain different data for use at differing classification levels

Answer 17

Polyinstantiation

Question 18

• Database security mechanism

- Admins insert false or misleading data into a DBMS in order to redirect or thwart info confidentiality attacks

Answer 18

Noise and perturbation

Question 19

Database feature that allows applications to communicate with different types of databases without having to be directly programmed for interaction with each type

Answer 19

Open Database Connectivity (ODBC)

Question 20

Class of databases that use models other than the relational model to store data

Answer 20

NoSQL databases

Question 21

• NoSQL database type
• Stores info in pairs
• ________ is an index used to uniquely identify a record
• Data is stored in the ________ pair

Answer 21

Key/value stores

Question 22

• NoSQL database type

- Store data in graph format using nodes to represent objects and edges to represent relationships

Answer 22

Graph database

Question 23

• NoSQL database type

- Similar to key/value stores in that they store info using keys, but data stores is more complex

Answer 23

Document stores