| interview question [message #61444] |
Fri, 23 April 2004 16:34  |
Thanigai
Messages: 3
Registered: April 2002
|
Junior Member |
|
|
Can anyone give me the solution for this question.I faced this question in an interview.
"In NOARCHIVELOG mode, Suppose you have no Backups (Cold or Hot) and a
user drops a table. How can we recover the table? "
|
|
|
|
| Re: interview question [message #61446 is a reply to message #61444] |
Fri, 23 April 2004 20:47  |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
People have gone crazy. Even i am interviewing for dba positions. They are asking all kinds of questions. I suggest one thing, if people ask negative questions, politely answer the question and try to get out and forget about it. I feel that, especially for DBA interviews, people should not be looking for a set answer. There are n number of ways for solving a problem. For your problem, there is NO solution. YOU CANNOT RECOVER. PERIOD. You should say that confidently and instantly. Thats indeed a crazy question for a dba interviews. Good luck for your interviews.
Raj.
|
|
|
|
|
|
| Re: interview question [message #61457 is a reply to message #61444] |
Sun, 25 April 2004 21:03 |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
What about restoring from a export file? If you are DBA who thinks "outside of the box" - you won't answer - no way to recover.
It's a posibility and may be that's what they are looking for? How you would react to obvious questions !!!
Most of the job interviews are also to evaluate the candidate thinking...
Hope that helps,
Trifon Anguelov
DBAclick.com | DBA Forums
|
|
|
|
| Re: interview question [message #61459 is a reply to message #61457] |
Sun, 25 April 2004 21:58 |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
Yes, of course - exist yet possibility(but possible it is difficult to do). You can to stop database, save actual files, restore files from last cold backup, start database, export necessary table, stop database, copy actual files and import table to database. Method have some disadvantajes but this is common for databases in noarchivelog.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
