Point out the correct statement :
A. By default, tempdb autogrows as needed while SQL Server is running.
B. By default, master autogrows as needed while SQL Server is running.
C. By default, pubs autogrows as needed while SQL Server is running.
D. By default, msdb autogrows as needed while SQL Server is running.
Answer:A
Point out the correct statement :
A. By default, tempdb autogrows as needed while SQL Server is running. B. By default, master autogrows as needed while SQL Server is running. C. By default, pubs autogrows as needed while SQL Server is running. D. By default, msdb autogrows as needed while SQL Server is running.
Explanation:Tempdb holds all temporary tables and temporary stored procedures.