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?

1122

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

1007

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

1132

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

995

How many tables can you join in v2r5?

1011

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

1051

What is a three-tier data warehouse?

1064

Difference between stored procedure and macro?

1120

What is multi insert?

996

Different phases of multiload?

946

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

1069

Did you write stored procedures in teradata?

1071

What is inner join and outer join?

1050

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

996

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

1180

Post New Teradata Questions

Un-Answered Questions { Teradata }

Explain teradata architecture?

1041

What is the syntax for case when statement?

1074

Explain the meaning of Amp?

1058

How do you verify a complicated sql?

1023

any one answer me how they can analyzing the project using data ware housing?

2421

What are the frequently used data types in teradata?

1022

What are the functions involved in shared information architecture?

1034

Describe the between keyword in teradata?

991

Differentiate primary key and partition key?

947

What is node? How many nodes and amps used in your previous project?

1073

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

972

How you will check the version of teradata?

1097

What are the main components of teradata system?

1080

what are the uses of fact table and dimension table in banking project?

4503

What is stored procedure in teradata?

971

For More Un-Answered { Teradata } Questions Click Here