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. A Unique Secondary Index has which benefits?

It improves data retrieval speed and efficiency in a query

It enforces uniqueness on a Primary Key

It forces the Optimizer to select a full table scan

Row access is always a one AMP operation

2. Which statement about statistic histograms are valid?

All EH-Histograms have information about the same amount of rows

EQ-Histogram intervals contain all values belonging to the interval

Each EQ-Histogram interval hold information about exactly one column value

The default number of EQ-histogram intervals is 200

3. What are existing phases of Multiload?

Preliminary Phase

DML Phase

DDL Phase

Application Phase

4. What is the result of a full table scan occurring on Teradata?

All data rows are copied into temporary space

Each data block for a table is read

Each data row is accessed only once

A random set of data blocks for a table is read

5. Given a NUSI on columns {A,B} and the following SQL statement: SELECT * FROM WHERE A=1 AND B=1 AND C=1. Can the Optimizer use the NUSI (given strong selectivity)?

Yes

No

6. Can columnar tables have a primary index defined?

Yes

No

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

8. Which of the following is not a TASM request source?

Username

Account name

Database name

Client ID

Estimated Processing Time

9. In which way is data distributed with a Partitioned Primary Index?

It is based on the Secondary Index

It is based on the Primary key of the table

It is on the partitioning column

It is based on the Primary Index of the table

10. Where does Teradata use random AMP sampling?

Indexed Columns

All Columns

All Secondary Indexes

NUSI

USI

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