| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is Public Database Link ? | | 1 |
| what is the syntax of UPDATE command? | | 4 |
| SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN
WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)? | ESS | 1 |
| when do u go for hash partitioning? | | 1 |
| what is the use of rank function? | | 1 |
| What are the values that can be specified for
OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? | | 1 |
| How to create DSN..Explain? | BeBo-Technologies | 1 |
| ex. one table is having 1 column with 10 records ,
then how to display all the values in row wise ? | | 2 |
| What are the values that can be specified for OPTIMIZER
MODE Parameter ? | | 1 |
| What is autonomous transaction? | | 4 |
| What are the composite date types in oracle?
| | 2 |
| Explain the relationship among Database, Tablespace and Data
file? | | 1 |
| Describe Referential Integrity ? | | 1 |
| What is the difference between implicit index and explicit
index? | TCS | 1 |
| Differnce between view and index | | 1 |
| What are the Characteristics of Data Files ? | | 1 |
| What is a Redo Log ? | | 2 |
| what are views? | TCS | 5 |
| What is a Data File ? | | 1 |
| What are the factors causing the reparsing of SQL statements
in SGA? | | 1 |
| |
| For more Oracle General Interview Questions Click Here |