| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| It's Urgent? How to IMPORT .xls & .txt file into ORACLE? | | 5 |
| What are the Limitations of a CHECK Constraint ? | | 4 |
| How can we manage the gap in a primary key column created
by a sequence?
Ex:a company has empno as primary key generated by a
sequence and some employees leaves in between.What is the
best way to manage this gap? | Infosys | 1 |
| what is the difference between UNION AND UNIONALL | | 2 |
| When can Hash Cluster used ? | | 1 |
| what is primary key? | | 5 |
| what are the differen between key flexifild and discriptive
fiexifild. | | 1 |
| Differnce between view and index | | 1 |
| How to transfer database(500 gb) of oracle enterprise
edition to standard edition downtime is only 1 hour not
using exp/imp option ? | Digital-Group | 3 |
| how many columns can a plsql table have | NIIT | 9 |
| What is a Data File ? | | 1 |
| how to find the n'th highest salary from emp ? | | 5 |
| Ho to insert no. of records at a time..i mean i want to
insert 100 records at a time into a table | | 4 |
| What are the components of Physical database structure of
Oracle Database? | | 1 |
| various types of joins | | 6 |
| How are Indexes Update ? | | 1 |
| what is the difference between first normal form & second
normal form? | Oracle | 7 |
| what is the bitmap index? | | 1 |
| How to restrict the duplicate records in table valuesets | IBM | 2 |
| What is the difference between a vector and an Array? (Java) | RBS | 2 |
| |
| For more Oracle General Interview Questions Click Here |