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?

855

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

832

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

920

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

818

How many tables can you join in v2r5?

827

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

858

What is a three-tier data warehouse?

829

Difference between stored procedure and macro?

928

What is multi insert?

815

Different phases of multiload?

788

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

837

Did you write stored procedures in teradata?

851

What is inner join and outer join?

836

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

814

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

923

Post New Teradata Questions

Un-Answered Questions { Teradata }

Difference between stored procedure and macro?

928

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1913

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

833

How can bottlenecks be identified?

777

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

849

What do you mean by caching in teradata?

835

What are the main components of teradata system?

830

What are default access rights in teradata? What explicit right can be given to a user?

885

What is smp and mpp platforms?

734

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

781

What are the 5 phases in a multiload utility?

819

How to load specific no.of records using bteq, or fastload,or multiload

1534

What are the functions involved in shared information architecture?

831

Describe the between keyword in teradata?

830

List out teradata data types?

767

For More Un-Answered { Teradata } Questions Click Here