You plan to create a new table that has the following requirements:
✑ Uses a GUID data type as the primary key.
✑ Uses a clustered index as the primary key.
✑ Minimizes fragmentation.
You need to recommend which option to include in the CREATE statement.
Which option should you include?
More than one answer choice may achieve the goal. Select the BEST answer.
A. NEWID
B. @@IDENTITY
C. NEWSEQUENTIALID
D. IDENTITY
You plan to create a new table that has the following requirements: ✑ Uses a GUID data type as the primary key. ✑ Uses a
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You plan to create a new table that has the following requirements: ✑ Uses a GUID data type as the primary key. ✑ Uses a
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!