Volatile Temporary tables
Write down a short note on the Volatile Temporary tables (VTT).
Expert
Volatile Temporary tables (VTT):
a) Table Definition is stored in the System cache.
b) Data is stored in the spool space.
c) That is why, data and table definition both are active merely to session ends.
d) No collect stats for VTT.
Explain the term Vdisk and how this will communicate along with physical data storage at the time of data retrieval by AMP?
Explain how the Chasm trap is solved?
Explain the term Container and also its types?
Explain some of the data mining tools.
Specify what data sources are available?
Explain the term Account and Directory options?
Illustrates the properties of Cursors in brief?
What do you understand by the termed dependency graph in DBMS?
Describe briefly the term data warehouse?
18,76,764
1924929 Asked
3,689
Active Tutors
1454838
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!