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 12934

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 15233

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

IBM, Mphasis,

3 10723

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

Mphasis,

4 10232

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 13286

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 16557

What is differnce between Error code and Error Level in Bteq

IBM,

6 39362

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 vproc in teradata?

1001

How is MLOAD Client System restarted after execution?

1154

Steps to create a data model?

1133

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1240

Explain the term 'primary key' related to relational database management system?

1036

What is meant by a Parsing Engine?

1188

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1203

What are the uses of bynets in multi-node systems?

1030

What do you mean by teradata sql assistant?

1062

What is difference between user and database in teradata?

1067

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

1048

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2480

if collect stats but it show low confidence why?

1688

What is real time and near real time data warehousing?

1118

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1153

For More Un-Answered { Teradata } Questions Click Here