MCQ: Advanced SQL Tutorial | Temp Tables

Select the correct single-word answer.

1. What symbol is used to prefix the name of a temporary table during its creation in SQL Server?

• Hash
• Dollar
• At
• Pound
• Reveal Answer

2. Unlike a CTE, a temporary table can be referenced a ‘______’ number of times within a session.

• Single
• Fixed
• Multiple
• Zero
• Reveal Answer

3. What SQL command is used to add new rows of data into a temporary table?

• Insert
• Update
• Add