Tag: technology

Questions Related to technology

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

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

Which utilities can be used for both Export and Import?

technology databases

  1. Fastload

  2. Multiload

  3. BTEQ

  4. TPump

  5. Teradata warehouse builder

Show answer
Correct Option: B,C,E

Multiload can load data in populated tables.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Features of Fastload include:
technology databases

  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.

Show answer
Correct Option: A,D

A column of a table is declared as NUMBER(10,2).For which of the following values oracle returns an error during insertion

technology databases

  1. 5392845.324

  2. 871039453.1

  3. 97234512.123

  4. 1234567.12

Show answer
Correct Option: B

Error capturing is done by these utilities:

technology databases

  1. BTEQ

  2. FASTLOAD

  3. MULTILOAD

  4. FASTEXPORT

  5. TPUMP

Show answer
Correct Option: B,C,E

Multiload works in how many phases?
technology databases

  1. 2

  2. 3

  3. 5

  4. 1

Show answer
Correct Option: C

Sub query cannot have which clause defined for it

technology databases

  1. having clause

  2. where clause

  3. order by clause

  4. group by clause

Show answer
Correct Option: C

All DML's are supported by which utility?

technology databases

  1. Mload

  2. Fload

  3. Bteq

  4. Tpump

Show answer
Correct Option: C