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
