Tera Data Interview Questions and Answers
Question - 31 : - Explain PDE.
Answer - 31 : -
PDE basically stands for Parallel Data Extension. PDE basically happens to be an interface layer of software present above the operation system and gives the database a chance to operate in a parallel milieu.
Question - 32 : - Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Answer - 32 : -
We need to use BTEQ Utility in order to do this task. Skip 20, as well as Repeat 60 will be used in the script.
Question - 33 : - What is meant by a node?
Answer - 33 : -
A node basically is termed as an assortment of components of hardware and software. Usually a server is referred to as a node.
Question - 34 : - What do you mean by parsing?
Answer - 34 : -
Parsing is a process concerned with analysis of symbols of string that are either in computer language or in natural language.
Question - 35 : - What are the functions of a Parser?
Answer - 35 : -
A Parser: –
- Checks semantics errors
- Checks syntactical errors
- Checks object existence
Question - 36 : - What is meant by a dispatcher?
Answer - 36 : -
Dispatcher takes a whole collection of requests and then keeps them stored in a queue. The same queue is being kept throughout the process in order to deliver multiple sets of responses.
Question - 37 : - How many sessions of MAX is PE capable of handling at a particular time?
Answer - 37 : -
PE can handle a total of 120 sessions at a particular point of time.
Question - 38 : - In the Primary Index, what is the score of AMPs that are actively involved?
Answer - 38 : -
Only one AMP is actively involved in a Primary Index.
Question - 39 : - What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Answer - 39 : -
- Table Level – All the rows that are present inside a table will certainly be locked.
- Database Level Lock – All the objects that are present inside the database will be locked.
- Row Hash Level Lock – Only those rows will be locked which are corresponding to the particular row.
Question - 40 : - List out all forms of LOCKS that are available in Teradata.
Answer - 40 : -
There are basically four types of LOCKS that fall under Teradata. These are: –
- Read Lock
- Access Lock
- Exclusive Lock
- Write Lock