Answer / Dileep Singh Rajput

The easiest way to create a file on UNIX is by using the 'touch' command. For example, to create a new file named 'myfile', you can execute `touch myfile` in the terminal.

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

1 Answers  

---

What do you mean by oracle dba and what is its role?

1 Answers  

---

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

1 Answers  

---

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

1 Answers  

---

What happens when the default and temp tablespace clauses are left out from create user statements?

1 Answers  

---

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?

1 Answers  

---

What are the important tasks of common oracle dba?

1 Answers  

---

What does dba stand for database?

1 Answers  

---

What do you understand by the term 'system change number (scn)'?

1 Answers  

---

How do I become a dba?

1 Answers  

---

What is ora-1555 snapshot too old error? Explain in detail?

1 Answers  

---

What is oracle full backup?

1 Answers  

---