Question 1

Teradata is suitable for ?

technology databases

OLAP
MOLAP
ROLAP
OLTP

Answer

Correct Option: A

Question 2

Why statistics wizard is used for?

technology databases

To collect statistics
To select best candidate to choose for collect statistics
Provide statistics of load
To easy access of data

Answer

Correct Option: B

Question 3

Is rowId is available in TD?

technology databases

True
False

Answer

Correct Option: A

Question 4

Which Index helps for row selection?

technology databases

UPI
NUPI
USI
NUSI

Answer

Correct Option: D

Question 5

Which Index ensures uniqueness in a table?

technology databases

UPI
NUPI
NUSI
USI

Answer

Correct Option: A

Question 6

Which one is equivalent to PK of oracle?

technology databases

UPI
NUSI
PI
USI

Answer

Correct Option: A

Question 7

Which one is not supported in BTEQ?

technology databases

Case
For
If
Goto

Answer

Correct Option: B

Question 8

Which tool used for population of already populated table?

technology databases

Fastload
MultiLoad
FastExport
TPUMP

Answer

Correct Option: B

Question 9

How many VDISK can be attached to a single AMP?

technology databases

1
4
8
12

Answer

Correct Option: A

Question 10

Which is not a error code for MULTILOAD.

technology databases

4
8
12
20

Answer

Correct Option: D

Question 11

How many minimum nodes are required for MPP instastalltion?

technology databases

1
2
16
32

Answer

Correct Option: B

Question 12

What is logical model from Teradata for financial market?

technology databases

FSLDM
HCLDM
RLDM
CLDM

Answer

Correct Option: A

Question 13

Which component responsible for broadcasting?

technology databases

BYNET
PE
AMP
VDISK

Answer

Correct Option: A

Question 14

How many tables can be populated in a single multiload job?

technology databases

1
8
5
10

Answer

Correct Option: C

Question 15

In the Given below, which tool should you use to collect and analyze database performance?

technology databases

BTEQ
TDQM
Teradata SQL Assistant
Teradata Manager

Answer

Correct Option: D

Question 16

Which statement about spool space is true?

technology databases

Spool space must be specified during creation of the user
Spool space is used to hold the intermediate result set
Spool space is permanent space.
Spool space is limited to the size of the table.

Answer

Correct Option: B

Question 17

In Which way is data distributed with a partitioned primary index?

technology databases

Based on the secondary unique index
Based on the Primary key of the table
Based on the Primary Index of the table
Based on the partitioning column

Answer

Correct Option: C

Question 18

Batch process block level loading are performed against populated tables by which utility?

technology databases

Multiload
BulkLoad
TPUMP
FastLoad

Answer

Correct Option: A

Question 19

Cliques are physically composed of?

technology databases

Gateway's
PE's
Nodes
AMP's

Answer

Correct Option: C

Question 20

Teradata Index wizard used for

technology databases

compare performance of multiple workloads
recommend secondary indexes for a table
recommend primay indexes for a table
compare primay and secondary indexes for a table

Answer

Correct Option: B

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

databases Online Quiz - 44

AI Explanation

Find more quizzes from top tags