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 11650

Why FLOAD does not support multiset tables??

TCS, Tesco,

3 14038

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

TCS,

3 12922

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

Accenture,

5 34258

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

4 15761

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 15214

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

IBM, Mphasis,

3 10705

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

Mphasis,

4 10214

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

Mphasis,

2 18904

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 9459

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 13268

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 16550

What is differnce between Error code and Error Level in Bteq

IBM,

6 39350

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 21302

What is the default join strategy in Teradata???

IBM,

5 25389

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is logical data model?

1200

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1106

Explain PDE.

1076

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1095

What is node? How many nodes and amps used in your previous project?

1108

What are the scenarios in which full table scans occurs?

1008

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

1040

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2048

Explain vproc in teradata?

995

What is meant by a Least Cost Plan?

1057

What is the purpose of joins in teradata and what are the available join types?

1079

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?

1197

What is bteq script in teradata?

1150

What is database exceptions in teradata?

947

What is difference between user and database in teradata?

1065

For More Un-Answered { Teradata } Questions Click Here