Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata Interview Questions

Questions Answers Views Company eMail

Why does varchar occupy 2 extra bytes?

1192

Why are oltp database designs not generally a good idea for a data warehouse?

1056

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

1195

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

1048

How many tables can you join in v2r5?

1073

What are the things to be considered while creating secondary index?

1101

What is a three-tier data warehouse?

1113

Difference between stored procedure and macro?

1172

What is multi insert?

1049

Different phases of multiload?

1011

What is the maximum number of dml can be coded in a multiload script?

1109

Did you write stored procedures in teradata?

1132

What is inner join and outer join?

1110

How to view every column and the columns contained in indexes in teradata?

1056

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

1240

Post New Teradata Questions

Un-Answered Questions { Teradata }

What happens when a node suffers a downfall?

1131

What is the use of fallback?

996

Why managing the data is important?

1015

What is a level of granularity of a fact table?

1158

How can you track login parameters of users in teradata?

1194

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

1066

What do you mean by fastexport in teradata?

999

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

1240

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

1054

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2202

Highlight all the modes that are present under Confidence Level.

971

What is TPD?

1373

What are the various indexes in teradata?

1049

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

What is the difference between union and union all in teradata?

1128

For More Un-Answered { Teradata } Questions Click Here