Saturday, December 31, 2016

Oracle Database internal interview questions

Oracle Database internal interview questions
1.How the user session established in oracle database?
2.How the user fetching the data from data file in oracle DB?
3.what are sequence of activities happening during insert/update/delete in oracle DB?
4.how the data selection happening in oracle RAC DB?
5.what happen to uncommitted transactions on UNDO in oracle DB?
6.How Database & ASM communicates when you select query run on database?
7.How oracle applies redo changes to physical standby?
8.what is the sequence of steps to generate the archive log in oracle DB?
9.what will happen internal ,when you update the oracle database?
10.what are internal changes will happen,when you do switch over in physical standby?
11.How oracle RAC provides service availability when the nodes fail-over on one of the 2 node RAC?
12.how oracle internally allocates space to system object extension?
13.what will happen when you rebuild index online?
14.what will happen ,when you do re-balance on ASM DISK?
15.what will happen when you kill the flashback process in oracle database?
16.what is the   use of OS kernal parameter in oracle database server?
17.How to allocate memory for the database in oracle database?
18.can flashback database brings dropped datafile in database?
19,what is the object sequence for export/import in oracle database?
20.what will happen when you apply CPU & PSU on oracle home?
21.what is the startup sequence of oracle RAC database?
22.what will happen when you kill the archive process in oracle database?
23.How the user session established in oracle RAC database?
24.what will happen when you try to create object on ASM instance?
24.How do you backup ASM instance?
25.what is the use of begin backup mode in oracle hot backup?
26.will RMAN hot backup put the database to begin backup mode ?

No comments:

Post a Comment