Tag: databases

Questions Related to databases

Block level operations are performed against populated tables by which utility?

technology databases

  1. Tpump

  2. BulKLoad

  3. FastLoad

  4. MultiLoad

Show answer
Correct Option: D

AI Explanation

To answer this question, you need to understand the utility used for block level operations against populated tables.

Option A) Tpump - This option is incorrect because Tpump is a Teradata utility used for continuous data loading and updating.

Option B) BulKLoad - This option is incorrect because there is no Teradata utility named BulKLoad.

Option C) FastLoad - This option is incorrect because FastLoad is a Teradata utility used for fast loading of data into empty tables.

Option D) MultiLoad - This option is correct because MultiLoad is a Teradata utility used for block level operations against populated tables. It allows for efficient loading, updating, and deleting of data from tables.

The correct answer is D) MultiLoad. This option is correct because MultiLoad is the utility used for block level operations against populated tables.

What is the result of a full table scan occurring on Teradata? (Choose two)
technology databases

  1. All data rows are copied into temporary space

  2. Each data block for a table is read

  3. Each data row is accessed only one

  4. A random set of data blocks for a table is read

Show answer
Correct Option: B,C

Of the following which is a true statement with regard to a primary index operation?
technology databases

  1. When choosing a primary index you should pick a column with a severely limited value set

  2. If distribution is skewed an all-AMP operation will take longer than if all AMPs were evenly utilized

  3. Selecting a NUPI for storing data provides for maximum efficiency and makes the best use of the parallel features of Teradata

  4. The degree of uniqueness is not critical ot efficiency.

Show answer
Correct Option: B

Which are two exclusive features of Teradata? (Choose two)

technology databases

  1. Mature optimizer

  2. Industry standard access language(SQL)

  3. Concurrent users

  4. Parallel architecture

Show answer
Correct Option: A,D

Queries based on set threshold are restricted by which tool?
technology databases

  1. Teradata Manager

  2. BTEQ

  3. Teradata SQL Assistant

  4. TDQM

Show answer
Correct Option: D

You are an administrator at CertKiller.com. CertKiller.com has a Teradata system with 100 GB of permanent space, of which 50 GB is reserved for spool space. The system currently has 30 GB of user data. What is the total available spool space for user queries?

technology databases

  1. 70 GB

  2. 50GB

  3. 30 GB

  4. 80 GB

Show answer
Correct Option: A

AI Explanation

To calculate the total available spool space for user queries, we need to subtract the amount of user data from the reserved spool space.

Given information:

  • Total permanent space = 100 GB
  • Reserved spool space = 50 GB
  • Current user data = 30 GB

To calculate the available spool space, we subtract the current user data from the reserved spool space: Available spool space = Reserved spool space - Current user data

Substituting the given values: Available spool space = 50 GB - 30 GB Available spool space = 20 GB

Therefore, the total available spool space for user queries is 20 GB.

In which way is data distributed with a Partitioned Primary Index?
technology databases

  1. It is based on the Secondary Index

  2. It is based on the primary key of the table

  3. It is on the partitioning column

  4. It is based on the Primary Index of the table

Show answer
Correct Option: D

A Partitioned Primary Index should be used for what two reasons? (Choose two)

technology databases

  1. It is the Primary Key of the table, which guarantees uniqueness

  2. It allows instantaneous dropping of old data and rapid addition of new data

  3. It avoids full table scans without the overhead of a secondary index.

  4. It places all data in a specific range on the same AMP.

Show answer
Correct Option: C,D

An example of an OLTP environment is _____
technology databases

  1. creating a report to show a comparison of sales from this week to last week

  2. creating a report show how much credit can be extended to a customer

  3. creating a report that shows the top ten selling items across all stores for one year

  4. updating a checking account to reflect a deposit

Show answer
Correct Option: D

You are an administrator at CertKiller.com. CertKiller.com has a Teradata system with 100 GB of permanent space and creates User A with 30 GB permanent space. How much spaces will User A have, if User A creates User B with 20 GB permanent space?

technology databases

  1. 70GB

  2. 80GB

  3. 10GB

  4. 30GB

Show answer
Correct Option: C