| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a cluster? | | 1 |
| what is index? | | 3 |
| which language is used to develop the oracle........? | | 3 |
| We have one Package(which has many function/procedures, SQL
quires etc).
Now we need to check, which query or procedure is taking lot
of time in that Package. ?
How do we do it.
| IBM | 2 |
| What is Public Database Link ? | | 1 |
| What is Index Cluster ? | | 1 |
| When does a Transaction end ? | | 2 |
| What is a heap related to database ? | TCS | 1 |
| what are the things that you consider while creating indexes
on partitioning tables? | | 1 |
| What is the difference between implicit index and explicit
index? | TCS | 1 |
| Describe Referential Integrity ? | | 1 |
| 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 |
| how to insert data into partitioned table partition done by
Range partition | | 1 |
| I need to get the values of the previous quarter.how to do
this?eg: if my cuurent month is may i need to get the datas
of the month jan,feb,march.Can it be done in oracle.I tried
with date function q but for the month jan its not
retriving the previous quarter(oct-dec).how to solve
this.plpz anyone help me? | Philips | 1 |
| 1.What is inline function in oracle and its purpose?
2.What is the equivalent operator for "different from
pattern" in oracle?
3. If you define a variable in oracle, how it will be
available? [a. Until database shut down b. Until table deleted
c. until session get expired]
| | 2 |
| Who i will insert 1 lacks record in a Database table | TCS | 2 |
| HOW CAN RETURN MAX DATE ROW
A B C D E
1 2 1-Mar-09 5 10
1 2 10-Mar-09 5 10
ONLY USING ORACLE PREDEFINED FUNCTION. NOT USER DEFINED.
OUTPUT:--
A B C D E
1 2 10-Mar-09 5 10
| | 1 |
| What is a Data Dictionary ? | | 4 |
| Explain the relationship among Database, Tablespace and Data
file? | | 1 |
| Ho to insert no. of records at a time..i mean i want to
insert 100 records at a time into a table | | 4 |
| |
| For more Oracle General Interview Questions Click Here |