Tag: databases

Questions Related to databases

What type of distributions are there?
technology databases

  1. SMP

  2. PMP

  3. MPP

  4. PPP

Show answer
Correct Option: A,C

Teradata is suitable for ?
technology databases

  1. OLAP

  2. MOLAP

  3. ROLAP

  4. OLTP

Show answer
Correct Option: A

Why statistics wizard is used for?

technology databases

  1. To collect statistics

  2. To select best candidate to choose for collect statistics

  3. Provide statistics of load

  4. To easy access of data

Show answer
Correct Option: B

Is rowId is available in TD?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which Index helps for row selection?
technology databases

  1. UPI

  2. NUPI

  3. USI

  4. NUSI

Show answer
Correct Option: D

Which Index ensures uniqueness in a table?
technology databases

  1. UPI

  2. NUPI

  3. NUSI

  4. USI

Show answer
Correct Option: A

Which one is equivalent to PK of oracle?
technology databases

  1. UPI

  2. NUSI

  3. PI

  4. USI

Show answer
Correct Option: A

Which one is not supported in BTEQ?
technology databases

  1. Case

  2. For

  3. If

  4. Goto

Show answer
Correct Option: B

Which tool used for population of already populated  table?

technology databases

  1. Fastload

  2. MultiLoad

  3. FastExport

  4. TPUMP

Show answer
Correct Option: B

How many VDISK can be attached to a single AMP?
technology databases

  1. 1

  2. 4

  3. 8

  4. 12

Show answer
Correct Option: A