| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| when do u go for hash partitioning? | | 1 |
| What is a Temporary Segment ? | | 2 |
| which language is used to develop the oracle........? | | 3 |
| how to use sequence and what use of sequence cache | | 1 |
| how to truncate date and get only time part 9:20:00 | | 4 |
| structural difference between bitmap and btree index ? | Infosys | 1 |
| Please explain the difference between outer join and inner
join? With examples would be appreciable..! | IBM | 2 |
| How to define Data Block size ? | | 1 |
| What is an Index ? | | 2 |
| How can we Update a table with out using UPDATE command? | | 1 |
| What are the uses of Rollback Segment ? | | 2 |
| What are the factors causing the reparsing of SQL statements
in SGA? | | 1 |
| what are Triggers? | TCS | 2 |
| how many types of index? | Cap-Gemini | 2 |
| what is the difference between UNION AND UNIONALL | | 2 |
| One Table having two rows with one colomn having values
Like"Male" and "Female". how to upadte these values
Like "Female" and "Male" in single update statement. | Polaris | 3 |
| What is a deadlock ? Explain . | | 1 |
| What is DTS and purpose of DTS ? | TCS | 1 |
| can a view be updated? | | 2 |
| how many columns can a plsql table have | NIIT | 9 |
| |
| For more Oracle General Interview Questions Click Here |