Tuesday, November 13, 2012

ERICSSON INTERVIEW QUESTION FOR DBA

1.About urself
2.query for checking  which instance is up at os level.
3.how u know that db is up from sp file or pfile.
4.how query process in db...also in middle they used to ask which bkground process how they work.
5.wt is ur work at company.
6.wt kind of info stored in large pool and java pool.
7.is session take memory.
8.which will chech first in library cache syntax or symantic.
9.dbwr write or copy or both.
10.undo redo diff.
11.if db on can u delete ctrl ,redo,archive,data,...and wt will effect is db hang..terminate..or run..
12.if db down wt u used to do in cmpy ...
13.which type of db in your previous company...oltn..raid...datawarehouse.
14.wt u do in linux.
15. Wt application u used in organization ...i told sqldevlope,toad, oem,sqlplus...they told its tools ..i m asking abt application..
16.hot and cold backup
17.can u do cold backup using rman
18.many linux command....
19.setting environment in linux...
20.if instance fail then db recover how exp..using bgprocess.
21.9i,10g,11g diff in detail.
22.imp,exp,dpump, how secure 11g
23.abt previous company db,type ur role in db etc.
24.raid
25.dataware house
26.smon pmon 

No comments:

Post a Comment