As others have stated, only an ORDER BY guarantees the sort order of the results. Therefore, there are 2 correct answers.

Hugo Kornelis (7/23/2008)

---

There's a HUGE difference between "Allows the owner of another table to use columns in the table to which they've been granted that permission" (the supposedly "correct" answer...

Simon Facer (6/4/2008)

---

Badly worded question -

How do we define "Same Result" Same result as the other statement? Same...

Just adding my voice, too. A date of birth is not a join date.

John Mitchell (10/23/2007)

---

I see. Perhaps points will be refunded in due course.

The explanation appears to explain why RANK is preferable to DENSE_RANK, but not why it's preferable to the...

Agreed - the real correct answer is RANK(). If two people are tied for 1st, the next one is technically 3rd, since 2 are ahead of him/her. ROW_NUMBER()...

The lesson to be learned today is how to spell "lessen". 

Technically, there is a Triggers folder in the Server Objects folder for the server.

Check out sp_settriggerorder in the BOL.  You can set only the first and last triggers.

Agreed.  There technically is no correct answer.

By having to supply a password, you have de facto encrypted it.  You can't use the backup without the password.

From the BOL:

BACKUP DATABASE { database_name | @database_name_var }

TO < backup_device > [ ,...n ]

[ WITH

    [ BLOCKSIZE = { blocksize | @blocksize_variable } ]

    [ [ ,...