GilaMonster (1/10/2012)
JagWalia (1/10/2012)
Q: Which of the following allows for the truncation of a transaction log?A. Transaction logs are truncated when you use SQL Profiler.
B. Transaction logs are truncated when you use the following syntax: truncate table A
C. Transaction logs are truncated when you backup your database.
D. You can not backup transaction log.
None of the above. They're all wrong.
Q: Which of the following statements about unique Constraints are TRUE?
A. You can have only one unique constraint applied to a table.
B. Unique constraints can be used to establish a link between two tables.
C. You can only have one column assigned to a unique constraint.
D. If a primary key was already assigned to a table, the unique constraint would identify a special column used for indexing,
None of the above. They're all wrong.
That's what I was thinking, although I thought the transaction logs might be truncated when you backup your database and thought the statements about unique constraints were all wrong (although D might be the best answer, since SQL Server 2008 creates a unique index when you create a unique constraint...).