what should you do first in order to create a spatial index on the TPXC column?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named DGTASK. There’s a table called TPV in DBx1 database. You add a column called TPXC to the TPV table. The TPXC column is of the Geography data type. There is no index in the TPV table. So what should you do first in order to create a spatial index on the TPXC column?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named DGTASK. There’s a table called TPV in DBx1 database. You add a column called TPXC to the TPV table. The TPXC column is of the Geography data type. There is no index in the TPV table. So what should you do first in order to create a spatial index on the TPXC column?

A.
You should define a primary key for the TPV table.

B.
You should create a clustered index for the TPV table.

C.
You should make sure that the TPXC column does not allow NULL values.

D.
You should copy the TPV data to a temporary table and truncate the existing TPV table.



Leave a Reply 0

Your email address will not be published. Required fields are marked *