MockQuestions MockQuestions

Database Administrator Interview

22 Database Administrator Interview Questions

Question 1 of 22
When did you know you wanted to be a Database Administrator?
User-Submitted Answers
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 ...
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...
If you are interviewing for any type of leadership role; ...
Most interviews start with a telephone interview. Hiring ...
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
Database information, location of data files . Redo log files.
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
Because there is no redundant, neglected data and normalized tables produce rapid, efficient joins and 5 different normalizations.
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
The role would probably be a mix of both.
Production dba.
Production dba.
First Page
Last Page

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 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 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.

About Database Administrator

September 18th, 2017

Database administrators oversee all aspects of a database. They play an integral part in the planning and development of a database. They are also responsible for its performance, security, and integrity. As part of their job, database administrators map out conceptual designs for a database and install, test and monitor its performance.
A bachelor's degree in computer science, information technology, computer systems engineering, or a related field is the minimum educational qualification required to work as a database administrator. A post-graduate qualification will increase your employment prospects and earning potential. Database administrators must have strong organizational, analytical, problem-solving and communication skills. They must also be willing to commit to continuing professional development to stay updated with the latest developments in the field.
Prospective employers will be very keen to know if you have any work experience. If you've done an internship that will hold you in good stead at your interview. Be prepared to answer questions to demonstrate that you know what this role involves and that you are a good fit for it. At Mock Questions, you will find a list of commonly asked questions. Practising the answers to these questions will help you to be better prepared for your upcoming interview.