1. Tell me something about yourself.
2. Project work as in what kind of environment you are working, day to day activities, previous project history, overall experience, activities in various projects.
3. How to manage space if user/developer is having space issue problems, how to troubleshoot.
4. A new user has come, what all steps you take to register him.
5. A user says his request is running very slow, what all can you do?
6. A SQL is taking too much time , waht will you to do make it run faster.
7. What is optimizer. Role of it ?
8. How comfortable are you in SQL and PL/SQL, were you a part of development team or just reporting to them.
9. Do you use EM or not and how often or is everything done through SQL prompt.
10.Are you aware of TOAD, SQL DEVELOPER.
11.What can you do if you know the execution plan of any statement?
12.How will you enable tracing? is it DBA wide or can be for a particular user.
13.How to increase the size of database.
14.What kind of role and job profile are you looking for?
15.How can you see the execution plan?
16.you project work, day-to-day activities etc.
17.What will you do if database is working slowly?
18.The database is 24x7. I don't want to enable tracing but still I want to know as to which SQL stmts are consuming maximum resources how will you see that?
19.Difference between char and varchar2. Should oracle remove its 'char' datataype?
20.if a developer tells you to create a table, how will you do it and steps you will take. You will use front-end or backend script to do this?
21.how good are you in sql? give idea about following queries- list employees drawing maximum salary from salary table, list the name of the employee drawing maximum salary.
22.how good are you in PL/SQL? what are cursors?
23.difference between views and materialized views.
24.Are you involved in designing database.? How do you manage relationships in tables?(parent-child relationships)?
2. Project work as in what kind of environment you are working, day to day activities, previous project history, overall experience, activities in various projects.
3. How to manage space if user/developer is having space issue problems, how to troubleshoot.
4. A new user has come, what all steps you take to register him.
5. A user says his request is running very slow, what all can you do?
6. A SQL is taking too much time , waht will you to do make it run faster.
7. What is optimizer. Role of it ?
8. How comfortable are you in SQL and PL/SQL, were you a part of development team or just reporting to them.
9. Do you use EM or not and how often or is everything done through SQL prompt.
10.Are you aware of TOAD, SQL DEVELOPER.
11.What can you do if you know the execution plan of any statement?
12.How will you enable tracing? is it DBA wide or can be for a particular user.
13.How to increase the size of database.
14.What kind of role and job profile are you looking for?
15.How can you see the execution plan?
16.you project work, day-to-day activities etc.
17.What will you do if database is working slowly?
18.The database is 24x7. I don't want to enable tracing but still I want to know as to which SQL stmts are consuming maximum resources how will you see that?
19.Difference between char and varchar2. Should oracle remove its 'char' datataype?
20.if a developer tells you to create a table, how will you do it and steps you will take. You will use front-end or backend script to do this?
21.how good are you in sql? give idea about following queries- list employees drawing maximum salary from salary table, list the name of the employee drawing maximum salary.
22.how good are you in PL/SQL? what are cursors?
23.difference between views and materialized views.
24.Are you involved in designing database.? How do you manage relationships in tables?(parent-child relationships)?
No comments:
Post a Comment