Tell me about standby database? What are some of the configurations of it? What should we watch out for?
289Explain 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?)
343What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
275Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
267Post New Oracle DBA (Database Administration) Questions
How would you find total size of database in os level?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
How many redo logs should you have and how should they be configured for maximum recoverability?
What happens if a tablespace clause is left off of a primary key constraint clause?
What skills do you need to be a database administrator?
What is the difference between truncate and delete? Why is one faster?
When should you increase copy latches? What parameters control copy latches?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
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 are the skills required for oracle dba?
When using oracle export/import what character set concerns might come up? How do you handle them?
What are dba privileges?
What are the roles and responsibilities of oracle dba?
How can you determine the space left in a file system?