meena1 Posted February 8, 2012 Report Share Posted February 8, 2012 Hai all,,, Here are some important DBA Interview Questions & Answers. 1.You are using hot backup without being in archivelog mode, can you recover in the event of a failure? Why or why not? Ans:- You can't use hot backup without being in archivelog mode. So no, you couldn't recover. You can't recover the data because in archivelog mode it take the backup of redo log files if it in Active mode, If it in inactive mode then it is not possible to take the backup of redolog files once the size is full, so in that case it is impossible to take hotbackup. 2.How can you determine if an index needs to be dropped and rebuilt? Ans:- Run the ANALYZE INDEX command on the index to validate its structure and then calculate the ratio of LF_BLK_LEN/LF_BLK_LEN+BR_BLK_LEN and if it isn?t near 1.0 (i.e. greater than 0.7 or so) then the index should be rebuilt. [url="http://www.coolinterview.com/type.asp?iType=666"]For more details....[/url] Link to comment Share on other sites More sharing options...
Gachibowli_Diwakar Posted February 8, 2012 Report Share Posted February 8, 2012 Link to comment Share on other sites More sharing options...
Silver_mani Posted February 8, 2012 Report Share Posted February 8, 2012 gp Link to comment Share on other sites More sharing options...
Bondu_Babu Posted February 8, 2012 Report Share Posted February 8, 2012 GP Link to comment Share on other sites More sharing options...
-1.thumb.png.613bdd33b4e8b5f69ac815bf90e62a8b.png)
Recommended Posts