A Short Teradata Quiz for You | DWHPRO
1

A Short Teradata Quiz for You

Here is a short Teradata Quiz for you. I hope you like it.

 

 

Welcome to the Teradata Quiz.

Each time you take the quiz, a different set of questions will be asked. We are adding new questions on a regular base. At the end of the quiz, we will show you the correct answers, your score and the average score of all people.

Enter your name and press "NEXT" to start the quiz

Name Email
1.

You want to change a table structure (the DLL). Which method requires an exclusive lock on the source table?

2.

Is the row hash value of 1 (INTEGER) the same like the row hash value of '1' (CHAR)?

3.

Given the query SELECT * FROM

WHERE colA LIKE 'A%', can a NUSI on colA be used, and how?

4.

What are reliable measures in performance tuning?

5.

When utilizing a Unique Secondary index, how many AMP (s) are usually accessed?

6.

Can zones be defined without assigning a root?

7.

Assume your table is skewed, 80% of all rows are located on only one AMP. How should the statistics be collected?

8.

When you compress multiple values for a column, where is it stored?

9.

Block level operations are performed against populated tables by which utility?

10.

Which of the following are purposes that AMP serves?


Be sure to click "Submit Quiz" to see your results
(click only once, the rating process may need a couple of seconds)!



Roland Wenzlofsky
 

Roland Wenzlofsky is a graduated computer scientist and Data Warehouse professional working with the Teradata database system for more than 20 years. He is experienced in the fields of banking and telecommunication with a strong focus on performance optimization.

  • Avatar sathya says:

    1)Which of the following is not stored in a sub table?
    Answer Provided: Join Index (JI).Row Partitioned Table.
    Correct Answer: Row Partitioned Table.

    comment: I am aware only the Secondary indexes in Teradata creates sub-table, but for the above question, why the JI stored in sub table, does this question meant that JI allows creation of SI over the JI or does it meant Join Index (JI) stores its join results in perm space.

    2) Which of these technical join types are available on Teradata?
    Answer Provided: Left Outer Join.
    Correct Answer: Hash Join.Merge Join.Sliding Window Merge Join.Product Join.

    Comment: Hash Join, Merge Join, Sliding Window Merge Join and Product Join are the join strategies determined by the optimizer based on the joining tables data distribution, so I have answered Left outer join is the Join Type, a user can decide based on his business need.

    3) Are tables without Primary Index (NOPI) always distributed evenly across all AMPs?
    Answer Provided: Yes
    Correct Answer: No

    Comment: Could you explain to me why the NOPI tables not always evenly distributed across all AMPs.

    Kindly advise me on how to approach the above questions.

    Thanks,

  • >