PrepAway - Latest Free Exam Questions & Answers

What option should you use to design a new database?

You have to design a new database, the tables in the database should be replicated to three offices and the database tables should have the following requirements :

+ a unique row should be identified among all the rows
+ the row should be unique among the entire organization.

What option should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
add a new column that have the identity property.

B.
add a new column that have the hierarchyid datatype.

C.
add a new column with a uniqueidentifier datatype and put the default to the getdate().

D.
add a new column with a uniqueidentifier datatype and put the default to the NEWID().

Explanation:
http://msdn.microsoft.com/en-us/library/ms190348.aspx


Leave a Reply