(Continued from previous part...)

You have just upgraded your SQL Server 2000 instance on Windows 2000 to SQL Server 2005. You are looking to begin implementing encryption capabilities and need to choose an algorthm for your data. Which of the following is not available to you?

Answer
128-bit AES

Explanation
While all of these are valid encryption algorithms on SQL Server 2005, the AES algorithms (128-bit, 192-bit, and 256-bit) are not supported on Windows XP or Windows 2000. To use these, you would need to upgrde to Windows 2003.

Which types of replication work with Oracle publishers?

Answer
Snapshot and transactional

Explanation
Oracle publishing with SQL Server works as both snapshot and transactional publication issues.

What does @@textsize return?

Answer
The current value of the TEXTSIZE option for the SET command.
Explanation
This returns the current value of the TEXTSIZE option that can be changed with the SET command. The default is 4096 bytes.

In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean?

Answer
It means the sets in this file are accent sensitive.

Explanation
The diacritics_sensitive determines if the terms in the expansion and replacement sets are accent sensitive. A value of 0 means accent insensitive and a value of 1 means accent sensitive.

What does the CREATE SERVICE statement do in SQL Server 2005?

Before a user can build reports using Report Builder in Reporting Services 2005, which one of the following steps must be done first?

Answer
Build and deploy a model

Explanation
Report Builder requires a model and that model cannot be defined using Report Builder. The advantage of using models is that users do not need to understand SQL statements to build a report (but they will still benefit from a basic understanding of the relationships between various bits of data)

(Continued on next part...)