Get prepared for the Certifications with the Teradata Quiz

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. Which of the following statements concerning PEs are accurate?
2. After an UPDATE statement is running for more than 1 hour you cancel it. As a result a rollback begins. Can it be stopped?
3. Given a NUSI on columns {A,B} and the following SQL statement: SELECT * FROM WHERE A=1 AND B=1 AND C=1. Can the Optimizer use the NUSI (given strong selectivity)?
4. You execution plan shows high confidence for a retrieve step. What does this mean?
5. What kind of Optimizer is used in Teradata?
6. Is "SELECT DATE;" and "SELECT DATE FROM (SELECT NULL AS x) t01;" delivering the same result?
7. Which of the following statements are true concerning Partitioned Primary indexes?
8. To determine space requirements for NUSIs, what are  factors that is utilized?
9. How many presence bits of the first presence byte can be used to store information about NULL values?
10. Do NOPI tables have a ROWID?

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