Tell me about standby database? What are some of the configurations of it? What should we watch out for?
396Explain 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?)
529What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
381Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
366Post New Oracle DBA (Database Administration) Questions
Can you remove an open file under unix?
What is explain plan and how is it used?
How many databases should a dba manage?
When should an artificial (or derived) primary key be used?
Which process writes data from data files to database buffer cache?
How can you find your id on a system?
What is the main function of database?
Give one method for transferring a table from one schema to another?
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?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What skills do you need to be a database administrator?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
What is the meaning of database backup?
What are dba privileges?
What does database administrator do?