Tag: databases

Questions Related to databases

Which is not a error code for MULTILOAD.

technology databases

  1. 4

  2. 8

  3. 12

  4. 20

Show answer
Correct Option: D

How many minimum nodes are required for MPP instastalltion?
technology databases

  1. 1

  2. 2

  3. 16

  4. 32

Show answer
Correct Option: B

What is logical model from Teradata for financial market?
technology databases

  1. FSLDM

  2. HCLDM

  3. RLDM

  4. CLDM

Show answer
Correct Option: A

Which component responsible for broadcasting?
technology databases

  1. BYNET

  2. PE

  3. AMP

  4. VDISK

Show answer
Correct Option: A

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

  1. 1

  2. 8

  3. 5

  4. 10

Show answer
Correct Option: C

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

technology databases

  1. BTEQ

  2. TDQM

  3. Teradata SQL Assistant

  4. Teradata Manager

Show answer
Correct Option: D

Which statement about spool space is true?
technology databases

  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.

Show answer
Correct Option: B
Explanation:

To answer this question, the user needs to understand what spool space is and its purpose in a database system.

Option A is incorrect because spool space is not a parameter that is specified during the creation of a user; it is a system resource that is managed by the database.

Option B is correct because spool space is used to store intermediate result sets generated during query processing. Intermediate results are stored in spool space before they are written to disk or sent back to the user.

Option C is incorrect because spool space is not permanent space. It is a temporary storage area that is allocated to each user session and released when the session ends.

Option D is incorrect because spool space is not limited to the size of the table. It is a separate resource that is managed independently of the table storage.

Therefore, the correct answer is:

The Answer is: B

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

technology databases

  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 

Show answer
Correct Option: C

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

  1. Multiload

  2. BulkLoad

  3. TPUMP

  4. FastLoad

Show answer
Correct Option: A

Cliques are physically composed of?
technology databases

  1. Gateway's

  2. PE's

  3. Nodes

  4. AMP's

Show answer
Correct Option: C