OCA OCP Oracle Certification Exam Braindumps

161. Which scenario would cause contention in the free list of a segment?
A.large number of inserts being performed by a single user session 
B.large number of deletes being performed by a single user session 
C.large number of inserts being performed by multiple user sessions 
D.large number of updates being performed by multiple user sessions 
ANSWER: C  

162. You noticed that the CUSTOMERS table is facing excessive row migration, thereby causing contention for free lists. What would you do to reduce row migration? (Choose all that apply.) 
A.increase the value for PCTFREE 
B.increase the value for PCTUSED 
C.decrease the value for PCTFREE 
D.reorganize the CUSTOMERS table 
E.increase the number of transaction slots 
ANSWER: AD  

163. To deal with half-empty blocks, a DBA increased the value of PCTUSED for the USERS tablespace to 80%. PCTFREE is set to 5%. What would be two effects of setting PCTUSED to a higher value? (Choose two.) 
A.improves space efficiency
B.performance of bulk updates degrades
C.performance of the queries that use indexes degrades
D.performance of the queries that involve joins degrades 
E.increases the processing cost during DELETE statements
F.reduces the processing cost incurred during UPDATE and DELETE statements for moving a block to the free list when it has fallen below the PCTUSED value 
ANSWER: AE  

164. Which two actions could you perform to reduce busy buffer waits caused on segment header blocks? (Choose two.) 
A.configure multiple I/O slaves 
B.increase the number of free lists 
C.increase the size of the redo log buffer
D.use multiple database writer (DBWn) processes 
E.use the Automatic Segment Space Management feature 
ANSWER: BE  

165. You noticed that the LGWR process is slow in freeing the redo log buffers. On querying the V$SYSTEM_EVENT view, you find that some time is spent on waiting for the log file switch (archiving needed) event. The archiving directories are not full. What should you do to minimize the waits? (Choose all that apply.) 
A.add redo log groups 
B.increase the number of database writer processes 
C.increase the number of archive log file destinations 
D.increase the value for the LOG_BUFFER initialization parameter 
E.increase the maximum number of archive processes by using the  LOG_ARCHIVE_MAX_PROCESSES parameter 
ANSWER: AE