Teradata Interview Questions
Questions Answers Views Company eMail

Why does varchar occupy 2 extra bytes?

596

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

591

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

621

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

579

How many tables can you join in v2r5?

613

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

622

What is a three-tier data warehouse?

621

Difference between stored procedure and macro?

670

What is multi insert?

617

Different phases of multiload?

584

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

613

Did you write stored procedures in teradata?

607

What is inner join and outer join?

606

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

577

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

641


Post New Teradata Questions

Un-Answered Questions { Teradata }

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

622


Highlight the advantages of PPI(Partition Primary Index).

555


What are the advantages of teradata?

592


Can we collect statistics on multiple columns?

556


what are the day to day activities of teradata DBA ?

5354






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

621


What exactly do you know about catching in teradata?

625


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

563


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

1661


Explain teradata utilities?

556


In Teradata, what is the significance of UPSERT command?

581


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

520


What happens in a conflict? How do you handle that?

610


What is meant by Teradata Gateway?

572


What is database exceptions in teradata?

536