Data Definition Wizard identify Fields mhe wizard has tried toidentify al the se

Question

Data Definition Wizard identify Fields mhe wizard has tried toidentify al the sedan your data se. Youan delete, aeate Select Patom move any field separators to appropriately set the colums Select Data To aREATE a feld separator, dick at the desred location To MovE a field separator, dd an aine and drag it. Define FeidsRecords Edit Field Properties Finish 646291818 1/04/201 601IN 5220452 436 646291818 01/04/201 3093442 14 1528.71 646291818 1/04/201 5 3030230 26462918185 01/04/201 9050476 646291 B18 1/04/201 9001001 33 646291818 1/04/201 1011904 36 26462918185 01/04/201 101551 508.96 64 629181 p 04/201 6462 9181 1/04/201 1712 646291818 1/04/201 92.4 64629101B 1/06/201 26462918185 1/04/201 8093874 110 13 646291818 1/04/201 119 14 646291818 2/04/201 45 Let v ariables Web Windows MacBook Air

Explanation / Answer

In the above given table, there are 10 fields.

What you can see in the above table, are some null or blank fields. if we count those blank fields as well, the number of columns becomes 12, which is not an option. So we come to a conclusion that those null columns are nothing.

Thus, the 10 fields in the above table contains the following type of data:

field 1: contains 11 digits of numeric data

field 2: contains varchar data of size 10, which looks like a date

field 3: integer of size 2, i think this feild holds some kind of serial number

field 4: varchar data

field 5: integer data again

field 6: integer data

field 7: float data

field 8: float data

field 9: float data

field 10: this field looks to be hidden by the window, as seen by the horizontal scroll bar.

Hope this helps...

BEST WISHES!

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.