Tell me about standby database? What are some of the configurations of it? What should we watch out for?
404Explain 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?)
539What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
392Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
379Post New Oracle DBA (Database Administration) Questions
What is oracle log switch?
How do I become an administrator?
How should a many-to-many relationship be handled?
What is pct free/pct used/pct increase parameter in segment?
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?
How does one coalesce free space?
What is tkprof and how is it used?
How can you find out how many users are currently logged into the database?
Give one method for transferring a table from one schema to another?
What are elements of administration?
Which files are vital that should be backed up?
What are four common errors found in an alert .log?
What is oracle archived redo log?
How many types of database software are there?
How do you prevent output from coming to the screen?