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

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

Explanation:
The statement "If distribution is skewed an all-AMP operation will take longer than if all AMP were evenly utilized" is true about a primary index operation.

Question 3

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

Accepted Answer

System

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

Explanation:
If a database administrator has defined a user with no permanent space, the objects that can be found in this user are only volatile objects.

In Teradata, a user with no permanent space is called a "no spool" user. This type of user can create volatile tables and views but cannot create permanent tables, indexes, macros, triggers, stored procedures, or any other objects that require permanent space. Volatile tables and views are temporary objects that are automatically dropped at the end of a session or transaction and do not consume permanent space.

Question 5

Which of the following is true regarding temporary space?

Accepted Answer

Temporary space is permanent space currently not used

Teradata Practice Test

Teradata Practice Test

FREE Teradata for Beginner Questions and Answers