0

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

It is impossible to have skewed data when employing a Non-Unique Primary Index value?

  1. True

  2. False


Correct Option: B
  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

Features of Fastload include:

  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

  2. FASTLOAD

  3. MULTILOAD

  4. FASTEXPORT

  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