FREE Teradata for Beginner Questions and Answers
What is the definition of an OLTP environment?
Please select 2 correct answers
Which Teradata database tool enables you to duplicate a table and restore it there?
Explanation:
The utility that allows you to copy a table and restore it to another Teradata database is called Teradata FastExport and FastLoad utilities.
Which of the following is true regarding temporary space?
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?
Explanation:
If you have a Teradata system with 100 GB of permanent space and you create user A with 30 GB of permanent space, and then user A creates user B with 20 GB permanent space, user A will have 10 GB of permanent space left.
Data is hashed across all AMPs in Teradata systems that use two cliques.
A user with no permanent space has been defined by a database administrator. What items are present in this user?
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.
What is the correct definition of a main index operation?
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.