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)?

1192

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

1048

How many tables can you join in v2r5?

1071

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?

1009

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

1107

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 is inner join and outer join?

1110

Explain vproc in teradata?

1000

What is meant by a Virtual Disk?

1136

How to eliminate product joins in a teradata sql query?

1029

Which is faster fastload or multiload?

1112

Difference between inner join and outer join?

1025

What type of indexing mechanism do we need to use for a typical data warehouse?

1165

What are the functions involved in shared information architecture?

1073

What is basic teradata query language?

1113

Why is the case expression used in teradata?

1077

What is the use of fallback?

996

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

4370

What is spool space?

1158

Explain the most common data types used in teradata?

1069

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1024

For More Un-Answered { Teradata } Questions Click Here