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

NameEmail
1) For SELECT * FROM <TABLE> WHERE <COL1>=1 OR<COl2>=1;
No statistics on COL1 and COL2, but Primary Index Statistics.
The table contains 1000 rows. How many rows will estimated for the retrieve step by the Optimizer?
2) When you create a primary index, which of the following options should be taken into consideration?
3) Were would put your most critical workload  in the hierarchy?
4) Can you define a Secondary Index on top of a Join Index?
5) How many presence bytes do you need if you have a table with 9 nullable columns (none is compressed) ?
6) Can zones be defined without assigning a root?
7) Before selecting the Primary Index, what do you need to know so that even distribution is ensured?
8) "TheTable" is partitioned by "TheYear", which is an INTEGER column. In which of the queries below will partition elimination take place?
9) When you compress multiple values for a column, where is it stored?
10) Would you consider to use block level compression (BLC) for cold data?

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





The Leaderboard

Leaderboard for Big Teradata

1. None-100%
2. sanjib patra-100%
3. koushik-100%
4. sathiya-100%
5. Anil kumar-100%
© 2017 DWHPro
Let us help you to become a Teradata Expert

Join 3000+ 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!

Your information will never be shared with any third party
x