Tera Data Interview Questions and Answers
Question - 81 : - Name any unique feature which you find only in Teradata and not in any other Relational
Answer - 81 : -
There is a command known as “Update else Insert” (USERT) which is available only in Teradata.
Question - 82 : - Name the important locks in Teradata which you have already accessed?
Answer - 82 : -
These are
- Read Lock
- Write Lock
- Exclusive Lock
- Maintain Lock
- Access Lock
Question - 83 : - What are the components of Teradata with which you are familiar?
Answer - 83 : -
Teradata has many useful components and the users are always free to get the desired outcomes in the shortest possible time. A few of them are widely used and play a significant role in making the tasks simple are spotlighted below.
- Passing Engine
- Virtual Disk
- Access Module Processor
- Binet
- Virtual Storage System
- Meta Manager
Question - 84 : - What are Journals in Teradata?
Answer - 84 : -
In Teradata, Journals are placed on the system to provide data availability in the absence of process failure. There are two types of journals are available are Recovery Journals and Permanent Journals.
Question - 85 : - How many types of BTEQ Exports are there in Teradata?
Answer - 85 : -
Teradata BTEQ Exports are four types, they are
- Export DATA
- Export INDICDATA
- Export REPORT
- Export DIF
Question - 86 : - Explain diff b/w SET and MULTISET tables in Teradata?
Answer - 86 : -
SET Table: Not allows duplicate records.
MULTISET Table: Allows duplicate records.
Question - 87 : - Explain the ways to create a table in Teradata?
Answer - 87 : -
Tables can be created using CREATE TABLE statement, CREATE TABLE a statement with column definition, CREATE TABLE from an existing table, CREATE TABLE statement with a SELECT statement.
Question - 88 : - Write a query to identify the number of AMPs in the system?
Answer - 88 : -
By using SELECT HASHAMP() + 1; query we can find the number of AMPs.
Question - 89 : - What is Spool Space Error in Teradata?
Answer - 89 : -
It's one type of error in Teradata. Spool Space Error will trigger when intermediate results of the query exceed the AMP spool space limit set for a user.
Question - 90 : - Explain the TENACITY command in Teradata?
Answer - 90 : -
TENACITY command in Teradata specifies the total waiting time to establish a new connection.