| Other Oracle AllOther Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| Give the two types of tables involved in producing a star
schema and the type of data they hold. |
| 1 |
| What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace? |
| 2 |
| how to get the values if source table & target table having
duplicate values that matches the lookup condition ?(i want
all duplicate match) |
| 1 |
| What is Virtual Memory? |
| 1 |
| Describe the P2P cycle ? |
| 1 |
| what is different between inline query,subquery& corelated
query? |
Quest | 8 |
| How do you resize a data file? |
| 2 |
| Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE. |
TCS | 10 |
| What is the Query Optimizer. How you optimize your qeury. |
Ericsson | 2 |
| How to find 8th person record in a table?
Plz mail ur answers to
mak2786@gmail.com
Regards
Arun |
| 7 |
| i have marks in table,how to find total? |
| 1 |
| what is shared memory? |
IBM | 1 |
| |
| For more Oracle AllOther Interview Questions Click Here |