Tag: technology

Questions Related to technology

Fastload can be used for loading multiple tables at a time.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

What are basic units of Teradata Arcitecture?

technology databases

  1. PE

  2. AMP

  3. TDP

  4. CLIQUE

  5. VDISK

Show answer
Correct Option: A,B,E

Intermediate querry results are stored in

technology databases

  1. AMP

  2. BYNET

  3. PE

  4. VDISK

Show answer
Correct Option: B

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

How does Teradata handle data distribution when performing system configuration changes

technology databases

  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

Show answer
Correct Option: B

Which of the following statements about hashing are true?
technology databases

  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

Show answer
Correct Option: B,C

What are the parts of PE?

technology databases

  1. AMP's

  2. Parser

  3. Dispatcher

  4. Bynet

  5. Optimiser

Show answer
Correct Option: B,C,E

Each AMP Corresponds to a particular Vdisk.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

What is NDMP?
technology storage

  1. Network Data Method Protection

  2. Network Data Management Protocol

  3. Network Disaster Mitigation Procedure

  4. Network Data Management Privacy

Show answer
Correct Option: B