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

Teradata Interview Questions

Questions Answers Views Company eMail

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

IBM,

2118

On which column will you take primary index???

4 8996

What are the differences between TerdataV2R5 and V12 Versions please??

3 7219

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 4166

what are the default access rights in the teradata?

1 7263

Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q

45 51112

How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.

2 6709

wt r before journal& after journel.....in teradata

4 9659

in teradata level primary in table level allows duplicates why?

TCS,

1 6247

in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

IBM,

1 5626

Which Teradata concept allows more than one model generation?

TCS,

1 10858

what is object level locking ? where do appear this type of locking ?

3497

how can i answer for question like teradat architecture in interveiw

TCS,

4 10514

plz explain parlla distribution and subtable concept in teradata

TCS,

3 9642

how many modules are there in telecome domain?how to explain the architecture?

2013

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

2202

What are the different table types supported by teradata?

967

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

984

How many types of joins are there in teradata?

976

What is a three-tier data warehouse?

1113

Is multi insert ansi standard?

2206

What is teradata?

1150

What is meant by a Channel Driver?

1246

How to view every column and the columns contained in indexes in teradata?

1056

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

1041

If RDBMS is halted what will you do ?

2168

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

1003

How to Extract data from multiple legacy systems?

1120

What are the functions of a teradata dba?

1074

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

2414

For More Un-Answered { Teradata } Questions Click Here