Teradata SQL - 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. Which statements describe how data distribution is handled by Teradata?

Hash values are calculated using the hashing algorithm

The hash value for each row is calculated using the Primary Key

Hash values are assigned to each node

Hash maps will change if you add AMPs to the system

2. What are the unique characteristics of a dynamic hash join?

The usage of the this join type is determined dynamically during query execution

The dynamic hash join calculates the rows hash values of the big table join columns dynamically during the join

The big table is not spooled locally in order to calculate the row hash of the join columns

The Optimizer decided during query execution if it falls back to a Merge Join

3. What is the minimum data block size?

64 Kilobytes

512 Bytes

1 Megabyte

128 Kilobytes

4. Is it possible to create a NUSI on a NOPI table?

Yes

No

5. A huge table is accessed several hundreds of times per day. Which kind of compression would be the better choice?

Block Level Compression

Multivalue Compression

6. Is it possible to use 1MB data blocks together with small cylinders?

Yes

No

7. You want to change the structure of a populated table, but want to avoid any spool usage. Which methods could be used?

ALTER TABLE

INSERT SELECT

MERGE INTO

8. Which of the following statements regarding a Primary Index are true?

A Primary Index is a physical mechanism

There is a limit to the number of columns in a Primary Index

A Primary Index requires uniqueness

A Primary Index value can not be null

9. Which of the following indexes keeps related base table rows and index rows on the same AMP?

USI

NUSI

NUPI

UPI

10. Assume in DBC.DBQLOGTBL the column WDDelayTime is NULL and DelayTime > 0. What can you conclude?

No workload delays have been applied

Workload delays have been applied

DelayTime represents the system delay time

System delays have been applied

DWH Pro – The Teradata Experts

THE BIG TERADATA QUIZ

Welcome to the Big Teradata Quiz.

Enter your name and press "NEXT" to start the quiz

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

Become a Teradata Expert

DWH Pro – The Teradata Experts

THE BIG TERADATA QUIZ

Welcome to the Big Teradata Quiz.

Enter your name and press "NEXT" to start the quiz

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

Become a Teradata Expert

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