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) Do NOPI tables have a ROWID?
2) Can zones be defined without assigning a root?
3) Is partition level locking available on Teradata 15.10?
4) In which way is data distributed with a Partitioned Primary Index?
5) A table with 8 columns (data type INTEGER, no MVC) holds 1000 rows. All of the columns are NULLABLE? If you would set one of the columns to NOT NULL, what would be the impact?
6) Given a NUSI on columns {A,B} and the following SQL statement: SELECT * FROM WHERE A=1 AND B=1. Can the Optimizer use the NUSI (given strong selectivity)?
7) Assume that in DBC.DBQLOGTBL the column WDDelayTime equals DelayTime. What can you conclude?
8) Is the row hash value of 1 (INTEGER) the same like the row hash value of '1' (CHAR)?
9) For SELECT * FROM <TABLE> WHERE <COL1>=1 AND <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?
10) Which of these technical join types are available on Teradata?

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%

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!