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?

1105

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

989

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

1123

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

980

How many tables can you join in v2r5?

998

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

1034

What is a three-tier data warehouse?

1053

Difference between stored procedure and macro?

1109

What is multi insert?

984

Different phases of multiload?

936

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

1052

Did you write stored procedures in teradata?

1058

What is inner join and outer join?

1037

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

980

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

1162

Post New Teradata Questions

Un-Answered Questions { Teradata }

In Teradata, how do we Generate Sequence?

981

Explain the types of join supports by teradata?

935

Why managing the data is important?

957

What are the various indexes in teradata? How to use them?

954

What is meant by a Channel Driver?

1142

What are the various indexes in teradata?

968

What is primary index and secondary index?

973

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1724

Syntax for case when statement?

1007

What are the functions performed by bynet?

981

what are the day to day activities of teradata DBA ?

5756

What are the various reporting tools in the market?

989

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 ?

2418

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2132

What is partitioned primary index (ppi)?

998

For More Un-Answered { Teradata } Questions Click Here