Which of the following is true about SQL Server Import and Export Wizard?
A)SQL Server Native Client should be selected as the destination.
B)The user can't specify that the column names are in the first row.
C)There are no problems with modifying the default column attributes.
D)The user can specify the primary key to be set on the imported table.

Question

Quizplus · Accepted Answer

The SQL Server Import and Export Wizard typically requires a destination where the data will be imported or exported, and SQL Server Native Client is often selected as the destination for operations involving SQL Server databases. The other options are incorrect because the wizard does allow users to specify that column names are in the first row, there can be issues with modifying default column attributes, and setting a primary key directly through the wizard is not a standard feature.

Which of the Following Is True About SQL Server Import