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: Mid-level
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
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