Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Data And Hadoop Fundamentals Tools And Techniques For Data Driven Success

Authors: Mayank Bhushan

2nd Edition

9355516665, 978-9355516664

More Books

Students also viewed these Databases questions