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

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
  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

Each AMP Corresponds to a particular Vdisk.

  1. True

  2. False


Correct Option: A

NUPI Access is how many AMP Access?

  1. Multiple

  2. One

  3. Two

  4. All of the above


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.

  1. Unique

  2. Non Unique

  3. Null

  4. Not Null

  5. All of the above


Correct Option: A,D

Which utilities can be used for both Export and Import?

  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

Error capturing is done by these utilities:

  1. BTEQ

  2. FASTLOAD

  3. MULTILOAD

  4. FASTEXPORT

  5. TPUMP


Correct Option: B,C,E

Multiload works in how many phases?

  1. 2

  2. 3

  3. 5

  4. 1


Correct Option: C
  1. having clause

  2. where clause

  3. order by clause

  4. group by clause


Correct Option: C

All DML's are supported by which utility?

  1. Mload

  2. Fload

  3. Bteq

  4. Tpump


Correct Option: C

Select length(-1) from dual What is the output of the above sql stmt

  1. 0

  2. 1

  3. 2

  4. error


Correct Option: C

conditional logic can be applied in which utilitiy?

  1. BTEQ

  2. FASTLOAD

  3. MULTILOAD

  4. TPUMP


Correct Option: A,C,D

If there are frequent updates in tables, then which utility to use?

  1. BTEQ

  2. TPUMP

  3. FASTEXPORT

  4. MULTILOAD


Correct Option: B
- Hide questions