Tell me about standby database? What are some of the configurations of it? What should we watch out for?
549Explain 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?)
765What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
577Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
587Post New Oracle DBA (Database Administration) Questions
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
What os user should be used for the first part of an oracle installation (on unix)?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
Explain the various modes of normalization?
What do you mean by oracle dba?
What are types of data model?
What is difference between logical standby database and physical standby database?
What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
How do you put database is archivelog mode, explain procedure?
Is oracle dba in demand?
What is explain plan and how is it used?
What are database skills?
System tablespace cant be exported from one database and imported into another why?