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
-
What is automation testing?
Quality Assurance (QA) Selenium Junior -
You are testing an on-line application. When you click the Submit button in a form, nothing happens. What will you do?
Quality Assurance (QA) Mid-level -
What is a test case?
Quality Assurance (QA) Junior -
Your thoughts on limiting the scope of testing by measuring testability?
Quality Assurance (QA) Mid-level -
How you can encourage your team (testers) for bug advocacy?
Project management Quality Assurance (QA) Mid-level