Question
1. If I had a text file with the following rows where the columns are: studentId , fullName , age , email : 1~Tom Ryan~22~tryan@gxxl.com
1. If I had a text file with the following rows where the columns are: studentId, fullName, age, email:
1~Tom Ryan~22~tryan@gxxl.com 1~Tom Ryan~22~tryan@gxxl.com 3~Peter Ryan~21~pryan@gmxxl.com 4~Sally Brick~33~sbrick@gmxxl.com
TRUE OR FALSE:
A BULK INSERT can be used to import it without changing the text file
2. TRUE OR FALSE:
It is technically possible to have a name of a table column have a space in it.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Big Data And Hadoop Fundamentals Tools And Techniques For Data Driven Success
Authors: Mayank Bhushan
2nd Edition
9355516665, 978-9355516664
