Friday, August 23, 2013

Interview Questions

1). Tell me about yourself?
2). Explain your current working environment?
3). Explain about your backup strategies?
4). What is a latch and mutex?
5). What is cursor_sharing and what are it's parameters?
6). What is SCAN,OCR and Voting Disk
7) . What are ASM mandatory parameters?
8). What are wait classes?
9). What is row lock contention?
10). What is commit event? How to avoid it?
11). What is scattered read and sequential read?
12). How do you backup and manage your RMAN catalog database?
13). What is checkpoint? and CKPT background Process.
14). What is SMON/PMON
15). What is multi block read count?
16). What is the difference between ASH and AWR?

No comments: