Have you failed a job interview?
Send us your job interview questions and get correct answers.

You have an Excel sheet with 300 000 customers (columns CustomerId, Name, Phone). How would you transfer the data to the database server?

Experience Level: Medior
Tags: Quality Assurance (QA)SQL

Answer

Answers

  • Use out-of-the-box import utility
  • Write formula that will compose INSERT INTO statements, run the query
  • Use some programming language that will load the data from Excel and sends them to the database server - details how this would be done are highly appreciated.
Related Quality Assurance (QA) job interview questions

Comments

No Comments Yet.
Be the first to tell us what you think.
Software QA/Tester 1
Software QA/Tester 1

Are you learning Quality Assurance (QA) ? Try our test we designed to help you progress faster.

Test yourself

Chat

Oh, the operator is not available. Leave us your comments. We will answer all your questions as soon as possible.

Comments

LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e
LaceJaguar65
e