Oracle General Interview Questions
Questions Answers Views Company eMail

What is set operator oracle?

516

What is where clause in oracle?

524

Which is faster join or subquery in oracle?

524

What is a lookup table in oracle?

528


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to use "startup" command to start default instance?

532


Can multiple cursors being opened at the same time?

602


What suggestions do you have to reduce the network traffic?

535


How do I use os authentication with weblogic jdriver for oracle and connection pools?

566


How to update a table row with a record?

593






Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

920


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1772


How a database is related to tablespaces?

570


What is the maximum limit on the number of columns in a table?

541


When do I need to use a semicolon vs a slash in oracle sql?

580


What are privileges and grants?

562


What is integrity and what is constraint??Explain with example

1689


can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2582


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1598


What happens to the current transaction if a ddl statement is executed?

567