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?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle DBA (Database Administration) Interview Questions

What database block size should I use?

0 Answers  


What is difference between logical standby database and physical standby database?

0 Answers  


Explain the wait events in statspack report 'enqueue'?

0 Answers  


Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

0 Answers  


Which function is used to find the largest integer less than or equal to aspecific value?

0 Answers  






Who is dba in dbms?

0 Answers  


How can I learn oracle dba?

0 Answers  


What does dba stand for database?

0 Answers  


What are the data management skills?

0 Answers  


When should an artificial (or derived) primary key be used?

0 Answers  


What skills should a dba have?

0 Answers  


Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)