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. How many rows of size 64KB can be stored in a 127.5KB data block?
2. Would you consider to use block level compression (BLC) for frequently accessed, huge tables?
3. Which of the following statements regarding a Primary Index are true?
4. After an UPDATE statement is running for more than 1 hour you cancel it. As a result a rollback begins. Can it be stopped?
5. You want to change the structure of a populated table, but want to avoid any spool usage. Which methods could be used?
6. In which way is data distributed with a Partitioned Primary Index?
7. Given a NUSI on columns {A,B} and the following SQL statement: SELECT * FROM WHERE A=1. Can the Optimizer use the NUSI (given strong selectivity)?
8. Is "SELECT DATE;" and "SELECT DATE FROM (SELECT NULL AS x) t01;" delivering the same result?
9. What will be the performance impact of 1MB data blocks?
10. How can the rows be accessed when using an USI?

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



DWHPro offers you extensive and detailed information about Teradata.
Contact us: [email protected]
© 2019 DWHPRO
Subscribe to our Newsletter

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!

x
Analytics by GoSquared