Tag: databases

Questions Related to databases

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

NUPI Access is how many AMP Access?

technology databases

  1. Multiple

  2. One

  3. Two

  4. All of the above

Show answer
Correct Option: B

AI Explanation

To answer this question, we need to understand the relationship between NUPI Access and AMP Access.

NUPI Access refers to the Network User Part Identifier (NUPI), which is a unique identifier used in telecommunications networks. AMP Access, on the other hand, refers to the Access Method Part (AMP), which is a signaling protocol used for communication between network elements.

The given question asks how many AMP Access is equivalent to NUPI Access.

The correct answer is B. One.

This means that NUPI Access corresponds to a single instance of AMP Access.

Features of Primary Key are:
technology databases

  1. Unique

  2. Non Unique

  3. Null

  4. Not Null

  5. All of the above

Show answer
Correct Option: A,D