Aged Yak Warrior
Posted - 06/13/2012 : 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...
1. The default transaction isolation level in SQL Server 2005 is REPEATABLE READ.
a. True . Setting NOLOCK is generally used
2. A foreign key column can allow nulls.
b. False. A key column needs to be unique
3. In Transact-SQL, the operators UNION and UNION ALL are equivalent.
c. False. UNION ALL fetches all values. UNION is more specific
4. 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.