PrepAway - Latest Free Exam Questions & Answers

You develop a database application. You create four tables. Each table stores…

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 m

ust 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 UNIQUEIDENTIFIER data type along with NEWSEQU

ENTIALID()

E. Create a TIMESTAMP column.

Explanation:


Leave a Reply