PdfPrep.com

Which Transact-SQL statement should you run?

The Agent table of a Microsoft SQL Server database contains several million rows. The database uses the SQL_Latin1_General_Cp1_CS_AS collation.

You need to ensure that the following requirements are met:

– The values of the StateRefID column conform to the pattern of 3 uppercase letters followed by 5 numeric digits, such as “ABC12345”.

– The StateRefID values are unique within the Agent table.

– The values of all records that will be inserted or updated in the Agent table are correctly formatted.

– Exisitng rows are ignored

Which Transact-SQL statement should you run?

A . Option A
B . Option B
C . Option C
D . Option D

Answer: A

Exit mobile version