Interview questions for Oracle DBA

Which type of Oracle DBA questions are generally asked in the Interview???

Here I am sharing some of the Oracle DBA questions which are generally asked in the Interview

Rate yourself in Oracle database administration.
Rate yourself in Oracle performance tuning.
Rate yourself in Oracle backup recovery.
Explain your biggest disaster recovery of Oracle database in your career?
What are your daily activities as DBA at present?
Did you use online or off-line backups? Why?
If you have to advise a backup strategy for a new application, how would you approach it and what questions will you ask?
If a customer calls you about a hanging database session, what will you do to resolve it?
How many control files and redo logs should a database have? atleast
What will be the disaster recovery strategy without using Data Guard and Backups ?
What is hard & Soft Parsing. how we avoid Hard parsing for a query, means what parameter should use in query to avoid it.
How to create two dblinks ina database where global_name paramter is set to TRUE?
What are the steps for becoming a DBA? Whih are the books & websites that will helpful for me for gain more knowledge in database.

__________________
Answered By StudyChaCha Member