Tera Data Interview Questions and Answers
Question - 111 : - What is ADD Option in Teradata?
Answer - 111 : -
The ADD option reserves additional partition numbers for a partitioning level to enable adding partitions to a partitioning level at a later time using an ALTER TABLE statement The following rules apply to the ADD clause for a row or column partition.
Question - 112 : - Explain QUEUE Keyword?
Answer - 112 : -
Each queue table you define must stipulate the keyword QUEUE as 1 of the CREATE TABLE options following the table name; otherwise, the table you define does not have the properties associated with queue tables and you cannot use consume mode when you select from it (see SQL Data Manipulation Language).
Question - 113 : - What is QITS Column in Teradata?
Answer - 113 : -
The first column defined for any queue table must be a Queue Insertion Time Stamp (QITS) column. Each queue table has only 1 QITS column, and it must be defined exactly as indicated with the following attributes.
QITS_column_name TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6)
where QITS_column_name indicates the name you specify for the QITS column.
Question - 114 : - What are Transition Tables in Teradata?
Answer - 114 : -
A transition table is a dynamically created table that you can reference using a correlation name.
Question - 115 : - Why DATABASE Statement is Not Valid In 2PC Mode?
Answer - 115 : -
In the 2PC mode, DATABASE is treated as a DDL statement, so it is not valid.
Question - 116 : - What are the different types of Teradata utilities?
Answer - 116 : -
There are various utilities available in Teradata. They are:
- Batch Teradata Query (BTEQ)
- FAST EXPORT
- FAST LOAD
- MULTI LOAD
- Teradata Parallel Data Pump(TPump)
- Teradata Parallel Transport (TPT)
Question - 117 : - What are the main components of Teradata Architecture?
Answer - 117 : -
The main components of Teradata Architecture are:
- Parsing Engine(PE)
- Access Module Processors(AMPs)
- BYNETs
- Disks
Question - 118 : - What is BYNET and What is its purpose?
Answer - 118 : -
BYNET is the main component of Teradata architecture and it acts as a message-passing layer. BYNET decides which AMP should receive a message.
Question - 119 : - Explain about Unique Primary Index(UPI) in Teradata?
Answer - 119 : -
A Unique Primary Index (UPI) is unique and cannot have any duplicates. If you try and insert a row with a Primary Index value that is already in the table, the row will be rejected. A UPI enforces UNIQUENESS for a column.
Question - 120 : - Explain the Non-Unique Primary Index (NUPI) in Teradata?
Answer - 120 : -
A Non-Unique Primary Index (NUPI) means that the values for the selected column can be non-unique. Duplicate values can exist.