wbeaton-664441 (3/18/2010)
3 of the 4 options are correct. But, this statment can't be true:"Reducing the physical size of a log file requires shrinking the file."
You can truncate a transaction log and that will reduce the physical size of the log file, therefore shrinking is not required.
Sorry for the late reply. I'm playing catchup on old questions I skipped over. 😀
Hate to be the bearer of bad news, but truncating the transaction log, either by changing the recovery model from FULL or BULK_LOGGED to SIMPLE, or using the depreciated command BACKUP LOG <DBNAME> WITH TRUNCATE_ONLY, simply marks the space used by the committed transactions as reusable. To physically shrink the ldf file, you must use the DBCC SHRINKFILE.