Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 78543 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
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the enhanced features in teradata v2r5 and v2r6?
How to select first n records in teradata?
Why managing the data is important?
Explain teradata architecture in detail with a diagram.
Why are oltp database designs not generally a good idea for a data warehouse?
Explain fastload in teradata?
What is the multi-insert?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are the 5 phases in a multiload utility?
What is a three-tier data warehouse?
What is the primary index in teradata?
What is the difference between teradata and basic rdbms?
What are normalization, first normal form, second normal form and third normal form?
What is meant by a Least Cost Plan?
