Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata Interview Questions

Questions Answers Views Company eMail

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1159

Highlight the advantages of PPI(Partition Primary Index).

1072

What is meant by a Least Cost Plan?

1057

What is meant by a dispatcher?

1008

Highlight the points of differences between the database and user in Teradata.

1103

Explain BYNET.

987

Highlight the need for Performance Tuning.

1103

In the Primary Index, what is the score of AMPs that are actively involved?

1066

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1244

What is meant by a Virtual Disk?

1124

What is meant by a Parsing Engine?

1184

Explain how spool space is used.

1070

What do you mean by parsing?

1108

Highlight a few of the advantages that ETL tools have over Teradata.

1084

How can bottlenecks be identified?

1009

Post New Teradata Questions

Un-Answered Questions { Teradata }

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

985

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2412

In BTEQ, how are the session-mode parameters being set?

1141

Define views in teradata with general syntax.

1021

What is the use of fallback?

990

Explain Teradata performance tuning and optimization?

1156

How to run a query in teradata?

1062

How is MLOAD Client System restarted after execution?

1139

What are the steps to create a data model?

1047

How many codd's rules are satisfied by teradata database?

1107

How do you do backup and recovery in teradata?

1011

Syntax for case when statement?

1056

What is the command in bteq to check for session settings ?

1178

Highlight the points of differences between the database and user in Teradata.

1103

Explain the advantages of partitioned primary index in a query?

1020

For More Un-Answered { Teradata } Questions Click Here