MCQ IN COMPUTER SCIENCE & ENGINEERING

Detailed explanation-1: -Explanation: Tempdb holds all temporary tables and temporary stored procedures. 3. Which of the following holds temporary data? Explanation: Tempdb is a global resource; the temporary tables and stored procedures for all users connected to the system are stored there.

Detailed explanation-2: -Overview. The tempdb system database is a global resource that holds: Temporary user objects that are explicitly created. They include global or local temporary tables and indexes, temporary stored procedures, table variables, tables returned in table-valued functions, and cursors.

Detailed explanation-3: -TempDB. SQL Server uses the TempDB database for working storage of temporary tables and temporary stored procedures.

Detailed explanation-4: -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-5: -A temporary table is created the same way as a standard user-defined table, except the temporary table must have a pound, or hash, sign (#) preceding its name. Temporary tables are actually created on the disk in tempdb: CREATE TABLE #ProductTemp ( ProductID INT PRIMARY KEY ); A temporary table has a short life.