As i was appeared to TCS interview. I'm posting the questions has been asked by the interviewer and interviewer asked only the fundamental questions regarding to DBA. They are as follows....
1. How your day will start as DBA ?
2.Tell me About Oracle Architecture ?
3.What is SGA? what are its components ?
4.what are SGA_MAX_SIZE and SGA_TARGET parameters?
5.What is Library Cache and what are its components ?
6. What is online bcakup and how it is performed ?
7.What happens when e put database in begin backup mode?
8.What is dataguard and steps to confihure it ?
9. What is use of FAL_SERVER & FAL_CLIENT parameters in dataguard?
10. What is ASM & ASMM?
11.What is Locally Managed Tablespace & Dictionary Managed Tablespace?
12. What is PCTUSED & PCTFREE?
13. How do you estimate the database Size?
14. What are the differences between exp/imp &expdp/impdp ?
15.what is Conventional path & Direct path ?
16.What is the use of remap_schema parameter in expdp/impdp?
17.What is the use of direct parameter logical backup?
18.what is the use of ignore, consistent and constraints parameters in logical backup?
19.How can we estimate dump file size i expdp ?
20. What is TKPROF and how it can be used?
No comments:
Post a Comment