Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / subhendu
Features:
1. If the TRUNCATE statement is issued against a temporary
table, only the session specific data is trucated. There is
no affect on the data of other sessions.
2. Data in temporary tables is automatically delete at the
end of the database session, even if it ends abnormally.
3. Indexes can be created on temporary tables. The content
of the index and the scope of the index is that same as the
database session.
4. Views can be created against temporary tables and
combinations of temporary and permanent tables.
5. Temporary tables can have triggers associated with them.
Export and Import utilities can be used to transfer the
table definitions, but no data rows are processed.
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
Which is faster subquery or join?
what are date and time data types in mysql? : Sql dba
what is timestamp in mysql? : Sql dba
what are numeric data types? : Sql dba
How many types of indexes are there in sql?
What type of join is sql join?
What is the syntax to add a record to a table?
Can a varchar be a primary key?
What is rownum in sql?
What is multiple partition?
Why sql query is slow?
What is a full join sql?
Is pl sql a scripting language?
Can we use joins in subquery?
how to use myisamchk to check or repair myisam tables? : Sql dba
