Free Teradata for Beginner Questions and Answers

Question 1

What is the definition of an OLTP environment?

Accepted Answer

Transactions typically occur within seconds, not minutes

Answer

Transactions are write intensive

Answer

The number of rows transaction is large

Question 2

What is the correct definition of a main index operation?

Accepted Answer

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

Answer

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

Answer

The degree of uniqueness is not critical to efficiency

Answer

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

Question 3

Data is hashed across all AMPs in Teradata systems that use two cliques.

Accepted Answer

System

Answer

Disk Array

Answer

Cluster

Answer

Clique

Question 4

A user with no permanent space has been defined by a database administrator. What items are present in this user?

Accepted Answer

Views

Answer

Tables

Answer

Triggers

Answer

Macros

Question 5

Which of the following is true regarding temporary space?

Accepted Answer

Temporary space is permanent space currently not used

Answer

Temporary space is subtracted from SysAdmin

Answer

Temporary space is assigned at the table level

Answer

Temporary space is spool space currently not used

Question 6

You create user A with 30 GB of permanent space on a Teradata system that has 100 GB of permanent space. What will user A have if user B is created with 20 GB of permanent space?

Accepted Answer

10 GB

Answer

80 GB

Answer

30 GB

Answer

70 GB

Question 7

Which Teradata database tool enables you to duplicate a table and restore it there?

Accepted Answer

Archive Recovery

Answer

Table Rebuild

Answer

FastExport

Answer

Teradata Copy Tool