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. Is it possible to create a NUSI on a NOPI table?

Yes

No

2. A table with 8 columns (data type INTEGER, no MVC) holds 1000 rows. 7 columns are NULLABLE? If you would make the 8th column NULLABLE, what would be the impact?

The table occupies less perm space

The table occupies more perm space

The change has no impact

3. Which of the following statements are not true regarding RAID 5 protection?

Missing blocks of data can be reconstructed

A disk failure does not affect performance

RAID 5 has a higher space penalty than RAID 1

Data and parity are striped across an rnk of disks

4. When dynamic AMP Sampling is used, which of the following are utilized to work out the number of rows in a table?

number of AMPs in the configuration

number of disk arrays in the configuration

average number of rows per block in the sampled cylinder

number of nodes in the configuration

number of data blocks in the sampled cylinder

5. Who can create a secure zone?

DBC

A user with CREATE ZONE privileges

Zone users can define sub-zones below their zone

6. Can you define a Secondary Index on top of a Join Index?

Yes

No

7. The same hash result is generated by which data types?

INTEGER and DATE

DATE and CHAR

BYTE and NUMERIC

CHAR and VARBYTE

CHAR and VARCHAR

8. Which of the following statements concerning PEs are accurate?

The Dispatcher receives steps from the Parser and transmits them to the AMPs

Session Control is responsible for load balancing across the BYNET

The Optimizer develops the least expensive plan to return the response set

The Parser checks statements for proper syntax and evaluates them semantically

9. Can zones be defined without assigning a root?

Yes

No

10. Which of the following statements are true, when creating a secure zone?

Only user DBC can create secure zones

Only Databases can be defined as zone root

A database must be empty before it can be assigned as a zone root

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

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

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)!