| Other Oracle General Interview Questions |
|| Asked @
|Maximum how many triggers can be updated in table ?
|24. Display the order number for all orders whose average
item cost is greater than the overall average item cost
across all orders.
|i can create a view with two columns from emp table,, later
i need to add one more emp column to existing view.. what is
similarly add one more column to existing primary key
constraint.. please give me the solutions
|pls explain connect by prior with example and its real time
|5. Display full details for the creditor/s who has received
the single largest payment. Do not use a table join or set
operator anywhere in your query.
|how to create a new database in oracle?
|difference between truncate and delete ,drop?
|Is it possible to disable the parameter from while running
the report ?
|Can a property clause itself be based on a property
|What is difference between UNIQUE constraint and PRIMARY KEY
|What is Database Buffers ?
|23. Display the client name for all clients who have placed
an order where any order line has more than 3 items. Do not
use a table join anywhere in your query.
|For more Oracle General Interview Questions Click Here |