What is a SNAPSHOT ?
Answer / nishi
Snapshots and Materialized view are used interchangeably as both are almost same. However, materialized view is having additional feature of query rewrite which is not in snapshot.
| Is This Answer Correct ? | 0 Yes | 0 No |
In Oracle 9i what does "i" Stands for?
In the oracle version 9.3.0.5.0, what does each number shows?
How to convert raw data type into text in oracle? Explain
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to convert times to characters in oracle?
what is difference between DBMS and RDBMS?
Is insert autocommit in oracle?
How to write an inner join with the where clause in oracle?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
How to define and use table alias names in oracle?
List out the difference between commit, rollback, and savepoint?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,