| |||||
|
Microsoft SQL Server FAQs Part: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 (Continued from previous part...) You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
Answer: Disable the account.
You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
Answer: Disable the account.
What is a zettabyte?
Answer: 270 You are configuring a SQL Server 2005 Reporting Services instance for email delivery of reports. What are your options for delivering email?
Answer: Local or Remote SMTP servers.
In SQL Server 2005 Analysis Services, what does the Synchronize Database Wizard allow you to do?
Answer: Synchronize all of the above.
Which of these options cannot be set in the SQL Server 2005 Integration Services Bulk Insert task?
Answer: Process all data as Unicode.
What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
Answer: 50
How many dimensions can you have in a SQL Server 2005 Analysis Services database?
Answer: 2,147,483,647
Which index rebuild operation in SQL Server 2005 can be performed online?
Answer: Both of these can be online.
On which port does the default instance of SQL Server 2005 Analysis Services listen to by default?
Answer: 2383
What does CONTINUE do in T-SQL?
Answer: This command restarts a WHILE loop.
(Continued on next part...)
Part: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
||||