| please HELP ME TO GIVE THE ANSWER OF THE INTERVIEW ASKED QUESTIONS [message #300734] |
Sun, 17 February 2008 23:46  |
dwaipayan
Messages: 3
Registered: February 2008
Location: DELHI
|
Junior Member |
|
|
Dear All ,
I need your help
I m trying for the job. And facing interview with MNC. But prob is that I have been asked some important question in the interview but I could not give the answer properly, and they are not satisfied with my ans thats why again again I faield in the technical round.
please help me to give the following question ans.
1. If my temporary tablespace size becomes full what will be my next step?
2. How I reduce the raw migration problem?
3. Yesterday a simple query was running well, but today its becomes very slow then what is your next step to fix the prob.
4. If some one forget to close his SQL* Plus window and went for the luch after come back he could not connect to the database, what is your next step to moniter? at first where u look at.?
5. What is the step to perform recovery from archived log file.
6. How we reduce the CPU high prob in Oracle.?
7. what is the basic point of oracle Database health checkup
8 if my Database Size = 80GB and and oracle server RAM=4GB then what should be the max size of SGA?
please help me to give the answer .plz as soon as pobbile.
Thanks in advance.
Thanks & Regards
Dwaipayan Das
|
|
|
|
|
|
| Re: please HELP ME TO GIVE THE ANSWER OF THE INTERVIEW ASKED QUESTIONS [message #300771 is a reply to message #300734] |
Mon, 18 February 2008 01:13  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
| dwaipayan wrote on Mon, 18 February 2008 12:46 | =1. If my temporary tablespace size becomes full what will be my next step?
2. How I reduce the raw migration problem?
|
Concept and Administration of Database.
| Quote: |
3. Yesterday a simple query was running well, but today its becomes very slow then what is your next step to fix the prob.
|
Ask your interviewer: "Why did you know this SQL running slowly, what's your tool/experiency/anything to show that?"
Many thing impacts to it, may be some transactions concurrently take this query, may be datafiles which the tables was on is full, may be the Net infrastructure encounters some problem, may be it - the SQL was not given to the execution rather than parse, may be the index of the table need to coalesce, may be the session which queries is the time that the other updates/insert into the same table, may be..
Supposing your interviewer gives you a brief of trace file which containts some useful information to read and rewrite this statement, but you must understand it. You must read many documents, train by many times. Are you aggree with me?
| Quote: |
4. If some one forget to close his SQL* Plus window and went for the luch after come back he could not connect to the database, what is your next step to moniter? at first where u look at.?
|
Why? Some Prod DB goes along to job_submit with finding the no-need session and kill them or take it by time out procedures, however, the situation is very rare action (it depends to kind of DBs). I've not ever seen any SQL*plus would be not connect to the DB by time out.
In your situation, it's simply by reconnect the the session by remote in his machine, take action reconnect.
| Quote: |
5. What is the step to perform recovery from archived log file.
|
Backup and Recovery chapter
| Quote: |
6. How we reduce the CPU high prob in Oracle.?
|
Identify what impacts by CPU process by running ADDM, AWR, ASH...
| Quote: |
7. what is the basic point of oracle Database health checkup
|
Performance and Tuning Chapter
| Quote: |
8 if my Database Size = 80GB and and oracle server RAM=4GB then what should be the max size of SGA?
|
What's your version of OracleDB?
What's your kind of OS?
What's your kind of machine?
[Updated on: Mon, 18 February 2008 01:21] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
