What is the difference between cold backup and hot backup?
No Answer is Posted For this Question
Be the First to Post Answer
What are the skills required for oracle dba?
How can you determine if an index needs to be dropped and rebuilt?
What is dba and functionalities of dba?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
What happens if a tablespace clause is left off of a primary key constraint clause?
What are the data management skills?
Why do we need a database?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
How does one coalesce free space?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
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?
What file will give you oracle instance status information? Where is it located?