Chapter 20. Exam 1 Answers

1. D

2. C

3. B

4. A

5. D

6. C

7. A

8. D

9. B

10. B

11. B, E, F

12. A, C

13. A

14. B

15. A, B

16. A

17. B

18. A

19. B

20. D

21. C

22. C

23. B

24. A, B, F

25. C

26. B

27. A, C

28. B

29. D

30. A, D

31. B

32. B

33. B

34. A

35. B

36. A

37. D

38. A, D

39. C

40. B, D

41. B

42. C

43. C

44. D, G

45. C, D

46. B

47. C

48. A

49. C

50. A

51. A, C, E

52. B

53. A, C, E

54. B

55. B, C, E

56. D

57. C

58. B

59. B, D

60. D

A1: Answer D is the only correct answer. Checkpoint doesn't actually write anything out to files; it causes the DBWn process to write the data from the database buffer cache out to the database files. Answer A is incorrect because LOG_CHECKPOINT_INTERVAL tells CKPT how often in terms of volume to cause a checkpoint, ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.