- A local temporary table exists only for the duration of a connection or, if defined inside a compound statement, for the duration of the compound statement.
- Global temporary tables (created with a double “##”) are visible to all sessions.
- Global temporary tables are dropped when the session that created it ends, and all other sessions have stopped referencing it.
Do you know what is RAID and what are different types of RAID configurations?
Can you explain what are the restrictions applicable while creating views?
Explain the truncate command?
Explain the Microsoft SQL Server delete command?
What is Master Database?
What is MSDB Database?
What is TEMPDB Database?
What is Model Database?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases?
What do you know about system database?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
