Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 79323 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
What is partitioned primary index (ppi)?
What is smp and mpp platforms?
What are the different functions included in the server software?
Explain the most common data types used in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Different phases of multiload?
Difference between star and snowflake schemas?
What are the design features involved in teradata?
Describe primary index in teradata?
Highlight the need for Performance Tuning.
What are the steps involved after the disk manager passes the request?
What is dimensional modeling?
How can bottlenecks be identified?
Explain the term 'row' related to relational database management system?
Explain teradata utilities?
