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
what is column? : Sql dba
What is sql and also describe types of sql statements?
Which command is used to call a stored procedure?
What is a nested table in word?
what is the difference between a web-garden and a web-farm? : Sql dba
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
Is stored procedure faster than query?
How do I add a primary key to a table?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Can you join views in sql?
Is the primary key an index?
What does data normalization mean?
What does := mean in pl sql?
How to look at the current sql*plus system settings?
What is partition by in sql?
