TERADATA CONCEPTS
1. What is Spool Space in Teradata?
2. What is Fallback?
3. Explain Teradata Architecture
4. Write a query to delete duplicate rows?
5. Diff b/w PI and PK.
6. What is Full Outer Join? Give a scenario where it can be used?
7. Diff b/w left outer and right outer join.
8. What is PPI?
9. How does compress work.
10. Diff b/w Teradata and Oracle.
11. What is spool space? Does it impact other users?
12. What is multiset
13. What is derived query
14. Difference between derived table and volatile table
15. How will teradata decide which row will have to be placed where? ans- Hashing Algorithm.
16. What is Set and MultiSet table?
17. What is meant by Skew? Explain.
18. What is volatile table?
19. What are the other kinds of tables.
20. What is the difference between Volatile and Global Temp table?
21. How to select first N Records in Teradata?
22. What is the difference between Sub-Query & Co-Related Sub-Query?
23. Is Like comparison case-sensitive in Teradata?
24. Difference between Inner join and outer join?
25. How to find duplicates in a table?
26. How do you see a DDL for an existing table?
27. Which is more efficient GROUP BY or DISTINCT to find duplicates?
28. Syntax for CASE WHEN statement?
29. How to handle nulls in Teradata???
30. How to find average sal without using avg function????
31. What all are different protection techniques in teradta..?
32. What are salient features of Teradata..?
33. How data will be distributed in teradta..?
34. How to find a particular table details in teradata..?
35. How to find a particular column details in teradata..?
36. How to use Rank function and Row number functions..
37. How to use partition by concept in Teradata..?
38. How to tune queries in Terdata..?
39. How to find top 3 salaries in a particular table?
40. How to use String functions substr(),Like operarator?
41. Difference between Where, Having and Qualify?
42. SQL Concepts with all functions and operators?
No comments:
Post a Comment