| Other Oracle General Interview Questions |
|| Asked @
|9. Display the client name and order date for all orders
using the JOIN . . . USING method.
|Describe the different type of Integrity Constraints
supported by ORACLE ?
|What is autonomous transaction?
|Is it possible to join two tables, that are in two different
users (e.g. SCOTT and HR etc.),but im same database
If yes, then how it is possible?
Explain with step by step procedure.
|what is trigger?
|What is Parallel Server ?
|Given two table employee and department
que-Write a query to find count of employee in each
|I have one table :EID,Depid,ename,sal
I want to have max(sal) in each department.
|can anyone help me ?
an index has been done on the primary key of a table. an
update operation was performed on that table.
now my question is
1> what abt the performance ? means faster or slower due to
2> does the operation affect to the primary key constraint ?
|I have my backup RMAN script called backup_rman.sh. I am on
the target database. My catalog username/password is
rman/rman. My catalog db is called rman. How would you run
this shell script from the O/S such that it would run as a
|find the second highest salary of the emp table
|What is cluster Key ?
|For more Oracle General Interview Questions Click Here |