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 that
was present in TEST_TABLESPACE at the time that TEST02.dbf was deleted?
Submitted by: AdministratorAll Archivelogs
Submitted by: Administrator
Submitted by: Administrator
Read Online Oracle DBA Job Interview Questions And Answers
Top Oracle DBA Questions
☺ | What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other? |
☺ | When using Oracle export/import what character set concerns might come up? How do you handle them? |
☺ | Explain FORCE LOGGING feature in 9i. |
☺ | Name three SQL operations that perform a SORT. |
☺ | What is the difference between RAID 5 and RAID 10? Which is better for Oracle? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |