KING COLUMNS TO DISPLAY

#$14$

PatientDim.Name is an nvarchar$(200)$ column.

PatientDim.PrimaryMrn is an nvarchar$(150)$ column.

What would be the result of the following query?

SELECT Name $+$ PrimaryMrn

FROM PatientDim

SELECT ONE OF THE FOLLOWING $(1$ PT$)$

A$.$ The results will convert the patient's name and primary $mrn$ to a numeric value and add them together $[543432]$

B$.$ The results will include $2$ columns, $1$ for patient's name, and one for their primary MRN $[$John Doe$][12345]$

C$.$ The query will return an error

D$.$ The results will be the patient's name and MRN in $1$ column $[$John Doe$12345]$