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 11454

Why FLOAD does not support multiset tables??

TCS, Tesco,

3 13904

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

TCS,

3 12784

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

Accenture,

5 34038

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

4 15633

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 14997

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

IBM, Mphasis,

3 10554

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

Mphasis,

4 10038

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

Mphasis,

2 18770

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 9349

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 13105

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 16412

What is differnce between Error code and Error Level in Bteq

IBM,

6 39081

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 21107

What is the default join strategy in Teradata???

IBM,

5 25180

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

1014

List the logical and conditional operators that are used with teradata along with their meanings?

948

why use references rather than pointers in the public api, particularly for arguments which are modified?

947

What is the purpose of indexes?

1021

What is upsert statement in teradata?

1065

Difference between multiload and tpump?

1049

What are different table types used in teradata?

989

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4328

What are the available primary index types?

1155

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2371

What's the difference between timestamp (0) and timestamp (6)?

1130

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

968

What is the use of stored procedures in teradata?

945

During the Display time, how is the sequence generated by Teradata?

975

What is multi insert?

994

For More Un-Answered { Teradata } Questions Click Here