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.
Describe briefly the difference between a Java applet and a Java servlet?
Explain the following term: a) OLAP b) OLTP
Describe briefly the term a subquery?
Explain the term object?
Categorize the Hashing Functions based on the different methods through which the key value is found?
How does one get the correct binary value?
Explain the term DataStage and Informatica?
What demerits of ODBC does OLE DB overcome?
I have to prepare an assignment on the topic "SQL Triggers and Procedures". Please help me to complete my assignment.
Explain some of the ETL Tools?
18,76,764
1961458 Asked
3,689
Active Tutors
1447959
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!