有哪為大俠解一下
謝謝
Q 12
What are two main OLTP requirements? (Choose two)
A. Use bind variables rather than literals in your SQL code.
B. Analyze your tables regularly to refresh optimizer statistics.
C. Create multiple small rollback segments as opposed to a few big ones.
D. Create indexes on all columns that are regularly used in query predicates.
E. Set up appropriate default storage parameter values for dynamic (implicit) space allocation.
Answer: B, C,
我認為應該是AC
Q24
What should one be your tuning goals?
A. Use as much memory as possible.
B. Use multiple copies of the code in memory.
C. Access the most possible number of blocks from disk.
D. Access the least possible number of blocks from disk.
Answer: D
我認為應該是C
Q 76
The alert log file for a database instance indicates that the checkpoints are frequently failing to complete.
Which action would be a remedy in this situation?
A. Increase the number of archiver (ARCn) processes.
B. Increasing the number of members for all log groups.
C. Increasing the number of log writer (LGWR) processes.
D. Increasing the number of database writer DBWn) processes.
Answer: D
我認為應該是B
