The tempbd plays an even more important role. This includes DBCC operations, event notifications, large object variables and parameters. It’s important to ensure that certain settings are enabled for the tempdb database. Which two are likely settings that you should configure?

 Posted by Bandi on 7/1/2014 | Category: Sql Server Interview questions | Views: 1502 | Points: 40
Select from following answers:
  1. Auto growth enabled, Simple Recovery model selected
  2. Auto growth enabled, Full Recovery model selected
  3. Auto growth disabled, Full Recovery model selected
  4. Auto growth enabled, Compatibility level set to SQL 7
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response