Teradata Interview Questions
Questions Answers Views Company eMail

Explain teradata utilities?

556

What is spool space?

591

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

546

What tools would you use for that?

558

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

534

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

585

How do you do backup and recovery in teradata?

536

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

557

Explain and compare pros and cons of start schemas?

535

Describe primary index in teradata?

575

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

533

What is partitioned primary index (ppi)?

552

What are the main components of teradata system?

574

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

540

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

540


Post New Teradata Questions

Un-Answered Questions { Teradata }

How is the teradata different from oracle?

615


What is stored procedure in teradata?

575


What are the different methods ot loading a dimension table? A fact table etc?

568


How can bottlenecks be identified?

567


What are the steps involved in the process flow of the sql statement through channel attached system?

653






What do you mean by teradata sql assistant?

581


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

604


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

560


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

592


what are the day to day activities of teradata DBA ?

5354


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

540


What are the different functions performed in development phase?

564


Give the sizes of SMALLINT, BYTEINT and INTEGER.

655


What is real time and near real time data warehousing?

661


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

552