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?

1184

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

1052

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

1181

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

1043

How many tables can you join in v2r5?

1065

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

1096

What is a three-tier data warehouse?

1106

Difference between stored procedure and macro?

1166

What is multi insert?

1045

Different phases of multiload?

990

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

1100

Did you write stored procedures in teradata?

1128

What is inner join and outer join?

1102

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

1044

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

1233

Post New Teradata Questions

Un-Answered Questions { Teradata }

Explain BYNET.

987

Explain vproc in teradata?

991

What is the use of having index on table?

997

What is teradata and why it is used?

1088

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

1051

What is basic teradata query language?

1107

How can bottlenecks be identified?

1009

Explain some differences between mpp and smp?

1090

What does Amp contain and what are all the operations that it performs?

995

What are the primary characteristics of the Teradata.

1136

What are the newly developed features of Teradata?

1016

What is database exceptions in teradata?

944

How does hashing happens in teradata?

1081

Explain the teradata primary index mechanics in detail with a diagram.

969

What is difference between user and database in teradata?

1065

For More Un-Answered { Teradata } Questions Click Here