Multiple choice technology databases

if you need to preserve some user defined datatypes in tempdb which database should you add them to

  1. sybmgmtdb

  2. sybsystemprocs

  3. model

  4. master
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The model database serves as the template for all new databases, including tempdb which is recreated each time the server restarts. Adding user-defined datatypes to model ensures they persist in tempdb across restarts.

Keep practicing — related questions