1. To Enable automatic statistics Collection and automatic performance features, which of the following value must be set for the initialization Parameter STATISTICS_LEVEL
A. Either TYPICAL or ALL B. BASIC
C. NONE D. AUTO
Answer: A
2. Which of the following index type is suitable for columns with low number of distinct values.
A. B-Tree Index B. Reverse Key Index
C. Bitmap Index D. Partitioned Index
Answer: C
3. By Default, What is the frequency that Oracle follows to automatically generates AWR snapshots of the performance data ?
A. Once every 6 Hour B. Once every 24 Hour
C. Once every 4 Hour D. Once every 1 Hour
Answer: D
4. By Default, for how many days, Oracle retains the AWR performance statistics data ?
A. 1 Day B. 8 Days
C. 7 Days D. 30 Days
Answer: B
No comments:
Post a Comment