Tag: databases

Questions Related to databases

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

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

  1. 0

  2. 1

  3. 2

  4. error

Show answer
Correct Option: C

conditional logic can be applied in which utilitiy?
technology databases

  1. BTEQ

  2. FASTLOAD

  3. MULTILOAD

  4. TPUMP

Show answer
Correct Option: A,C,D