Multiple Choice
When reviewing a table in the SQL Server GUI tools,which property should be set to "Yes" to indicate that the column is a surrogate key for which SQL Server should automatically supply values?
A) Identity
B) Surrogate
C) AutoIncrement
D) AutoNumber
E) Sequence
Correct Answer:

Verified
Correct Answer:
Verified
Q2: Locking hints included in an SQL statement
Q24: SQL Server supports three recovery models: simple,complex
Q28: SQL Statements can be submitted to SQL
Q33: SQL Server tables can be created and
Q41: When recovering a database in SQL Server,it
Q46: When you use the Microsoft SQL Server
Q58: In SQL Server,a differential backup makes a
Q66: One means of processing an SQL Server
Q89: SQL Server automatically makes determinations of whether
Q96: Discuss the Microsoft PowerShell utility.