Permanent Table Set Table Multi Set Table derived Table Volatile Table

What are the types of tables in Teradata

Question Posted / kishore

Answer Posted / kishore

Permanent Table
Set Table
Multi Set Table
derived Table
Volatile Table
Global temporary Table
Error Table
Queue Table
temporal Table(from TD13.10)

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the string manipulation operators and functions associated with teradata?

1090

What exactly do you know about catching in teradata?

1038

Why teradata is used?

1007

How many codd's rules are satisfied by teradata database?

1112

What do high confidence, low confidence and no confidence mean in explain plan?

1048

What are the various indexes in teradata? Why are they preferred?

1005

Explain the new features of teradata?

1045

What are the commands to make a new table, change a table and remove a table in teradata?

1132

What are the different softwares used with their functions in teradata?

1015

Explain how spool space is used.

1076

What is teradata? What are some primary characteristics of teradata?

974

What are the different design perspectives used in teradata?

982

How you will check the version of teradata?

1166

how do you manage the production space. what are the proactive methods you can take ?

1945

What does sleep function does in fast load?

1139