exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 2 question 23 discussion

Actual exam question from Oracle's 1z0-062
Question #: 23
Topic #: 2
[All 1z0-062 Questions]

Which three are true about the default database buffer cache? (Choose three.)

  • A. Buffers containing block images may be selected for reuse based only on a Least Recently Used (LRU) algorithm.
  • B. It is in the fixed area of the SGA.
  • C. Its buffers can contain data block images for blocks that have a corresponding image in a data file.
  • D. Buffers containing block images may be selected for reuse based only on a touch count algorithm.
  • E. It can contain block images only for database blocks whose block size is equal to the buffer size.
  • F. The keep and recycle cache memory is sub-allocated from memory allocated to the default buffer cache.
  • G. Its buffers can contain data block images for blocks that have no corresponding image in a data file.
Show Suggested Answer Hide Answer
Suggested Answer: CEG 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
dancymonkey
Highly Voted 4 years, 9 months ago
Why B? https://docs.oracle.com/database/121/CNCPT/memory.htm#CNCPT804 I think CFG
upvoted 9 times
...
hggz
Highly Voted 4 years, 9 months ago
CFG B - wrong The fixed SGA is an internal housekeeping area. For example, the fixed SGA contains: * General information about the state of the database and the instance, which the background processes need to access * Information communicated between processes, such as information about locks
upvoted 5 times
...
dfabac
Most Recent 2 years, 12 months ago
Selected Answer: CEG
Answer is CEG
upvoted 1 times
...
NorwayOracle
3 years, 1 month ago
Selected Answer: CEG
a) No. This is not the only algorithm b) No. It is not fixed. c) Yes. It can. d) No. This is not the only algorithm. e) Yes. This is the default buffer cache and block_size is relevant here. f) No. These buffers have their own size. g) Yes. New blocks may have not been written to disk yet. My answer: CEG
upvoted 2 times
...
eskias
3 years, 8 months ago
CDE the rigth ansewr is CDE consider A. not lru buffer cache uses touche count B. SGA maight or migth not be fixed C.Its buffers can contain data block images for blocks that have a corresponding image in a data file. D. Buffers containing block images may be selected for reuse based only on a touch count algorithm. reuse is base on touche count E.It can contain block images only for database blocks whose block size is equal to the buffer size. E is correct F.keep and recycle cache memory are not sub_allocated from memery allocated to the defulet buffer cache the are sub_allocated to buffer_cache(not the defolte one) sub_allocated of uffer_cache are db_cache_size is the default buffer cache db_keep_cache_size is for the KEEP buffer cache db_recycle_ cache_size is for the RECYCLE buffer cache db_nk_ cache_size
upvoted 1 times
...
Hacova
3 years, 10 months ago
CFG is correct.
upvoted 2 times
...
crucinal1
3 years, 11 months ago
So which are correct??
upvoted 1 times
...
badguy001djh
4 years, 2 months ago
CEG For F,https://docs.oracle.com/database/121/CNCPT/memory.htm#CNCPT1222 key words: Figure 14-7 Database Buffer Cache
upvoted 2 times
...
dam101
4 years, 2 months ago
ACF http://www.pafumi.net/Oracle_Architecture_and_Administration.html
upvoted 1 times
...
chibo
4 years, 7 months ago
ACG A correct
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...