In a dataguard environment, say the primary database is having network issues and you failover to the standby database. Now the standby has become the new primary. Now if network issues were resolved on the old primary, how do you restore it and make it a physical standby ?
There seems to be a new Oracle 11g feature called RESUME which can achieve this. I also think that it can be done using flashback. Menos
The key in these questions is to cover the fundamentals, and be ready for the back-and-forth with the interviewer.
Might be worth doing a mock interview with one of the StubHub or ex-StubHub Senior Oracle Database Administrator experts on Prepfully? They give real-world practice and guidance, which is pretty helpful.
Minimum of 4 CPU's and 32GB of ram for the db server
Minimum of 4 CPU's and 16GB of ram for an application tier
Minimum of 2 application tiers to separate the web/forms/reports tiers from the Concurrent manager Menos