Tag: databases

Questions Related to databases

MTDP is required for client attached system
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Request & response is controlled by
technology databases

  1. TDP

  2. CLI

  3. ODBC

  4. MOSI

Show answer
Correct Option: B

Clique is a collection of
technology databases

  1. AMP

  2. PE

  3. NODE

  4. Vdisk

Show answer
Correct Option: C

Teradata can be expanded linearly
technology databases

  1. True

  2. False

Show answer
Correct Option: B

In Teradata v2r5 onwards, which component can be software and hardware both
technology databases

  1. PE

  2. AMP

  3. BYNET

  4. PDE

Show answer
Correct Option: C

Actual request processing is done by which component
technology databases

  1. PE

  2. AMP

  3. Vdisk

  4. TDP

Show answer
Correct Option: B

In Teradata SMP stands for
technology databases

  1. Scalar Module Processor

  2. Synchronous Module Processor

  3. Synchronous Multiple Processor

  4. Scalar Multiple Processor

Show answer
Correct Option: B

Which transformation has sorted input option available in the properties?
technology databases

  1. Joiner, Sorter

  2. Aggregator, Update Strategy

  3. Aggregator, Joiner

  4. All of above

Show answer
Correct Option: C

Which is true regarding joiner transformation?
technology databases

  1. We cannot use joiner transformation when any input pipeline contains update strategy transformation

  2. We can connect sequence generator transformation directly before the joiner

  3. Both of above options

  4. None of the above

Show answer
Correct Option: A

For Aggregator default cache directory is?
technology databases

  1. $CachePMDir

  2. $PMCacheDir

  3. $PMDir

  4. None of the above

Show answer
Correct Option: B