Question 1

Each AMP is responsible for a subset of rows from each table.

technology databases

True
False

Answer

Correct Option: A

Question 2

It is impossible to have skewed data when employing a Non-Unique Primary Index value?

technology databases

True
False

Answer

Correct Option: B

Question 3

How does Teradata handle data distribution when performing system configuration changes

technology databases

Creates an output map to aid in redistributing data
Data distribution is automatic
Creates a reconfig map to help the DBA repartition data
None of the above

Answer

Correct Option: B

Question 4

Which of the following statements about hashing are true?

technology databases

The uniqueness value is a component of the row hash value.
In a table that has a NUPI, all rows with the same NUPI value are distributed to the same AMP.
Two Primary Index values that hash to the same row hash value are called hash synonyms.
The output of the hashing algorithm is called the hash map

Answer

Correct Option: B,C

Question 5

What are the parts of PE?

technology databases

AMP's
Parser
Dispatcher
Bynet
Optimiser

Answer

Correct Option: B,C,E

Question 6

Each AMP Corresponds to a particular Vdisk.

technology databases

True
False

Answer

Correct Option: A

Question 7

NUPI Access is how many AMP Access?

technology databases

Multiple
One
Two
All of the above

Answer

Correct Option: B

Question 8

Features of Primary Key are:

technology databases

Unique
Non Unique
Null
Not Null
All of the above

Answer

Correct Option: A,D

Question 9

Which utilities can be used for both Export and Import?

technology databases

Fastload
Multiload
BTEQ
TPump
Teradata warehouse builder

Answer

Correct Option: B,C,E

Question 10

Multiload can load data in populated tables.

technology databases

True
False

Answer

Correct Option: A

Question 11

Features of Fastload include:

technology databases

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.

Answer

Correct Option: A,D

Question 12

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

5392845.324
871039453.1
97234512.123
1234567.12

Answer

Correct Option: B

Question 13

Error capturing is done by these utilities:

technology databases

BTEQ
FASTLOAD
MULTILOAD
FASTEXPORT
TPUMP

Answer

Correct Option: B,C,E

Question 14

Multiload works in how many phases?

technology databases

2
3
5
1

Answer

Correct Option: C

Question 15

Sub query cannot have which clause defined for it

technology databases

having clause
where clause
order by clause
group by clause

Answer

Correct Option: C

Question 16

All DML's are supported by which utility?

technology databases

Mload
Fload
Bteq
Tpump

Answer

Correct Option: C

Question 17

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

technology databases

0
1
2
error

Answer

Correct Option: C

Question 18

conditional logic can be applied in which utilitiy?

technology databases

BTEQ
FASTLOAD
MULTILOAD
TPUMP

Answer

Correct Option: A,C,D

Question 19

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

technology databases

BTEQ
TPUMP
FASTEXPORT
MULTILOAD

Answer

Correct Option: B

Question 20

The standard EMP table contains 14 records corresponding to the employess of the corporation.One of those records has a NULL value stored in the MGR column.If Issue the following command on the table:select count(mgr) from emp;which of the following choice indentifies the result oracle will return

technology databases

<14
>14
14
0

Answer

Correct Option: A

Description: databases Online Quiz - 238
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 238

Find more quizzes from top tags