Tera Data Interview Questions and Answers
Question - 21 : - Explain the meaning of Amp?
Answer - 21 : -
Amp basically stands for Access Module Processor and happens to be a processor working virtually and is basically used for managing a single portion of the database. This particular portion of database cannot be shared by any other Amp. Thus, this form of architecture is commonly referred to as shared-nothing architecture.
Question - 22 : - What does Amp contain and what are all the operations that it performs?
Answer - 22 : -
Amp basically consists of a Database Manager Subsystem and is capable of performing the operations mentioned below.
- Performing DML
- Performing DDL
- Implementing Aggregations and Joins.
- Releasing and applying locks, etc.
Question - 23 : - What is meant by a Parsing Engine?
Answer - 23 : -
PE happens to be a kind Vproc. Its primary function is to take SQL requests and deliver responses in SQL. It consists of a wide array of software components that are used to break SQL into various steps and then send those steps to AMPs.
Question - 24 : - What is the meaning of Caching in Teradata?
Answer - 24 : -
Caching is considered as an added advantage of using Teradata as it primarily works with the source which stays in the same order i.e. does not change on a frequent basis. At times, Cache is usually shared amongst applications.
Question - 25 : - How can we check the version of Teradata that we are using currently?
Answer - 25 : -
Just give the command .SHOW VERSION.
Question - 26 : - Give a justifiable reason why Multi-load supports NUSI instead of USI.
Answer - 26 : -
The index sub-table row happens to be on the same Amp in the same way as the data row in NUSI. Thus, each Amp is operated separately and in a parallel manner.
Question - 27 : - How is MLOAD Client System restarted after execution?
Answer - 27 : -
The script has to be submitted manually so that it can easily load the data from the checkpoint that comes last.
Question - 28 : - How is MLOAD Teradata Server restarted after execution?
Answer - 28 : -
The process is basically carried out from the last known checkpoint, and once the data has been carried out after execution of MLOAD script, the server is restarted.
Question - 29 : - What is meant by a Channel Driver?
Answer - 29 : -
A channel driver is software that acts as a medium of communication between PEs and all the applications that are running on channels which are attached to the clients.
Question - 30 : - What is TPD?
Answer - 30 : -
TPD basically stands for Trusted Parallel Database, and it basically works under PDE. Teradata happens to be a database that primarily works under PDE. This is the reason why Teradata is usually referred to as Trusted Parallel or Pure Parallel database.