DBA > Interview Resource

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.

Explanation: You can disable the sa account in SQL Server 2005, which prevents its use.


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.

Explanation: You can disable the sa account in SQL Server 2005, which prevents its use.


What is a zettabyte?

Answer: 270
Explanation: A zetabyte is 270 bytes, or three orders higher than a terabyte, which is 240 bytes.


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.

Explanation: Rports can be delivered using 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.

Explanation: The Synchronize Database Wizard synchronizes data and metadata by default. You can also specify that security be synched.


Which of these options cannot be set in the SQL Server 2005 Integration Services Bulk Insert task?

Answer: Process all data as Unicode.

Explanation: You can set all of the options given except the Unicode option.


What is the maximum number of instances of Analysis Services 2005 can be installed on a server?

Answer: 50

Explanation: SQL Server 2005 supports a maximum number of 50 instances per server. For some editions of SQL Server, the number is less.


How many dimensions can you have in a SQL Server 2005 Analysis Services database?

Answer: 2,147,483,647

Explanation: The maximum number of dimensions in a SQL Server 2005 Analysis Services database is 231-1, or 2,147,483,647.


Which index rebuild operation in SQL Server 2005 can be performed online?

Answer: Both of these can be online.

Explanation: Both of these options can be performed in an online manner. The REORGANIZE option is always online and you can specify ONLINE=ON for the REBUILD option.


On which port does the default instance of SQL Server 2005 Analysis Services listen to by default?

Answer: 2383

Explanation: The default port for SQL Server 2005 Analysis Services is 2383. For SQL Server 2000, it is 2725. 2382 is the redirector for other instances of SQL Server 2005 Analysis Services.


What does CONTINUE do in T-SQL?

Answer: This command restarts a WHILE loop.

Explanation: This statement restarts a WHILE loop, ignoring any other statements after it that might be within the 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