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

Teradata Interview Questions

Questions Answers Views Company eMail

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

IBM,

3 7979

If table have access lock.In the same table write lock is posible or not?

1 5405

teradata support to automatically increase the character length or not?

1 5353

How to relege locks in fastload and multiload? example?

IBM,

4 23004

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2477

any one pls tell me what are the table names in banking project?

2 5097

any one answer me how they can analyzing the project using data ware housing?

2476

what are the uses of fact table and dimension table in banking project?

TCS,

4556

what is the query for retrieve the unique values(not display the duplicates values) from single table?

IBM,

6 10038

"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

9 12450

what is the default character set in teradata,,?

IBM, TCS,

2 11282

What is SQL Assistence?please eample

IBM,

4 8327

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

IBM,

2 6670

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

IBM,

3 7124

can we join volatile table with general table an global temporary table with general table ?

IBM,

4 10188

Post New Teradata Questions

Un-Answered Questions { Teradata }

Where is teradata rdbms used?

1097

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

1048

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

2202

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

2163

How will you solve the problem that occurs during update?

1054

What are the joins in teradata?

1009

Why does varchar occupy 2 extra bytes?

1192

What are the main components of teradata system?

1133

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

986

What is meant by a dispatcher?

1021

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

1033

What are the components provided on node?

1042

Explain vproc in teradata?

1000

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

1107

What is the use of stored procedures in teradata?

1004

For More Un-Answered { Teradata } Questions Click Here