Oracle performance tuning examination part 3 Question 1 Which two are valid modes for a process requesting latches? A. Scheduled B. Deferred C. Immediate D. Pre- Emptive E. Willing- to- Wait Solution) C, E. Question 2 Which three SQL statements can use the NOLOGGING mode to reduce redo operations? A. UPDATE B. CREATE INDEX C. ALTER INDEX …REBUILD D. Conventional Path INSERT E. CREATE TABLE … Continue reading Oracle performance tuning examination part 3 »