Term
| You are designing a database that needs to be fault tolerant. Which one of the database types would be the best? Relational | Distributed | Transactional | Replicated |
|
Definition
|
|
Term
| A transactional database is always relational. True or False |
|
Definition
|
|
Term
| A company spent a lot of money on creating a distributed database with the goal of it being faster. It actually ended up being slower. How it that possible? |
|
Definition
| It bottle necked at the network |
|
|
Term
| What is the main reason to make a database relational. |
|
Definition
|
|
Term
| A relational database will always be smaller than a non-relational database. True or False |
|
Definition
|
|
Term
| A forign key is used in what type of database? Relational | Distributed | Transactional | Replicated |
|
Definition
|
|
Term
| A distributed database is always relational. True or False |
|
Definition
|
|
Term
| A replicated database is always relational. True or False |
|
Definition
|
|
Term
| When designing a replicated database what is the minimum number of replicas and where should they be located? |
|
Definition
| 3 with one of them off site |
|
|
Term
| Describe how a Transactional database works. |
|
Definition
| Creates a record and is able to roll back after an error occurs |
|
|
