Can you remove an open file under unix?
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by oracle dba and what is its role?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
What is the difference between rman and a traditional hotbackup?
What are the types of schemas?
What happens if a tablespace clause is left off of a primary key constraint clause?
Why do we need a database?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
If you see statistics that deal with "undo" what are they really talking about?
What are the goals of dba?
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
Discuss row chaining, how does it happen? How do you correct it?
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.