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

Options
- A table can have only one ROWGUIDCOL column
- A ROWGUIDCOL column must not be defined by using the uniqueidentifier data type.
- NEWID function to generate a globally unique value.


CORRECT ANSWER : A table can have only one ROWGUIDCOL column

Discussion Board
SQL Server

Only one column can exist per table that is attached with ROWGUIDCOL property. One can then use $ROWGUID instead of column name in select list.

Prajakta Pandit 03-3-2017 05:44 AM

Correct answer is "A table can have only one ROWGUIDCOL column"

Correct ans is option c (NEWID function to generate a globally unique value)

A table can have multiple ROWGUIDCOL column


Vijay Garg 11-29-2016 04:33 AM

Correct answer is "A table can have only one ROWGUIDCOL column"

Please refer the following link for answer "http://careerride.com/SQL-server-ROWGUIDCOL-property.aspx"

Tanveer 12-12-2014 11:21 AM

The correct answer is wrong

How can the answer be "Both a and c" when tjat answer is on the c position?

Anders Hedlund 05-27-2014 04:59 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement