Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata Interview Questions

Questions Answers Views Company eMail

Can any one please provide me practical example of How to do the performance tuning in Query??

Amdocs,

5 11656

Why FLOAD does not support multiset tables??

TCS, Tesco,

3 14048

What is collect State in Teradata ? what it use and how it works??

TCS,

3 12931

What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

Accenture,

5 34275

What is the difference between correlated sub queries and inner queries?

4 15768

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

CTS, TCS,

5 15231

Where we use PPI in real time??? What is the disadvantages of PPI?

IBM, Mphasis,

3 10719

What is the Maximum number of volatile tables that can be created?

Mphasis,

4 10224

What is a pseudo key? What is its use???

Mphasis,

2 18910

Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

IBM,

2 9466

How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????

Mphasis,

3 13282

In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

CTS, Lexicon,

3 16554

What is differnce between Error code and Error Level in Bteq

IBM,

6 39359

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

IBM,

6 21327

What is the default join strategy in Teradata???

IBM,

5 25406

Post New Teradata Questions

Un-Answered Questions { Teradata }

what is sysdba and sysdbc ? which has high priority ?

3831

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

835

What is upsert statement in teradata?

1137

Explain some differences between mpp and smp?

1099

What do you mean by ttu in teradata?

1033

What is called partitioned primary index (ppi)?

1013

What are the functions of a Parser?

1113

What is the use of stored procedures in teradata?

1004

if collect stats but it show low confidence why?

1686

Explain the types of join supports by teradata?

993

What is TPD?

1372

What is a node in teradata? Explain

1009

Discuss the advantages of using partitioned primary index in a query?

952

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1169

Explain fallback in teradata?

1058

For More Un-Answered { Teradata } Questions Click Here