| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is pragma restrict_reference in oracle 9i?When we use
this?Give me one realtime scenario? | Wipro | 2 |
| What are the composite date types in oracle?
| | 2 |
| what is the use of ondelete cascade? | | 1 |
| What are the factors that affect OPTIMIZER in choosing an
Optimization approach ? | | 1 |
| Hi Every One , What is the table Space in Oracle Database ?
waiting for answere and thankyou | | 7 |
| how to insert data into partitioned table partition done by
Range partition | | 1 |
| I need to get the values of the previous quarter.how to do
this?eg: if my cuurent month is may i need to get the datas
of the month jan,feb,march.Can it be done in oracle.I tried
with date function q but for the month jan its not
retriving the previous quarter(oct-dec).how to solve
this.plpz anyone help me? | Philips | 1 |
| What is cursor | TCS | 4 |
| What is a Temporary Segment ? | | 2 |
| what is the difference between dbms and rdbms? | Oracle | 2 |
| What are Schema Objects ? | | 1 |
| What is the diff between Oracle and SQL Server | | 1 |
| can u call user defined functions in select statements | | 2 |
| Define 'view' advantage ? | AZTEC | 2 |
| why can't we assign not null constraint as table level
constraint | CTS | 2 |
| What is forall Statement ? | Thermotech | 2 |
| HOW CAN RETURN MAX DATE ROW
A B C D E
1 2 1-Mar-09 5 10
1 2 10-Mar-09 5 10
ONLY USING ORACLE PREDEFINED FUNCTION. NOT USER DEFINED.
OUTPUT:--
A B C D E
1 2 10-Mar-09 5 10
| | 1 |
| 1:-How to write to update command in a procedure in oracle
which update two different table at a time
2:-How to write the select command in a procedure in oracle
which give multiple records | | 1 |
| What is TNS File | Thermotech | 4 |
| Hello All,
Could any one provide me FAQs/interview questions on
oracle PL/SQL
| | 1 |
| |
| For more Oracle General Interview Questions Click Here |