You develop a database application. You create four tables. Each table stores different categories of
products.
You create a Primary Key field on each table.
You need to ensure that the following requirements are met:
The fields must use the minimum amount of space.
The fields must be an incrementing series of values.
The values must be unique among the four tables.
What should you do?
A.
Create a ROWVERSION column.
B.
Create a SEQUENCE object that uses the INTEGER data type.
C.
Use the INTEGER data type along with IDENTITY
D.
Use the UNIQUHDENTTFIER data type along with NEWSEQUENTIALID()
E.
Create a TIMESTAMP column.
Should be B as an answer
0
0
Not B, because: The values must be unique among the four tables.
0
0
I also thought B because a sequence object is always unique, right? Each time a new value is requested (regardless the table), the sequence object returns a new unique value. Or am I wrong?
0
0
B because “The fields must be an incrementing series of values”.
0
0
The Question also states that
“The fields must use the minimum amount of space.”
This point is refering to a Sequence not a UniqueIdentifier data type.
Both Sequential Unique Identifiers and a well constructed sequence would return a unique number across all tables but the sequence in the answer returns an int while the other returns a unique identifier data type. Hence the sequence would use the minimum amount of space.
0
0
What’s more, part of that new 200Q 70-461 dumps FYI:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0
Agree that B looks correct, D does not satisfy the incrementing values criteria. A sequence does not belong to the table so therefore B would fit all 3 criteria.
0
0
Thanks Dominique De, I’m preparing to take the 70-461 soon. I find your info quite helpful. Thanks
0
0
Should be B.
0
0