Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata Interview Questions

Questions Answers Views Company eMail

If a Node is busy what are the steps you can take to avoid ?

Teradata,

2349

Give some points about Teradata Viewpoint ?

Teradata,

3 13303

how do you manage the production space. what are the proactive methods you can take ?

1884

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2135

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

2101

If the table does not have duplicates then which utility you can suggest to load the data ?

3 6438

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

1998

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1904

A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?

1 4460

how do you handle ET and UV errors ?

2 10599

If the script is aborted. why it is aborted and how can you identify ?

1 4442

how can we analyze the locks ?

HP,

2059

Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance

IBM,

4 8266

what is amp plz explanation

IBM,

5 8328

what is use of PI(primary index) AND SI(secondary index)

Wipro,

2 7263

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is the use of having index on table?

954

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?

1153

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

770

How to identify ppi columns?

1103

What interface is used to connect to windows based applications?

1039

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3541

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

1003

What are the components used in smp and massively parallel processing (mpp) machines?

1004

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2135

What are the different table types that are supported by teradata?

955

Explain Teradata performance tuning and optimization?

1108

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

912

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

930

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

969

Discuss the advantages of using partitioned primary index in a query?

909

For More Un-Answered { Teradata } Questions Click Here