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.
Describe the differences between an extranet and an intranet.
Give a brief differentiation between metadata and data dictionary?
Write down the some of the important security characteristics of a DBMS?
Why there is a need to create the user object?
Explain the term lattice of cuboids in brief.
What do you understand by the termed dependency graph in DBMS?
Differentiate between calloc and malloc in data structures?
What do you mean by the term stored procedure in the Teradata?
Describe briefly the measure objects?
Describe truncate commands.
18,76,764
1937893 Asked
3,689
Active Tutors
1445957
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!