View previous topic :: View next topic
|
Author |
Message |
rajulan
New User
Joined: 11 Jan 2008 Posts: 66 Location: India
|
|
|
|
Hi all,
I have faced the below interview questions. Please let me know the answers. I could not get the exact answers.
1. How will you recover data from BSDS?
2. Without using the unload utility and any tool, How do you unload the data from production?
3. Modify? Modify statistics and modify recovery. Difference between modify statistics and runstats. I have deleted all the entries from the SYSCOPY catalog using Modify. Now no entries are there. Now I am trying to insert 4 rows to a table of that tablespace, will it allow if not what will happen to the tablespace?
4. If we delete partition index, can we access table space?
Thanks,
Raju. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Then tell us the answers you have got, and the reason you chose those answers and the forum members will then help you. |
|
Back to top |
|
|
rajulan
New User
Joined: 11 Jan 2008 Posts: 66 Location: India
|
|
|
|
I do not have Table space,database and storage group access. Thats what i could not find the answer. otherwise i would not have posted it. I am a developer.
I have found some theoretical answer. If any moderator tell the answer. I do not need to break my head.
Thanks,
Rajulan R.C |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Here are a few manuals to which you do have access, and you will not need to break your head, just read a little bit.
you could also google on all the keywords and build yourself a starting place to learn about this stuff. |
|
Back to top |
|
|
|