databases Online Quiz - 44

Description: databases Online Quiz - 44
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  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 one is equivalent to PK of oracle?

  1. UPI

  2. NUSI

  3. PI

  4. USI

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

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

  1. BTEQ

  2. TDQM

  3. Teradata SQL Assistant

  4. Teradata Manager

Correct Option: D

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