Global Temporary tables
Write down a short note on the Global Temporary tables (GTT).
Expert
Global Temporary tables (GTT):
a) Whenever they are created, its definition goes to Data Dictionary.
b) If materialized data goes in temp space.
c) That’s why, data is active up to the session ends and definition will remain there up to its not dropped by using Drop table statement.
d) When dropped from some other session then its must is Drop table all; you can collect stats on the GTT.
Explain an unsupported method to shrink a database.
Name the main data structures used in these areas: Hierarchical data model, RDBMS and Network data model?
Write down the purpose of Fact-less Fact Table?
Explain what is meant by the term catalog and its types in the cagonos?
Illustrates the Pointer a variable in data structure or not?
Give a brief introduction of the term surrogate key?
State the different steps of data warehouse design process.
Specify some of the areas where the data warehouses are utilized in the present and in the future?
What is meant by the snow flake schema?
Give a brief introduction of the term ‘SQL Server 2005 Analysis Services’ (or SSAS)?
18,76,764
1949005 Asked
3,689
Active Tutors
1414179
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!