Teradata Interview Questions
Questions Answers Views Company eMail

Give the sizes of SMALLINT, BYTEINT and INTEGER.

657

Highlight the advantages of PPI(Partition Primary Index).

559

What is meant by a Least Cost Plan?

615

What is meant by a dispatcher?

560

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

583

Explain BYNET.

602

Highlight the need for Performance Tuning.

578

In the Primary Index, what is the score of AMPs that are actively involved?

573

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?

683

What is meant by a Virtual Disk?

571

What is meant by a Parsing Engine?

701

Explain how spool space is used.

611

What do you mean by parsing?

625

Highlight a few of the advantages that ETL tools have over Teradata.

607

How can bottlenecks be identified?

571


Post New Teradata Questions

Un-Answered Questions { Teradata }

In the Primary Index, what is the score of AMPs that are actively involved?

573


Explain teradata utilities. What is multiload, fast load, tpump?

566


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

541


What is logical data model?

632


Explain parsing engine in teradata?

585






What is the purpose of joins in teradata and what are the available join types?

540


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

526


What are some primary characteristics of teradata?

542


What are the functions performed by bynet?

601


Can we collect statistics on multiple columns?

559


What is real time and near real time data warehousing?

664


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

592


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

668


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

551


How do you determine the number of sessions?

608