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?

998

What is spool space?

1088

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

984

What tools would you use for that?

1044

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

986

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

1011

How do you do backup and recovery in teradata?

966

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

921

Explain and compare pros and cons of start schemas?

989

Describe primary index in teradata?

963

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

954

What is partitioned primary index (ppi)?

1008

What are the main components of teradata system?

1077

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

1006

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

970

Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the frequently used data types in teradata?

1020

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

938

Differentiate primary key and partition key?

947

What is stored procedure in teradata?

969

What are the multiload utility limitations?

1011

Explain vproc in teradata?

943

what are the uses of fact table and dimension table in banking project?

4503

What is the use of stored procedures in teradata?

946

How many tables can you join in v2r5?

1011

how can we analyze the locks ?

2070

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

915

List out all forms of LOCKS that are available in Teradata.

927

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

942

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

970

Difference between stored procedure and macro?

1119

For More Un-Answered { Teradata } Questions Click Here