[admin]

1. What is log table? What is the use of log table?

2. What is optimization and performance tuning and how does it work in practical projects. Explain with an example.

3. How many types errors will be occur in total SPOOL process

4. What are set tables and multiset tables in Teradata? Explain with an appropriate example?

5. How many error tables are there in fload and what are their significance/use? Can we see the data of error tables?How many error tables are their in mload and what is there use? When mload job fails?
6. what is teradata ..explain and how does it work?
7. What is the difference between Global temporary tables and Volatile temporary tables?
8. How teradata makes sure that there are no duplicate rows being inserted when its a SET table?

9. What are the enhanced features in Teradata V2R5 and V2R6?

10. After creating tables dynamically in the Teardata, where is the GRANT table option usually done

11. What is cliques? What is Vdisk and how it will communicate with physical data storage at that time.
12. How many types errors will be occur in total SPOOL process and How can we connect a database server?
13. What is basic teradata query language?

14. How many codd's rules are satisfied by teradata database?
15. How can we build data marts from FSLDM. is there any standard approach for this? Is FSLDM supports place
16. How does indexing improve query performance?

17. What is the difference between Multiload & Fastload interms of Performance?

18. Can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
19. What is the difference between start schma and Fsldm?
20. Does SDLC changes when you use Teradata instead of Oracle?
21. What is FILLER command in Teradata?
22. How a Referential integrity is handled in Teradata?
23. Why Fload doesn’t support multiset table?
24. What is use of compress in terdata?Explain?
25. How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
26. Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
27. which tool is used to collect and analyze database performance?
28. Batch process block level loading are performed against populated tables by which utility?
29. Why to Choose a Non Unique primary index instead of a unique primary index?
30. When utilizing a unique secondary index, how many AMP(s) are most probably accessed?