IT Job Interview

Database Questions

Next Page »

What Database Design Experience Do You Have?

Database design questions is always asked in job interviews for DBAs, database analysts, and database developers. To make interviewers happy, your answer must cover all phases of database design: analysis of business entities, data modeling, build ERD, logical database design, and physical database design. You may also mention the scope of the […]

Do you have any experience in data acquisition, data migration, and/or data mapping using either ETL (extract, transform, load) tools or customized data conversion solutions?

If you have used any ETL tools, explain it; otherwise say you developed customized scripting process by yourself.
“In most of data migration projects I developed customized scripting processes.  I’ve developed BCP scripts along with Windows’ batch scripting to migrate data from flat files into Sybase database.  I used Oracle’s SQL Loader a lot to load […]

What are your considerations on business and technical aspects if you are asked to analyze a data consolidation project which brings enterprise data from multiple business functions and platforms to a centralized RDBMS?

If you cannot catch up all the information like this one, you may ask for repeating the question.  Try to grab the keywords when listening.  A long question may sound complicated, but if you can catch the key aspects, it shouldn’t be too hard.  The key to answer this question is to explain the purpose […]

What methodologies, procedures, or tools have you used for planning a data integration project?

In fact, there is no widely accepted methodology for data integration.  But you can just mention the standardized systems development lifecycle methodology and explains the general steps to make data integration project going.
“I’ve worked on several data integration projects in the past.  I am not aware of any widely accepted methodologies specific for data integration.  […]

What is your database administration experience in configuring Oracle or other RDBMS for OLAP and decision support system?

Be careful about this question.  What the interviewers want to know it your knowledge and experience on OLAP DSS, but many candidates missed this point, they explained their DBA experience in general, but failed to answer what is asked.  To answer this question correctly, you should provide your knowledge about the characters of OLAP and […]

What database design and data modeling experience do you have, and what tools have you used?

Database design is one of the most common topics asked in interviews for application design/development positions.  Your answer should mix your design skills with tool experience and cover the database design lifecycle.
“I have hands-on skills and experience in database design and data modeling.  In previous jobs I have worked as the technical lead to design […]

Senior Information Systems Analyst Interview

A government agency funded a 3-year project for data integration/consolidation among several agencies. A couple of Information System Analyst positions were planned to be filled for this project. The interview process is outlined below. At start of the interview, a written description of the position and the project was given to the […]

What is Your Experience of Configuring and Using SQL Trace and Autotrace in Oracle?

This is a technical interview question to getting your insight of detailed skill sets as an Oracle DBA or developer. Your answer could tell what level of experience in database server and SQL query performance tuning. Your answer could be:
“In my past job I’ve configured SQL Trace and Autotrace in our Oracle production […]

What Database Design Tools Have You Used?

When interviews want to find out if you do have hands-on experience, they usually ask tools related questions.  If you can explain what tools you have used to do what tasks, they assume you have the skills supported by the tools.
As for database design tools, there are many.  The most popular ones are:
Rational Rose (from […]

Would you Tell Us about Your Database Development Experience?

Database development is a broad term that can mean a lot of things - it could be QSL coding, database backend programming (stored procedures, etc.), database applications, database driven systems, basically building any software systems that use data could be considered database development.  Make sure you read the job description carefully to get any clue […]

Next Page »