MockQuestions MockQuestions
Upgrade

Database Administrator Interview
Questions

22 Questions and Answers Written by Professional Interviewers

Question 1 of 22
When did you know you wanted to be a Database Administrator?
User-Submitted Answers
1.
When I started my career with cgi.
Get More Interview Practice
Pick your topic
Ask the Interviewer
Questions you may consider asking the interviewer, about ...
Behavioral
We all have some behaviors that are typical of us and whi...
Common Interview Questions
There are some questions that employers ask at almost eve...
Leadership
If you are interviewing for any type of leadership role; ...
Telephone
Most interviews start with a telephone interview. Hiring ...
Tough
Everyone struggles with tough interview questions. Learn ...
View more topics
Question 2 of 22
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.
Question 3 of 22
What is a checkpoint?
Question 4 of 22
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.
Question 5 of 22
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.
Question 6 of 22
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.
Question 7 of 22
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.
Question 8 of 22
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.
Question 9 of 22
What about data fascinates you?
Question 10 of 22
Tell me about your education relating to database management?
Question 11 of 22
What are different modes of mounting a database with a parallel server?
Question 12 of 22
How do you implement one to one, one to many, and many to many relationships while designing tables?
Question 13 of 22
Tell me your most successful program, project, or whatever you worked on that you were most proud of at your last job?
Question 14 of 22
Why are you here?
Question 15 of 22
Explain the difference between a database manager and a data manager?
Question 16 of 22
What is a tablespace?
Question 17 of 22
What is written in the redo log file?
Question 18 of 22
What is instance recovery?
Question 19 of 22
Tell me about your undergrad education?
Question 20 of 22
What are user defined databases and when should you go for them?
Question 21 of 22
What is the difference between a primary key and a unique key?
Question 22 of 22
Why are you the best person for this position?

Related Career Interviews

Financial Analyst
A financial analyst is responsible for researching the financial health of a business and making recommendations to their clients on how they can improve their current financial strength while minimizing ...
Market Research Analyst
Market research analysts specialize in studying market conditions to assess potential sales of a product or service. They collect data on consumer needs, preferences and buying habits using various methods ...
Computer Programmer
Computer programmers are skilled in writing and testing code that enable computer applications and software programs to function. Their main area of expertise lies in converting program designs created ...
Computer Support
Computer support technicians are responsible for maintaining all computer equipment, peripherals, and terminals and ensuring that they comply with established guidelines. Their tasks include identifying ...
Computer Systems Analyst
Computer systems analysts are employed by organizations to help them operate more efficiently. As part of their job, computer systems analysts analyze the company's current computer systems, research ...
Operations Research Analysts
perations research analysts formulate and apply mathematical modeling methods to develop and interpret information that assists management with policy formulation and other managerial functions. Using ...
Software Developer
Software developers are creative minds that work behind the scenes to develop various computer programs. They are responsible for the complete development process for specific software programs, from analyzing ...
Web Developer
Web developers specialize in creating bespoke websites that meet a client's specifications. They are responsible for all aspects of website development, from coding and designing new layouts and functionalities ...
View More Careers

About Our Interview Questions

Our interview questions are created by writers, almost all of which, have a long history of recruiting and interviewing candidates. They do not necessarily have experience interviewing or working with companies, careers, or schools, in which they may write for on MockQuestions.com. We do, however, strive to match their background and expertise with the appropriate question sets found on our website.

Our careers, companies, industries, and schools may have duplicate interview questions and answers found elsewhere on our website. Specifically, our companies and our graduate school interviews. For these two, we use the industry in which we believe the company most well-represents and the graduate programs, as the basis for the interview questions and answers that generate for each company or school.

The intent of MockQuestions.com is for our users to build confidence for their job interview, by using our thousands of interview questions and answers as they practice and prepare for their interview. We believe, most of our visitors can become more likely to succeed in their job interview with hard-work and practice. We believe, the key to success is for our users to rehearse with our interview questions while using our answer examples as an idea generator for their own interview answers. We strongly want to discourage users from memorizing our answer examples. That is not the purpose of our website.