0

databases Online Quiz - 44

Description: databases Online Quiz - 44
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Teradata is suitable for ?

  1. OLAP

  2. MOLAP

  3. ROLAP

  4. OLTP


Correct Option: A
  1. To collect statistics

  2. To select best candidate to choose for collect statistics

  3. Provide statistics of load

  4. To easy access of data


Correct Option: B

Is rowId is available in TD?

  1. True

  2. False


Correct Option: A

Which Index helps for row selection?

  1. UPI

  2. NUPI

  3. USI

  4. NUSI


Correct Option: D

Which one is equivalent to PK of oracle?

  1. UPI

  2. NUSI

  3. PI

  4. USI


Correct Option: A

How many VDISK can be attached to a single AMP?

  1. 1

  2. 4

  3. 8

  4. 12


Correct Option: A

Which is not a error code for MULTILOAD.

  1. 4

  2. 8

  3. 12

  4. 20


Correct Option: D

How many minimum nodes are required for MPP instastalltion?

  1. 1

  2. 2

  3. 16

  4. 32


Correct Option: B

Which component responsible for broadcasting?

  1. BYNET

  2. PE

  3. AMP

  4. VDISK


Correct Option: A

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

  1. 1

  2. 8

  3. 5

  4. 10


Correct Option: C

Which statement about spool space is true?

  1. Spool space must be specified during creation of the user

  2. Spool space is used to hold the intermediate result set

  3. Spool space is permanent space.

  4. Spool space is limited to the size of the table.


Correct Option: B
  1. Based on the secondary unique index

  2. Based on the Primary key of the table

  3. Based on the Primary Index of the table

  4. Based on the partitioning columnĀ 


Correct Option: C

Cliques are physically composed of?

  1. Gateway's

  2. PE's

  3. Nodes

  4. AMP's


Correct Option: C

AI Explanation

To answer this question, you need to understand the concept of cliques in a network.

A clique is a subset of nodes in a graph where every pair of nodes is connected by an edge. In other words, in a clique, every node is directly connected to every other node in the subset.

The correct answer is option C) Nodes. Cliques are physically composed of nodes, which represent the individual entities or elements in a network.

Teradata Index wizard used for

  1. compare performance of multiple workloads

  2. recommend secondary indexes for a table

  3. recommend primay indexes for a table

  4. compare primay and secondary indexes for a table


Correct Option: B
- Hide questions