Un-Answered Questions { Oracle General }

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?

911


HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

964


Can you tell me how to add new column in existing views?how?How is possible?

906


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

834


I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

596


What is the difference between online and offline backups?

543


what is the difference between restoring and recovering?

532


What are the most common interview questions on ETL Testing for experience?

565


In oracle there is column command, how will you explain that?

528


State any two functions of oracle?

615


What is Virtual Private Database in Oracle?

593


Can we create database in oracle using command line ?

560


Why use resource manager in Oracle?

638


What is the difference between view and materialized view in Oracle?

587


What is Undo Management Advisor in Oracle?

587