Get prepared for the Certifications with the Teradata Quiz

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. Given the following query (all used objects exist): SELECT Table1.COL1 FROM DATABASENAME.Table2; Will the query work?

Yes

No

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

3. Can you use relative weights in the timeshare tier?

Yes

No

4. When you create a primary index, which of the following options should be taken into consideration?

Primary index values should not be subject to change

Very non-unique values can cause premature "database full" conditions

Columns frequently used for row selection are good candidates

If third normal form you must use a primary key

Duplicate values are not stored in the same block

5. Which of the following are characteristics of the functions of the PE?

It determines which AMP should receive a message

It breaks down SQL requests into steps

It can manage up to 120 individual sessions

It handles output conversion and formatting

It verifies SQL requests for proper syntax

6. What are advantages when using MERGE instead of UPDATE?

No Spoolspace used

Less Disk IOs used

Allows to do UPDATE, INSERT & DELETE at once

7. Would you consider to use block level compression (BLC) in order to reduce perm space usage?

Yes

No

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

Tpump

BulkLoad

FastLoad

MultiLoad

9. Which value will present a NULL value in the presence byte?

0

1

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

Get prepared for the Certifications with the Teradata Quiz

Welcome to the 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)!

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