October 23

0 comments

DWHPro Basics

By DWH Pro Admin

October 23, 2015


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 are types of columns that is supported with compression?
2. Is table skew increasing the problem of duplicate row checks (SET tables)?
3. How many presence bits of the first presence byte can be used to store information about NULL values?
4. Which two of the following statements are true if an EXPLAIN output contains the following phrase?  "with high confidence"
5. Is the primary index for columns (A,B) the same like for (B,A)?
6. Where are random AMP samples stored?
7. Given two separate NUSI's on the same table for column A and B. Given strong selectivity for both NUSIs, which one will be used for SELECT * FROM <TABLE> WHERE A = 1 AND B = 1;
8. Is it possible to use 1MB data blocks together with small cylinders?
9. The column DelayTime in the DBC.DBQLOGTBL shows what?
10. Which statement about statistic histograms are valid?

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



DWH Pro Admin


Teradata and Data Warehouse Specialist with more than 20 years of experience

You might also like

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Never miss a good story!

 Subscribe to our newsletter to keep up with the latest trends!

>