MockQuestions MockQuestions
Interviews Questions by Career
Interviews Questions by Company
Interviews Questions by Topic
Get Started
Interview Coach 1:1
Gain the confidence you need by asking our professionals any interview scenario, question, or answer you are unsure about.
Let Us Review Your Answers
Our interviewing professionals will gladly review and revise any answer you send us. Allowing you to craft perfect responses for your next job interview.
Interview Questions by Topic
Interview Questions by Career
Interview Questions by Company

Database Administrator Interview
Questions

Question 1 of 22
When did you know you wanted to be a Database Administrator?
***Note: We do not have professional answers for this career***
User Answers
1.
When I started my career with cgi.
22 Database Administrator Interview Questions
Win your next job by practicing from our question bank. We have thousands of questions and answers created by interview experts.
  1. When did you know you wanted to be a Database Administrator?
  2. What information is stored in the control file?
  3. What is a checkpoint?
  4. What is normalization? Explain different levels of normalization?
  5. Are you a development DBA or a production DBA?
  6. What is the job of SMON, PMON processes?
  7. Explain the difference between explicit and implicit lock?
  8. What excites you about this position?
  9. What about data fascinates you?
  10. Tell me about your education relating to database management?
  11. What are different modes of mounting a database with a parallel server?
  12. How do you implement one to one, one to many, and many to many relationships while designing tables?
  13. Tell me your most successful program, project, or whatever you worked on that you were most proud of at your last job?
  14. Why are you here?
  15. Explain the difference between a database manager and a data manager?
  16. What is a tablespace?
  17. What is written in the redo log file?
  18. What is instance recovery?
  19. Tell me about your undergrad education?
  20. What are user defined databases and when should you go for them?
  21. What is the difference between a primary key and a unique key?
  22. Why are you the best person for this position?
Suggested
Interview Q&As
Explore expert tips and resources to be more confident in your next interview.
Behavioral
Common
Phone
Tough
Leadership
All Interview Topics
All Career Q&As
15 Database Administrator User Answer Examples
1.
When did you know you wanted to be a Database Administrator?
User-Submitted Answers
1.
When I started my career with cgi.
2.
What information is stored in the control file?
User-Submitted Answers
1.
Database information, location of data files . Redo log files.
2.
The information of data files and redolog files.
3.
What is a checkpoint?
4.
What is normalization? Explain different levels of normalization?
User-Submitted Answers
1.
Because there is no redundant, neglected data and normalized tables produce rapid, efficient joins and 5 different normalizations.
2.
Database normalization is the process of organizing the columns and tables of a relational database to minimize data redundancy. Normalization involves decomposing a table into less redundant tables without losing information; defining foreign keys in the old table referencing the primary keys of the new ones. The objective is to isolate data so that additions, deletions, and modifications of an attribute can be made in just one table and then propagated through the rest of the database using the defined foreign keys.
5.
Are you a development DBA or a production DBA?
User-Submitted Answers
1.
The role would probably be a mix of both.
2.
Production dba.
3.
Production dba.
6.
What is the job of SMON, PMON processes?
User-Submitted Answers
1.
PMON and SMON are two required background processes. PMON is the Process Monitor which is responsible for recovering processes when the user process fails. PMON does the process cleanup. SMON is the System Monitor which is responsible for recovering the system after a failure.
2.
SMON - Performs critical tasks such as instance recovery and dead transaction recovery, and maintenance tasks such as temporary space reclamation, data dictionary cleanup, and undo tablespace management. PMON - Monitors the other background processes and performs process recovery when a server or dispatcher process terminates abnormally.
7.
Explain the difference between explicit and implicit lock?
User-Submitted Answers
1.
Explicit Lock: - Lock is explicitly requested for a record or table. Implicit Lock: - Lock is implied but is not acquired.
2.
Explicit Lock is explicitly requested for a record or table. Implicit Lock is implied but is not acquired.
8.
What excites you about this position?
User-Submitted Answers
1.
The prospects of learning and developing a new understanding regarding scripts. Scripts are straightforward. You can tell a computer to do something and it will respond. You can see the progress. That is something I like.
2.
Focus on data flow. Data integration, data quality and data accuracy.
9.
What about data fascinates you?
10.
Tell me about your education relating to database management?
11.
What are different modes of mounting a database with a parallel server?
12.
How do you implement one to one, one to many, and many to many relationships while designing tables?
13.
Tell me your most successful program, project, or whatever you worked on that you were most proud of at your last job?
14.
Why are you here?
15.
Explain the difference between a database manager and a data manager?
View All 22 Database Administrator Questions and Answers
Sign up to access our library of 50,000+ Q&As,
plus coaches for one-on-one support, so you can interview more confidently.
More Interview Q&As
Explore expert tips and resources to be more confident in your next interview.
Behavioral
Common
Phone
Tough
Leadership
All Interview Topics
All Career Q&As
Disclaimer
Our interview questions and answers are created by experienced recruiters and interviewers. These questions and answers do not represent any organization, school, or company on our site. Interview questions and answer examples and any other content may be used else where on the site. We do not claim our questions will be asked in any interview you may have. Our goal is to create interview questions and answers that will best prepare you for your interview, and that means we do not want you to memorize our answers. You must create your own answers, and be prepared for any interview question in any interview.