R12.2 is the latest release in Oracle EBS area. We are presenting here the most sought over 40 question you must know about R12.2 Question 1: What is Online Patching? Answer: Online patching is a new patching mechanism that is available with R12.2 that allows the application of patches while the system is up and running, […]
Interviews questions
Oracle examination questions
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 […]
40 Adpatch question every DBA should know
Here is the compilation of 40 Adpatch question every DBA should know What are the different types of patches? Ans : oneoff, mini packs, family packs, maintanance packs, rollup pathches, colsolidated patches. What is a oneoff patch? Ans : An oneoff patch is a small patch of (20-90K size) without any pre-req’s What is a mini […]