| Other SQL PLSQL Interview Questions |
|| Asked @
|A table was given with 3 columns like Manager id,Manager
Name and Employee name.
Question was to create hierarchy.
|How to return multiple records from procedure?
|using cursors salesman get bonus as 10% of their salary ,
managers get 20% , analalist get 30%. generae a report
showing the employee name, salary , bonus.
|a. Can you delete data from a View.
b. If Yes, can you delete it if there are multiple tables
c. If No, can you delete if there is single source table
which is joining.
|what are the forced views
|write a query filter the null value data following source?
i want output
|When the mutating error will comes? and how it will be
|How do you optimize SQL queries ?
|i have one table with accounts and amounts as
colums.accounts with columns c and d. and amounts with
values 1000,2000,3000 for c and 4000,5000,8000 for d.i need
to find the sum of these accounts c and d individually
and find the differences between their sum using one select
|What is the differnce between view and materialized view
|what is the correct way of selection statement
|what is meant by tuning and tk proof?
|For more SQL PLSQL Interview Questions Click Here |