VIEWS: 79 PAGES: 1 POSTED ON: 8/6/2010
Oracle Database Interview questions
Exp 3 Yrs
Oracle Database Interview questions Exp 3 Yrs
-- Amdocs interview questions on 08052010 1) What Happens actually when tablespaces are kept in backup mode? 2) List out the total releases in oracle 10 version. 3) Is archiving is more or less whenever hot backup is taken & why? 4) How to find out No.of Databases running in a server? 5) How to import Zipped export dump file into database directly without unzipping? 6) What are advantages of RMAN Backup over the user managed hot/cold backup? 7) What information does the dba_registry table contains? 8) Describe the process of Cold database cloning? 9) Is recovery of database required if cold database cloning is done? 10)List out various objects in oracle database. 11)Explain Library cache? 12)How to run export/import as a background process? (&,nohup) 13)What is CPU? 14)what is the frequency at which oracle releases patches? 15)Explain the process database upgradation? 16)Explain crosscheck command? 17)Vi Editor questions .... 18)What is the purpose of crontab? 19)what is purpose of oratab? 20)what is the other file other than oratab that is used for starting if db at system startup? 21)explain sequences,synonyms? 22)how to get current value, nextval of synonym? 23)Did you implement any change requests? 24)What is Datapump? 25)What is a Directory? what is its purpose in Datapump and how is it used in datapump? 26)What is responsible for starting the job that has been cancelled during process? 27)Can datapump that is started at client side can be restared from server after abnormal exit? 28)what is the unix command to get memory used by a session? 29)what happens whenever open resetlogs is done?
Pages to are hidden for
"DBA"Please download to view full document