Chapter 12: Pages 535-536 Review Questions 10-11, 12, 13, 14.

10.Describe the different types of database requests and transactions.

11.Explain the need for the two-phase commit protocol. Then describe the two phases.

12.What is the objective of query optimization functions?

13.To which transparency feature are the query optimization functions related?

14.What issues should be considered when resolving data requests in a distributed data environment?

Chapter 15: 685-686 Review Questions 1-2, 7, 37, 40

1.Explain the difference between data and information. Give some examples of raw data and information.

2.Define dirty data, and identify some of its sources.

7. Using a single sentence, explain the role of databases in organizations. Then explain your answer in more detail.

37. In Oracle, what is a tablespace?

40. In Oracle, what is a database profile?

Links to answer the questions above.

https://ecpi.vitalsource.com/#/books/9781285028231/cfi/10/8!/4/2/42/6/4@0:29.5 (Chapter 12 link use for answering review questions 10-11, 12, 13, 14 above from pages 535 and 536)

https://ecpi.vitalsource.com/#/books/9781285028231/cfi/14/4!/4/2/14/12@0:46.1 (Chapter 15 link use for answering review questions 1-2, 7, 37, and 40 above from pages 685 and 686)