Tell me about standby database? What are some of the configurations of it? What should we watch out for?
519Explain 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?)
723What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
527Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
546Post New Oracle DBA (Database Administration) Questions
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
What skills should a dba have?
What is difference between co-related sub query and nested sub query?
Can you remove an open file under unix?
What is da in database?
What degree do database administrators need?
What are functions of dba?
What are four common errors found in an alert .log?
How many databases should a dba manage?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
What happens when the default and temp tablespace clauses are left out from create user statements?
Which function is used to find the largest integer less than or equal to aspecific value?
What is pct free/pct used/pct increase parameter in segment?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
How do I become a database administrator?