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

Teradata Interview Questions

Questions Answers Views Company eMail

Explain teradata utilities?

1032

What is spool space?

1149

How do you create tables? Exact syntax, and create profiles, users in teradata?

1023

What tools would you use for that?

1101

In general, how do you optimze any sql in teradata?

1039

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

1059

How do you do backup and recovery in teradata?

1011

Explain the teradata primary index mechanics in detail with a diagram.

968

Explain and compare pros and cons of start schemas?

1056

Describe primary index in teradata?

996

Describe primary index in teradata. And what are the available primary index types?

997

What is partitioned primary index (ppi)?

1044

What are the main components of teradata system?

1122

Explain the term 'columns' related to relational database management system?

1060

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

1011

Post New Teradata Questions

Un-Answered Questions { Teradata }

In general, how do you optimze any sql in teradata?

1039

How do you define Teradata?

1029

What is the use of stored procedures in teradata?

996

What is dimensional modeling?

1078

How to Extract data from multiple legacy systems?

1111

How to find duplicates in a table?

1204

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

823

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 ?

2470

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1103

What is meant by a node?

1039

What are the different functions included in the server software?

1026

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1159

What is meant by a Channel Driver?

1232

What are the available primary index types?

1208

Why managing the data is important?

1011

For More Un-Answered { Teradata } Questions Click Here