Matematica para programacao de computador, Resumos de Matérias técnicas

Baixe Matematica para programacao de computador e outras Resumos em PDF para Matérias técnicas, somente na Docsity!

Two Minute SQL

Server Stumpers

Test your SQL Server knowledge!

High Performance SQL Server

Two Minute SQL Server

Stumpers

Vol. 5

Brought to you by the staff at SQLServerCentral.com

And

Red Gate Software

Thanks to the following for contributing questions:

Chad Crawford Sriram Yaddanapudi Vincent Rainardi Jacob Sebastian Brandie Tarvin Ramesh Saive Carlos Iglesias Martinez Surendra Holambe Prashant Pandey Reza Nassabeh Gogula Aryalingam Kenneth Fisher and VM and Abhijit

Foreword

Why Two Minute Questions?

When I was a kid, I used to order these Scholastic mysteries from the school. They were these little, thin paperbacks, like 50-60 or so pages, much like what you’re holding now, that had a short mystery written on a page. Usually they consisted of some story and then a question. How did someone get killed? Where did the murder weapon go? Something like that. You then turned the page to find out the answer after thinking about it for a minute.

We now bring you Volume 5 of our SQL Server Stumpers and, once again, that’s what we’re trying to build here, but instead of some mystery, it’s a quiz type format of SQL Server questions and answers, culled from the annals of our very popular Question of the Day on the SQLServerCentral.com website. These are a collection of questions from the past that we put together to help you study for an exam, learn a bit more about SQL Server, pass the time, etc. But they’re mostly collected for…

The INTERVIEW.

You’re looking for a new job; you’ve posted your resume, worked on cover letters, and finally landed an interview. Now you want to be sure that you look your best; that you can answer what’s thrown at you.

I can’t promise that anyone will ask you any of these questions, but you never know. Maybe some managers that are interviewing will grab a copy of the

Question 1

You want to implement a fast parse of some data in SQL Server 2005 Integration Services, but are concerned it is not supported. Which of the following formats are not supported?

Choose one of the answers below:

1. Leading plus signs, like "+7". 2. Leading minus signs, like "-12". 3. Trailing spaces, like "10 ". 4. Hexadecimal numbers, like "4A".

Question 2

In SQL Server 2005 Integration Services, what happens to the checkpoint file each time the package is executed from the beginning?

Choose one of the answers below:

1. A new checkpoint file is created. 2. If a file exists, data is appended to it, otherwise a new one is created. 3. A new file is created and the old one is renamed to [packagename].1, like log files.

Answer:

1. A new checkpoint file is created.

Explanation:

The checkpoint file is recreated anew on each package execution.

Ref: Using Checkpoints in Packages - http://msdn2.microsoft.com/en-us/library/ms 140226.aspx

Answer:

4. The total number of writes (disk only) for the instance since last restart.

Explanation:

The @@total_read function returns the number of disk writes since the SQL Server instance was last restarted.

Ref: @@total_read - http://msdn2.microsoft.com/en-us/library/ms 187917.aspx

Question 4

When you implement a group of Federated Database Servers in SQL Server 2005, how are you gaining scale?

Choose one of the answers below:

1. Scale-Up 2. Scale-Out 3. Scale-Around 4. Scale-Beyond

Question 5

How many network cards do you need per cluster node in a server cluster? Sponsored by Apress and to Allan Hirt, author of Pro SQL Server 2005 High Availability

Choose one of the answers below:

1. One 2. Two 3. Three 4. Four

Answer:

2. Two

Explanation:

A server cluster requires at least two physically separate network cards.

Ref: Page 121 of Pro SQL Server 2005 High Availability Windows Server 2003 Clustering - http://www.microsoft.com/windowsserver2003/te chinfo/overview/bdmtdm/default.mspx

Answer:

4. 2000

Explanation:

This was the first version in which log shipping was built into the product.

Ref: Page 363 of Pro SQL Server 2005 High Availability Log Shipping - http://msdn2.microsoft.com/en- us/library/aa213785(SQL.80).aspx

Question 7

What is the registry key to check to see if a server needs a reboot? Sponsored by Apress and to Allan Hirt, author of Pro SQL Server 2005 High Availability

Choose one of the answers below:

1. HKEY_LOCAL_MACHINE\SYSTEM\Cu rrentControlSet\Control\Session Manager\AppPatches\NeedsReboot 2. HKEY_LOCAL_MACHINE\SYSTEM\Cu rrentControlSet\Control\Session Manager\Power\PendingFileRenameOperati ons 3. HKEY_LOCAL_MACHINE\SYSTEM\Cu rrentControlSet\Control\Session Manager\PendingFileRenameOperations 4. HKEY_LOCAL_MACHINE\SYSTEM\Cu rrentControlSet\Control\Session Manager\Reboot