States the term Volatile temporary tables
States the term Volatile temporary tables.
Expert
Volatile Temporary tables (VTT) -
1. Table Definition is stored within System cache2. Data is stored within spool space.3. Because of that data and table definition both are active only up to session ends.4. No collects stats for VTT.
Write down the some of the important security characteristics of a DBMS?
Explain the Joiner transformation?
State the difference between the class and universe?
Give definition of data structure?
Can we stop and start one session in the concurrent batch?
Specify the types of dimensions?
Describe briefly the term data warehouse?
Explain how do I choose which Tables to Partition in the Sybase?
Illustrates the properties of Cursors in brief?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
18,76,764
1940401 Asked
3,689
Active Tutors
1428729
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!