1.PERMANENT TABLE 2.INTERM TABLE 3.SET TABLE 4.MULTISET TABLE 5.VOLATIL

What are the types of tables in Teradata

Question Posted / arun reddy

Answer Posted / arun reddy

1.PERMANENT TABLE
2.INTERM TABLE
3.SET TABLE
4.MULTISET TABLE
5.VOLATILE TABLE
6.GLOBAL TEMPORARY TABLE
7.DERIVED TABLE

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are aggregate tables? How do you design them using teradata?

1221

What is partitioned primary index (ppi)?

1090

What can be achieved by using the teradata rdbms?

1092

What are the things to be considered while creating secondary index?

1145

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

1149

Syntax for case when statement?

1118

What is database exceptions in teradata?

1002

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

903

Explain how spool space is used.

1113

What is called partitioned primary index (ppi)?

1056

Explain the types of join supports by teradata?

1045

What is the basic syntax for teradata select statement?

1097

Highlight a few of the advantages that ETL tools have over Teradata.

1138

what is object level locking ? where do appear this type of locking ?

3545

How to identify ppi columns?

1249