Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 77696 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / teja
Derived temporary tables
# Derived tables are local to an SQL query.
# Not included in the DBC data dictionary database, the
definition is kept in cache.
# They are specified on a query level with an AS keyword
in an sql statement
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain the term 'row' related to relational database management system?
Highlight the limitations of TPUMP Utility.
Difference between stored procedure and macro?
How do you determine the number of sessions?
What are the commands to make a new table, change a table and remove a table in teradata?
Name the five phases that come under MultiLoad Utility.
What exactly do you know about catching in teradata?
What is the primary index in teradata?
What are default access rights in teradata?
What are types of partition primary index (ppi) in teradata?
What is the syntax for case when statement?
What are the various indexes in teradata? Why are they preferred?
what is object level locking ? where do appear this type of locking ?
Highlight the points of differences between the database and user in Teradata.
How many sessions of MAX is PE capable of handling at a particular time?
