What Type Of Index Will Get Created After Executing The Above Stateme

1.	What Type Of Index Will Get Created After Executing The Above Statement?
Answer» Non-clustered INDEX. Important thing to NOTE: By default a clustered index GETS created on the PRIMARY key, UNLESS specified otherwise. Non-clustered index. Important thing to note: By default a clustered index gets created on the primary key, unless specified otherwise.

What Type Of Index Will Get Created After Executing The Above Statement?

Answer»

Non-clustered INDEX. Important thing to NOTE: By default a clustered index GETS created on the PRIMARY key, UNLESS specified otherwise.

Non-clustered index. Important thing to note: By default a clustered index gets created on the primary key, unless specified otherwise.