THE BIG TERADATA QUIZ

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. Are presence bytes stored in each row or once per table (in the table header)?
2. 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)?
3. A Unique Secondary Index has which benefits?
4. Can columnar tables have a primary index defined?
5. Locks can be placed at which three levels?
6. How many presence bytes do you need if you have a table with 9 nullable columns (none is compressed) ?
7. Would you consider to use block level compression (BLC) on a CPU bound system?
8. Which statements describe how data distribution is handled by Teradata?
9. What option can best describe Teradata's architecture?
10. What are advantages when using MERGE instead of UPDATE?

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



The Leaderboard

[mlw_quizmaster_leaderboard mlw_quiz=1]
© 2018 DWHPro

Become a Teradata Expert

Join 4500+ subscribers receiving our free newsletter.

No spam, ever. Just great stuff.

In order to activate your subscription, check your email and click on the link!