Which utilities can be used for both Export and Import?
Fastload
Multiload
BTEQ
TPump
Teradata warehouse builder
Multiload can load data in populated tables.
True
False
Features of Fastload include:
Can populate Single table
Can load populated tables
Tables with SI and referential integrity can be loaded
Very fast if target table is empty
Table loaded can be accesed while fastload runs.
A column of a table is declared as NUMBER(10,2).For which of the following values oracle returns an error during insertion
5392845.324
871039453.1
97234512.123
1234567.12
Error capturing is done by these utilities:
FASTLOAD
MULTILOAD
FASTEXPORT
TPUMP
Multiload works in how many phases?
2
3
5
1
Sub query cannot have which clause defined for it
having clause
where clause
order by clause
group by clause
All DML's are supported by which utility?
Mload
Fload
Bteq
Tpump
Select length(-1) from dual What is the output of the above sql stmt
0
error
conditional logic can be applied in which utilitiy?