| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a Data Segment ? | | 2 |
| What is Index and different types of Indexes? | | 4 |
| What is E-R diagram ? | Keane-India-Ltd | 1 |
| What are the composite date types in oracle?
| | 2 |
| what is the use of ondelete cascade? | | 1 |
| What is Hash Index? | | 1 |
| What is dictionary cache ? | | 2 |
| What is an Index ? How it is implemented in Oracle Database ? | | 2 |
| how do u know the total no of rows in a table? | | 2 |
| What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ? | | 1 |
| what are indexes..how many types of index's are there and
what are they? | TCS | 5 |
| What are the advantages of Views ? | | 1 |
| How do you rate yourself in oracle and sql server ? | Keane-India-Ltd | 1 |
| what is difference between where clause and having clause? | | 8 |
| what diffrence between function and procedure? | | 4 |
| What are inner join and outer join? | | 2 |
| what are pseudocolumns? | | 4 |
| Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"? | | 1 |
| what is the difference between dbms and rdbms? | Oracle | 2 |
| What is difference between UNIQUE constraint and PRIMARY KEY
constraint ? | | 2 |
| |
| For more Oracle General Interview Questions Click Here |