databases Online Quiz - 238

Description: databases Online Quiz - 238
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Each AMP is responsible for a subset of rows from each table.

  1. True

  2. False

Correct Option: A
  1. Creates an output map to aid in redistributing data

  2. Data distribution is automatic

  3. Creates a reconfig map to help the DBA repartition data

  4. None of the above

Correct Option: B

Which of the following statements about hashing are true?

  1. The uniqueness value is a component of the row hash value.

  2. In a table that has a NUPI, all rows with the same NUPI value are distributed to the same AMP.

  3. Two Primary Index values that hash to the same row hash value are called hash synonyms.

  4. The output of the hashing algorithm is called the hash map

Correct Option: B,C
  1. AMP's

  2. Parser

  3. Dispatcher

  4. Bynet

  5. Optimiser

Correct Option: B,C,E
  1. Multiple

  2. One

  3. Two

  4. All of the above

Correct Option: B
  1. Unique

  2. Non Unique

  3. Null

  4. Not Null

  5. All of the above

Correct Option: A,D
  1. Fastload

  2. Multiload

  3. BTEQ

  4. TPump

  5. Teradata warehouse builder

Correct Option: B,C,E

Multiload can load data in populated tables.

  1. True

  2. False

Correct Option: A
  1. Can populate Single table

  2. Can load populated tables

  3. Tables with SI and referential integrity can be loaded

  4. Very fast if target table is empty

  5. Table loaded can be accesed while fastload runs.

Correct Option: A,D
  1. BTEQ




  5. TPUMP

Correct Option: B,C,E
  1. having clause

  2. where clause

  3. order by clause

  4. group by clause

Correct Option: C
- Hide questions