Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 78604 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
How many tables can you join in v2r5?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Explain teradata architecture?
how many modules are there in telecome domain?how to explain the architecture?
Explain the meaning of Amp?
Why managing the data is important?
What do you mean by teradata intellicloud?
What are the uses of bynets in multi-node systems?
What is the purpose of using case expression in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How would you load a very large file in teradata in general?
What is the use of teradata system software?
What is meant by a dispatcher?
How many codd's rules are satisfied by teradata database?
Can you fastexport a field, which is primary key by putting equality on that key?
