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
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What is end user in database?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
How can you determine the space left in a file system?
What are the main benefits of using spfile over pfile?
Which files are vital that should be backed up?
How many types of dba are there?
If you see statistics that deal with "undo" what are they really talking about?
What should a dba know?
Why are recursive relationships bad? How do you resolve them?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
What does database administrator do?
What are the important tasks of common oracle dba?
What is difference between co-related sub query and nested sub query?