COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
By default, tempdb auto grows as needed while SQL Server is running
|
|
|
By default, master auto grows as needed while SQL Server is running
|
|
|
By default, pubs auto grows as needed while SQL Server is running
|
|
|
By default, msdb auto grows as needed while SQL Server is running
|
Detailed explanation-1: -Tempdb is one of the system databases, that is used by many activities in SQL Server to temporarily store data. Such as when a user creates a temporary table or declares a table variable, the data contained by these tables will be stored in the SQL Server tempdb database.
Detailed explanation-2: -Q 9-Which of the following is correct about stored procedures? A-A stored procedure is a group of SQL statements that form a logical unit and perform a particular task.
Detailed explanation-3: -The main purpose of the SQL Server is to store user database information to support applications. When SQL Server is installed it usually creates master, model, msdb, tempdb resource and distribution (last three depends on version of SQL Server) system database by default.
Detailed explanation-4: -Which of the following statement is true? Explanation: The SQL TRUNCATE command is used to delete all the rows from the table and free the space containing the table.