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?

1270

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

1103

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

1251

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

1097

How many tables can you join in v2r5?

1116

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

1140

What is a three-tier data warehouse?

1151

Difference between stored procedure and macro?

1218

What is multi insert?

1108

Different phases of multiload?

1063

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

1155

Did you write stored procedures in teradata?

1186

What is inner join and outer join?

1170

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

1097

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

1317

Post New Teradata Questions

Un-Answered Questions { Teradata }

How do you do backup and recovery in teradata?

1077

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1782

How is MLOAD Teradata Server restarted after execution?

1340

What is the difference between fastload and multiload?

1461

what are the day to day activities of teradata DBA ?

5860

Difference between multiload and tpump?

1157

What are the different methods ot loading a dimension table? A fact table etc?

1082

What are the different design perspectives used in teradata?

1034

Why teradata is used?

1051

What are the joins in teradata?

1071

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2912

what is object level locking ? where do appear this type of locking ?

3538

What are tpump utility limitations?

1176

What is meant by a node?

1075

How is MLOAD Client System restarted after execution?

1202

For More Un-Answered { Teradata } Questions Click Here