OCA OCP Oracle Certification Exam Braindumps

151. The buffer cache advisory feature is off in your database. You execute the following command to enable the Buffer Cache advisory feature in the database instance: What could be the reason for this error? 
A.The database instance is in OPEN mode. 
B.The Shared Pool size is not enough to turn on the advisory feature. 
C.A large number of users are connected, thereby causing memory overhead. 
D.The Database Buffer Cache size is not enough to turn on the advisory feature. 
ANSWER:B  

152. View the Exhibit and examine the Buffer Pool Advisory section in the statspack report. What size would you recommend for the database buffer cache? 
A.32 MB 
B.24 MB 
C.16 MB 
D.40 MB 
ANSWER:A  

153. In the parameter file, you set the DB_CACHE_ADVICE parameter to READY.What is the effect of the parameter when starting the database instance? 
A.The advisory is turned off and the memory allocated for the advisory is released. 
B.The advisory is turned off and the memory is allocated for the advisory. 
C.The advisory is turned on but the Buffer Cache advisory information is not collected. 
D.The advisory is turned on and the Buffer Cache advisory information is collected in the V$DB_CACHE_ADVICE view. E.The setting would result in an ORA-04031 error because this parameter must be set by using the ALTER SYSTEM command. 
ANSWER:B  

154. Which statements are true regarding configuring multiple buffer pools in the Database Buffer Cache that is using only the standard block size? (Choose all that apply.) 
A.Both the KEEP and RECYCLE pools must be configured. 
B.The RECYCLE pool needs to be configured before dropping an object. 
C.The DEFAULT pool needs to be removed if multiple buffer pools are being configured. 
D.Either the KEEP pool or the RECYCLE pool can be configured along with the DEFAULT pool. 
ANSWER:D  

155. The KEEP pool is full. You issued a query requiring buffers from the KEEP pool. What will happen? 
A.The DEFAULT pool will be used instead. 
B.The RECYCLE pool will be used instead. 
C.The query will return an out-of-memory error. 
D.Some of the existing object blocks will be aged out of the KEEP pool. 
ANSWER:D