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 ?
How do you diagnose slow query performance
External tables. Can they have indexes
Duas qualidades e dois defeitos. Como foi a trajetória na área e o que eu gostava de fazer nos momentos que não estou trabalhando.
How would you work with a client that has a performance problem and it is impacting the production but you cannot see any query running long in database.
How would you start with SQL analyzing SQL performance issue
Name three traits about yourself that would be beneficial in the workplace.
What does an Ora-1555 mean?
How would you help a programmer that needed your help while you are off duty hour or at home? Will you give him your login permission?
Name three new features in SQL 2008 you like
Viewing 41 - 50 interview questions