Interested to Buy Any Domain ? << Click Here >> for more details...
IBM QUESTION
As all we know PE takes the SQL Request and it will give
responce for that query. what is the internal process
happening.how it is taking that sql from the system?????
thanks in Advance
- 2 Answers
- 8827 Views
- Cap Gemini, IBM, Infosys, I also Faced
- E-Mail Answers
Answer Posted / sridhar
when the user connect to a database he open a session with PE
there after submit a query.
PE take the query and check the syntax,verify it rights for that PE create session.
session is nothing but logical connection b/w user and Application,it verify the authentication and authorization user, if it k it continues the process.
Next PE perform the parser.
query rewrite mechanism
Optimization
Generate
PE dispatch the response to given Request(User).
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the string manipulation operators and functions associated with teradata?
What are default access rights in teradata? What explicit right can be given to a user?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What do you mean by caching in teradata?
What is meant by a Clique?
List out some of the primary characteristics of teradata.
What is TPD?
List the logical and conditional operators that are used with teradata along with their meanings?
List out teradata data types?
Explain and compare pros and cons of snow flake schemas?
What happens when a node suffers a downfall?
Difference between multiload and tpump?
What are the frequently used data types in teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
