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?

370


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.

353


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

310


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.

237


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?

30





What is the difference between online and offline backups?

19


what is the difference between restoring and recovering?

32


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

36


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

24


State any two functions of oracle?

27





What is Virtual Private Database in Oracle?

28


Can we create database in oracle using command line ?

25


Why use resource manager in Oracle?

23


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

29


What is Undo Management Advisor in Oracle?

33