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?

881

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

845

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

940

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

839

How many tables can you join in v2r5?

848

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

883

What is a three-tier data warehouse?

853

Difference between stored procedure and macro?

952

What is multi insert?

833

Different phases of multiload?

804

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

863

Did you write stored procedures in teradata?

876

What is inner join and outer join?

853

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

839

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

953

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is the primary index in teradata?

844

Differentiate database data and data warehouse data?

833

What are aggregate tables? How do you design them using teradata?

895

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

863

How would you load a very large file in teradata in general?

820

Give a justifiable reason why Multi-load supports NUSI instead of USI.

932

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1953

What is the use of stored procedures in teradata?

806

What is meant by a Virtual Disk?

862

Mention a few of the ETL tools that come under Teradata.

889

Explain and compare pros and cons of snow flake schemas?

841

Name the five phases that come under MultiLoad Utility.

797

What are some commonly used bteq scripts?

779

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

1521

List the logical and conditional operators that are used with teradata along with their meanings?

792

For More Un-Answered { Teradata } Questions Click Here