| Other Oracle General Interview Questions |
|| Asked @
|Define the terms primary key foreign key and also the
difference between primary and the unique key
|2. Display the item number and total cost for each order
line (total cost = no of items X item cost). Name the
calculated column TOTAL COST.
|How to call a stored procedure inside a trigger? Give an
|what is primary key and foreign key when and where have to use
|What is cursor
|10. Display the client number, order date and shipping date
for all orders where the shipping date is between three and
six months after the order date.
|What is an Integrity Constrains ?
|What are the Limitations of a CHECK Constraint ?
|1) What is dense ranking?
2) Difference between Substring and Instring?
3) Case and Decode?
4) Pseudo column?
5) View vs Materialized views?
6) SQl performance tuning?
|why can't we assign not null constraint as table level
|what is shell?
|The join defined by the default data link is an outer join
yes or no ?
|For more Oracle General Interview Questions Click Here |