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

2. Which statements about FALLBACK protection are true?

FALLBACK does not require additional disk space

FALLBACK can be specified at the table level

FALLBACK is associated with AMP cluster

FALLBACK is a data protection scheme that uses cliques

3. What are existing phases of Multiload?

Preliminary Phase

DML Phase

DDL Phase

Application Phase

4. If you try to add row duplicates into a set table with an INSERT INTO...SELECT * FROM <TABLE> statement, what will happen?

I will receive an error message

The duplicates will be filtered automatically

I can add the duplicates, but the table is marked being inconsistent

They will be added

5. Block level operations are performed against populated tables by which utility?

Tpump

BulkLoad

FastLoad

MultiLoad

6. Decomposable data may be indicated by which operators?

LIKE

EQUALS

IN

BETWEEN

SUBSTRING

7. 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)?

Yes

No

8. Can a NUSI be used in a join step?

Yes

No

9. Which of the following are conditions for changing Partition definitions using an ALTER TABLE statement?

Is populated and the ALTER TABLE statements are adding partitions to either the beginning or the end of the table

Is defined with a NUPI

Is empty and not in use

Is populated, but no updates are running

10. Which of the following are purposes that AMP serves?

It does the physical work associated with generating an answer set

It develops the least expensive plan to return the requested response set

It does output conversion and formatting

It has access to a single vdisk

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