Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 78451 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / maruthi
create insert drop delete
sys sys sys sys-------------derived table
user user sys sys-------------volatile table
user user user sys--------------global temp table
user user user user-------------normal table
-->derived table will be created by system while executing sub queries
-->global temp table & volatile table has to be created by user by mentioning "global temporary table" , "volatile table" respectively in the syntax at the time of creating the table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between star and snowflake schemas?
What do you mean by tpt in teradata?
Describe primary index in teradata?
what is object level locking ? where do appear this type of locking ?
How to eliminate product joins in a teradata sql query?
When tpump is used instead of multiload?
What is a clique?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is logical data model?
What is a node in teradata?
Explain the teradata primary index mechanics in detail with a diagram.
How many sessions of MAX is PE capable of handling at a particular time?
How can bottlenecks be identified?
What is the difference between global temporary tables and volatile temporary tables?
Write a program to show the parser component used in teradata?
