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 of the following statements about NOPI tables are wrong?

NOPI Tables are always SET tables

NOPI tables can have secondary indexes

NOPI tables cannot have a Join Index

NOPI tables can be fallback protected

NOPI tables can have triggers

2. Of the following, which are true statements about permanent space?

Macros require permanent space

Tables and views are defined in permanent space

All databases have a defined upper limit of permanent space

Permanent space is not physically allocated at object definition time

3. Which statements are true, if you want to avoid rollbacks?

Don't INSERT rows into a already populated table

Don't UPDATE the table, but INSERT...SELECT into an empty table

Turn off FALLBACK table protection

Use fastloads instead of BTEQ imports

4. 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

5. Does the Nested Join always require an unique index on the left table?

Yes

No

6. What are the main tools for tactical workload?

Row Partitioning

Unique Secondary Index Access

Unique Primary Index Access

The Nested Join

The Rowkey Based Mere Join

7. What are criterias for selecting a primary index?

Access paths to Data

Distribution of Data

Row Size

Volatility of Data

8. Is the row hash value of 1 (INTEGER) the same like the row hash value of '1' (CHAR)?

Yes

No

9. Which of the following statements are true concerning Partitioned Primary indexes?

To store rows using PPI you specify partitioning in the CREATE TABLE statement

They can reduce the number of rows processed by using partition elimination

PPI is beneficial in queries specifying range constraints

PPI is used to enhance performance against small tables

10. What will be the performance impact of 1MB data blocks?

Performance of row partitioned tables may suffer

Performance of sorting may suffer

The system needs more memory

Block Level Compression will be less efficient

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