| Other Oracle AllOther Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How do you resize a data file? | | 1 |
| HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY? | | 3 |
| Explain the difference between a hot backup and a cold
backup and the benefits associated with each | | 1 |
| what is the difference between TRUNCATE and DELETE command
in SQL | TCS | 14 |
| how to display last 5 letters from a name (take emp table
ename ) | IBM | 3 |
| what is different between inline query,subquery& corelated
query? | Quest | 3 |
| what is sql*loader parameters and where we will use it. | Accenture | 1 |
| How can you enable a trace for a session? | | 2 |
| A Table has 10,000 records,How can i get latest 10 dates
from the table.so that i can only store those 10 records
in to my Resultset Object,to reduce load on my app? | TCS | 4 |
| Explain the difference between a data block, an extent and
a segment. | IBM | 1 |
| can u tell me how many types of oracle and which type all
detail in oracle (suppose all history of oracle ) | Oracle | 1 |
| Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE. | | 2 |
| When creating a user, what permissions must you grant to
allow them to connect to the database? | | 2 |
| What command would you use to encrypt a PL/SQL application? | | 1 |
| how can it possibble to see the report output in excel
sheet in oracle applications | Wipro | 3 |
| What is difference b/w Credit memo and Adjustment in AR. | Oracle | 1 |
| What is the difference between the SQL*Loader and IMPORT
utilities? | | 1 |
| What type of index should you use on a fact table? | | 1 |
| wht r the base tables & primary key for BOM& WIP modules | Satyam | 1 |
| What is Virtual Memory? | | 1 |
| |
| For more Oracle AllOther Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
