Free Teradata Random Questions and Answers

Question 1

What part is in charge of input conversion?

Accepted Answer

PE

Answer

CLI

Answer

AMP

Answer

BYNET

Question 2

What Operating System is capable of running Teradata?

Accepted Answer

All of the above

Answer

Windows

Answer

Linux

Answer

Z

Question 3

Which will only ever return one Row?

Accepted Answer

Both

Answer

None

Answer

UPI

Answer

USI

Question 4

Because of _____, a uniqueness value is necessary to provide a unique Row ID.

Accepted Answer

Both Answers

Answer

None of the above

Answer

Duplicates values in NUPI

Answer

Hash synonym

Question 5

A secondary index operation that is not unique is always a ____________.

Accepted Answer

ALL AMPs operation

Answer

Three AMPs operation

Answer

One AMP operation

Answer

Five AMPs operation

Question 6

Which of the following features of a partitioned table over a nonpartitioned table is a benefit?
I) There are fast deletes of all the rows in a partition
II) Fewer AMPs are involved when accessing data
III) Range queries can be executed without a secondary index
IV) There is faster access of a single row via a primary index access

Accepted Answer

I, II & III

Answer

II & IV

Answer

I & III

Answer

I & III

Question 7

Which of these statements regarding databases is true?

Accepted Answer

None

Answer

Is an Active repository

Answer

Require password

Answer

Not empty even though objects are not created