Interview Questions And Answers Forum

alisiddiqui

Banned

Registered: 2015-02-23

Posts: 949

True Rules To Use ROWGUIDCOL Property:

Question:
Which of the following rules are true to use the ROWGUIDCOL property to define a globally unique identifier column?

Option A):
None
Option B):
A table can have only one ROWGUIDCOL column.
Option C):
A ROWGUIDCOL column must not be defined by using the uniqueidentifier data type.
Option D):
NEWID function to generate a globally unique value.

Correct Answer is Option B):
A table can have only one ROWGUIDCOL column.