| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the advantages of Views ? | | 1 |
| why pl sql doesn't support retrieving multiple records | Mphasis | 1 |
| what is the use of ondelete cascade? | | 1 |
| When does a Transaction end ? | | 1 |
| What is an Index ? | | 2 |
| What is Data Block ? | | 1 |
| What is STATSPACK tool? | Wipro | 1 |
| Describe the different type of Integrity Constraints
supported by ORACLE ? | | 1 |
| What are the Characteristics of Data Files ? | | 1 |
| What is the difference between column level constraints and
table level constraints? | IBM | 3 |
| What is dictionary cache ? | | 2 |
| What is meant by redo log buffer ? | | 2 |
| What is Normalization ? | Keane-India-Ltd | 7 |
| what is primary key? | | 4 |
| Is primary key = unique key,not null?
If yes,please explain
IF No,please explain | | 3 |
| What is Parallel Server ? | | 1 |
| What is COST-based approach to optimization ? | | 4 |
| What are virtual columns? | TCS | 2 |
| can any one help me with import/export options in
oracle............ | | 1 |
| What is the maximum number of CHECK constraints that can be
defined on a column ? | | 3 |
| |
| For more Oracle General Interview Questions Click Here |