A Short Teradata Quiz for You


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



Welcome to the Big 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. Do NOPI tables have a ROWID?
2. Is it recommended to use 1MB data blocks together with small cylinders?
3. Would you consider to use block level compression (BLC) for frequently accessed, huge tables?
4. Would you consider to use block level compression (BLC) in order to reduce perm space usage?
5. Can zones be defined without assigning a root?
6. What is the result of a full table scan occurring on Teradata?
7. Which of the following statements about NOPI tables are wrong?
8. How many bytes the BIGINT occupies?
9. Assume adding a row of size 5 bytes (char(5)) to an empty table (having a primary index)? By how much will the table at least grow (in size)?
10. You execution plan shows high confidence for a retrieve step. What does this mean?

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

Our Reader Score
[Total: 16    Average: 3.6/5]
A Short Teradata Quiz for You written by Roland Wenzlofsky on October 26, 2015 average rating 3.6/5 - 16 user ratings


  1. 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 optimiser 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 me why the NOPI tables not always evenly distributed across all AMPs.

    Kindly advice me how to approach the above questions.



Please enter your comment!
Please enter your name here