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 11838

Why FLOAD does not support multiset tables??

TCS, Tesco,

3 14174

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

TCS,

3 13062

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

Accenture,

5 34485

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

4 15901

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 15450

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

IBM, Mphasis,

3 10839

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

Mphasis,

4 10397

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

Mphasis,

2 19026

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 9577

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 13427

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 16714

What is differnce between Error code and Error Level in Bteq

IBM,

6 39570

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 21543

What is the default join strategy in Teradata???

IBM,

5 25597

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

2468

Can we collect statistics on table level?

1092

What is the difference between fastload and multiload?

1461

What are the 5 phases in a multiload utility?

1087

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

1118

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

1071

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1242

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1084

Why do you get spool space errors? How do trouble-shoot them?

1089

How to run a query in teradata?

1144

What is the difference between fastload and multiload? Which one is faster?

1296

How to eliminate product joins in a teradata sql query?

1085

What are the various etl tools in the market?

1121

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1081

What are the different table types supported by teradata?

1019

For More Un-Answered { Teradata } Questions Click Here