| Other Oracle General Interview Questions |
|| Asked @
|how to retrieve 1st and last row of table without using
|How do we know whether an index is created on a table ???
|what is integrity constrains?
|which statement is running fastly ie insert or delete?
|what is Materialized view? What is a snapshot? what are the
similarities and differences between Materialized views and
|What is a Temporary Segment ?
|i have a table and it has constraints and i want to get
"ALTER TABLE table_name
ADD CONSTRAINT constraint_name constraint type" this code
must be in string type
please help me
if you want, i can give more explainings
|What is meant by recursive hints ?
|what is host string in sql plus? how does it related to
|I have a table emp. There is only one column in the table.
In that , there are only three rows in that column.
The value in the first row is 'A' and the value in the
second row is 'B' and the third row is 'C'. Now, my question
How will you write a select query to display the output as
Note: order by cannot be used coz it gives us output as CBA.
But the output should be BCA.
|How to make a Data Backup in oracle ? What is the procedure
for creating the dump files in oracle ( any version ) ?
|what is foreign key?
|For more Oracle General Interview Questions Click Here |