1. Explain Different types of temporary tables in Teradata
2. What is the difference between FastLoad and MultiLoad?
3. What is basic Teradata query language?
4. Difference between Inner join and outer join?
5. What is multi Insert?
6. How do you set default date setting in BTEQ?
7. How do you create a table with an existing structure of another table with data and with no data?
8. What is the command in BTEQ to check for session settings?
9. You are calling a Bteq script, which drops a table and creates a table. It will throw an error if the table does not
10. What is FILLER command in Teradata?11.Did you write stored procedures in Teradata?
11. I am updating a table in Bteq. It has to update a large number of rows, so it’s really slow. What do you suggest?
12. Is it necessary to add? QUIT statement after a Bteq query when I am calling it in a Unix environment?
13. There is a column with date in it. If I want to get just month how It can be done? Can I use sub string?
14. What’s the syntax of sub string?
15. Did you use CASE WHEN statement. Can you tell us a little about it?
16. While creating table my DBA has FALLBACK or NO FALLBACK in his DDL. What is that?
17. My table got locked during MLOAD due to a failed job. What do I do to perform other operations on it?
18. How to find duplicates in a table?
19. How to you verify a complicated SQL?
20. How many tables can you join in V2R5?
21. Did you ever use UPPER Function?
22. What does a LOWER Function do?
23. How do you see a DDL for an existing table?
24. Which is more efficient GROUP BY or DISTINCT to find duplicates?
25. Syntax for CASE WHEN statement?
26. What’s the difference between TIMESTAMP (0) and TIMESTAMP (6)?
27. How do you determine the number of sessions?
28. What is node? How many nodes and AMPs used in your previous project?
29. What is a clique?
30. What is the difference between FastLoad and MultiLoad?
31. What is the purpose of indexes?
32. How Teradata makes sure that there are no duplicate rows being inserted when its a SET table?
33. What is basic Teradata query language?
34. What are cliques? What is Vdisk and how it will communicate with physical data storage at the time of data retrieval through AMP?
35. What is the difference between MultiLoad & Fast load interns of Performance?
36. Which two statements are true about a foreign key?
37. How does indexing improve query performance?
38. What is a common data source for the central enterprise data warehouse?
39. What are the enhanced features in Teradata V2R5 and V2R6?
40. Where is the GRANT table option usually done? When tables are newly created, what is the default role and what the default privileges which get assigned?
41. What is error table? What is the use of error table?
42. What is optimization and performance tuning and How does it work in practical projects. Explain with an example.
43. Does SDLC changes when you use Teradata instead of Oracle?
44. What is an optimization and performance tuning and how does it really work in practical projects?
45. What is FILLER command in Teradata?
46. How a Referential integrity is handled in Teradata?
47. Can you recover the password of a user in Teradata?
48. Explain Ferret Utility in Teradata?
49. How can you track Login Parameters of users in Teradata?
2. What is the difference between FastLoad and MultiLoad?
3. What is basic Teradata query language?
4. Difference between Inner join and outer join?
5. What is multi Insert?
6. How do you set default date setting in BTEQ?
7. How do you create a table with an existing structure of another table with data and with no data?
8. What is the command in BTEQ to check for session settings?
9. You are calling a Bteq script, which drops a table and creates a table. It will throw an error if the table does not
10. What is FILLER command in Teradata?11.Did you write stored procedures in Teradata?
11. I am updating a table in Bteq. It has to update a large number of rows, so it’s really slow. What do you suggest?
12. Is it necessary to add? QUIT statement after a Bteq query when I am calling it in a Unix environment?
13. There is a column with date in it. If I want to get just month how It can be done? Can I use sub string?
14. What’s the syntax of sub string?
15. Did you use CASE WHEN statement. Can you tell us a little about it?
16. While creating table my DBA has FALLBACK or NO FALLBACK in his DDL. What is that?
17. My table got locked during MLOAD due to a failed job. What do I do to perform other operations on it?
18. How to find duplicates in a table?
19. How to you verify a complicated SQL?
20. How many tables can you join in V2R5?
21. Did you ever use UPPER Function?
22. What does a LOWER Function do?
23. How do you see a DDL for an existing table?
24. Which is more efficient GROUP BY or DISTINCT to find duplicates?
25. Syntax for CASE WHEN statement?
26. What’s the difference between TIMESTAMP (0) and TIMESTAMP (6)?
27. How do you determine the number of sessions?
28. What is node? How many nodes and AMPs used in your previous project?
29. What is a clique?
30. What is the difference between FastLoad and MultiLoad?
31. What is the purpose of indexes?
32. How Teradata makes sure that there are no duplicate rows being inserted when its a SET table?
33. What is basic Teradata query language?
34. What are cliques? What is Vdisk and how it will communicate with physical data storage at the time of data retrieval through AMP?
35. What is the difference between MultiLoad & Fast load interns of Performance?
36. Which two statements are true about a foreign key?
37. How does indexing improve query performance?
38. What is a common data source for the central enterprise data warehouse?
39. What are the enhanced features in Teradata V2R5 and V2R6?
40. Where is the GRANT table option usually done? When tables are newly created, what is the default role and what the default privileges which get assigned?
41. What is error table? What is the use of error table?
42. What is optimization and performance tuning and How does it work in practical projects. Explain with an example.
43. Does SDLC changes when you use Teradata instead of Oracle?
44. What is an optimization and performance tuning and how does it really work in practical projects?
45. What is FILLER command in Teradata?
46. How a Referential integrity is handled in Teradata?
47. Can you recover the password of a user in Teradata?
48. Explain Ferret Utility in Teradata?
49. How can you track Login Parameters of users in Teradata?
