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 12933

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

Accenture,

5 34277

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

4 15769

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 10722

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

Mphasis,

4 10230

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

Mphasis,

2 18915

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 9469

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 13283

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 16555

What is differnce between Error code and Error Level in Bteq

IBM,

6 39360

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 21330

What is the default join strategy in Teradata???

IBM,

5 25407

Post New Teradata Questions

Un-Answered Questions { Teradata }

Explain the term 'row' related to relational database management system?

953

What are the different design perspectives used in teradata?

981

What is a node in teradata? Explain

1009

What is the purpose of joins in teradata?

1188

How many types of joins are there in teradata?

978

In BTEQ, how are the session-mode parameters being set?

1143

How can you track login parameters of users in teradata?

1194

Why is the case expression used in teradata?

1078

Different phases of multiload?

1011

What is the syntax for case when statement?

1143

Explain BYNET.

1003

If RDBMS is halted what will you do ?

2168

What are the steps involved after the disk manager passes the request?

1119

What do you mean by teradata intellicloud?

1038

What are the different methods ot loading a dimension table? A fact table etc?

1036

For More Un-Answered { Teradata } Questions Click Here