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.
Briefly explain the functional differentiations between COGNOs and BO?
What is OLAP? Briefly define it.
Describe the meaning of each of the transaction stages supported by SQL Server?
Illustrates the Replication Server in Sybase?
Write down the level of Granularity of a fact table?
What do you understand by the term concurrency control in DBMS?
Explain briefly the term data mart?
States the term Volatile temporary tables.
Write down a short note on the difference between an ERD and EER.
Briefly describe the ETL procedure in data warehousing?
18,76,764
1949894 Asked
3,689
Active Tutors
1423402
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!