Select from following answers:- Auto growth enabled, Simple Recovery model selected

- Auto growth enabled, Full Recovery model selected
- Auto growth disabled, Full Recovery model selected
- Auto growth enabled, Compatibility level set to SQL 7
- All Above
All intermediate operations(temporary) will be performed on tempdb. So we must consider/set the tempdb size to 'Auto Growth' and recovery Model should be 'Simple'
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator