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

Teradata Interview Questions

Questions Answers Views Company eMail

in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?

HCL,

2 16873

write lock is compatiable with which type of lock?

Infosys,

6 12526

Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance

Cap Gemini,

6 14001

suppose one Cylinder split data blocks are moved from where?

1 4121

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

IBM,

2796

i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80

CTS,

12 17603

2831

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?

Bank Of America, Wipro,

6 50009

Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

Cap Gemini,

4 12415

i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.

1 4434

What is the difference between SI and JI?

2 7416

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

Cap Gemini,

4 13800

I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 10091

Difference between client character set and server character set? What is the use of these two?default character set in teradata?

TCS,

1 9318

how to delete duplicate records in multi set table without using any tables

Accenture, Nest, South Nests Software Solution, Spiro Solutions,

2 14560

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is multi insert?

986

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

1034

When tpump is used instead of multiload?

1044

What are the functions of a teradata dba?

1024

Define views in teradata with general syntax.

984

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

982

What are normalization, first normal form, second normal form and third normal form?

996

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

955

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

931

Write a program to show the parser component used in teradata?

917

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

909

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

956

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

1081

How is the teradata different from oracle?

1035

What are teradata utilities?

1036

For More Un-Answered { Teradata } Questions Click Here