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.
Define the term OCI?
Define the term Smoothing.
Illustrates the third normal form?
Define the term environment variables?
State the difference between OLTP and OLAP?
Illustrates the term Table Partitioning in detail? Answer: If you wish for to decrease page contention you do not require multiple devices. You should use multiple d
What is significance of “ * ” ?
Elucidate how can we get first 100 rows from flat file in the target?
Briefly describe the five elements of an Information Systems Architecture and their relationship to data.
How do I set a password to be null?
18,76,764
1951055 Asked
3,689
Active Tutors
1459532
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!