What is difference between user and database in teradata?
What is a sparse index?
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
If table have access lock.In the same table write lock is posible or not?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?
What are the various indexes in teradata? How to use them?
what is sysdba and sysdbc ? which has high priority ?
What are teradata utilities?
What is the use of upsert command in teradata?
What is meant by a Highest Cost Plan?
What is the use of having index on table?
What are the various indexes in teradata? Why are they preferred?