Saturday, January 30, 2016

Oracle India Pvt Ltd : Oracle DBA interview questions for 1 year experience -1st Round

Oracle 1st Round Interview for Oracle DBA- 1 Year Experience :

These are some of the interview questions i have faced in the first round of interview for 1 year experience. Hope these will be useful.

·         Tell me about yourself
·         Explain your project.
·         What are your daily activities
·         What is the size of your database, how do u check the size
·         How do u manage the database, what tools you are using,
·         What is task you have successfully completed and you are proud of doing it.
·         What is the most difficult issue that you have faced, and how did u solve it.
·         Difference between traditional export and import and data pump.
·         What are the techniques used to migrate a database.
·         When database writer writes
·         When log writer writes
·         What happens when commit occurs
·         What happens when tablespace is taken offline
·         What is read consistency
·         What is the difference between cumulative and differential backup
·         What are the advantages of rman
·         What is your goal
·         What do u know about oracle
·         What is oracle
·         What is the latest news in oracle website and upcoming events
·         What is the most popular product of oracle
·         How do u feel attending interview in oracle
·         What would u like to be after five years
·         Why do u want to become  dba, why not developer or others
·         What is the importance of dba.
·         What are the hidden columns in a table
·         What is function, procedure and their differences
·         How do u check the ddl of a table
·         how do u check the memory information of the linux/unix system
·         how do u check the cpu information in os level
·         how do u share your knowledge to others
·         Did u give any presentations , demos, or training in our office
·         How u take backup of control file
·         A control file is deleted, how do u recover database

·         Do u have any questions

No comments :

Post a Comment