Tell me about standby database? What are some of the configurations of it? What should we watch out for?
How do you analyze table partition using oracle provided package?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
What is oracle partial backup?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
How do you put database is archivelog mode, explain procedure?
Do you need a commit after ddl statements?
Explain the wait events in statspack report 'enqueue'?
What is the difference between raid 5 and raid 10? Which is better for oracle?
What is the difference between truncate and delete? Why is one faster?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
What are bind variables and why are they important?
Explain force logging feature in 9i.
Which rman command is used to create an exact replica of a database innew host?
What operator tests column for the absence of data?