States the term Global temporary
States the term Global temporary.
Expert
Global Temporary tables (GTT) -
1. While they are created, its definition goes in Data Dictionary.2. While materialized data goes within temp space.3. That why, data is active up to the session ends, and definition will keep there upto it’s not dropped by using Drop table statement.When dropped from some other session then it must be Drop table all;4. You can collect stats at GTT.
Explain the usage of the repository connectivity?
Name the main data structures used in these areas: Hierarchical data model, RDBMS and Network data model?
Define the term data aggregation?
In JDBC driver which coding pattern is use? Describe briefly?
Illustrates the relationship between a queue and underlying array of data structure?
Explain the term precision in Data Structures? Answer: Precision considers as to the accuracy of the decimal portion of a value. It is the number of digits permitted
Write down the four purposes of the selection of a data type?
Describe briefly Recovering sessions?
What is the corresponding of Oracle/Db2 Coalesce Function within Sybase?
Write a brief note on the market basket analysis?
18,76,764
1922445 Asked
3,689
Active Tutors
1456390
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!