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?

1034

What is spool space?

1153

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

1027

What tools would you use for that?

1106

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?

1061

How do you do backup and recovery in teradata?

1014

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

971

Explain and compare pros and cons of start schemas?

1061

Describe primary index in teradata?

999

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

1002

What is partitioned primary index (ppi)?

1047

What are the main components of teradata system?

1125

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

1062

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

1018

Post New Teradata Questions

Un-Answered Questions { Teradata }

Syntax for case when statement?

1059

Difference between multiload and tpump?

1099

How is MLOAD Client System restarted after execution?

1144

Explain the most common data types used in teradata?

1064

What is teradata? What are some primary characteristics of teradata?

971

What is the syntax for case when statement?

1133

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?

1251

What are the uses of bynets in multi-node systems?

1028

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

1106

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

1730

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

991

Discuss the advantages of using partitioned primary index in a query?

951

What is a node in teradata?

994

What are the components used in smp and massively parallel processing (mpp) machines?

1054

Difference between star and snowflake schemas?

1144

For More Un-Answered { Teradata } Questions Click Here