Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2012-06-13 : 04:22:39
|
| Here are my answers. Can you tell me if I got anything right? It asked for True/False. I added comments as well, to redeem myself a bit more...ThanksMikeSQL Server1. The default transaction isolation level in SQL Server 2005 is REPEATABLE READ.a. True . Setting NOLOCK is generally used2. A foreign key column can allow nulls.b. False. A key column needs to be unique3. In Transact-SQL, the operators UNION and UNION ALL are equivalent.c. False. UNION ALL fetches all values. UNION is more specific4. It is a not good idea to create a clustered index on a column whose values are frequently updated.d. True. This will slow performance during (OLTP) 5. It is generally advisable to use @@IDENTITY (pronounced “at at identity”) instead of SCOPE_IDENTITY() (pronounced “scope identity”) in a stored procedure to return the identity of the recently added row.e. False. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-13 : 04:32:13
|
| a is wrong.b is wrongd is probably what is wanted but is wrong. Depends on the system - it's sometimes the only choice.e again probably what they want but depends on what you want to have returned.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Test: