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