Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

What the is the diff between local index and global index. give some example.

TCS,

1592

What is snapshot is too old? Give and example for better understand.

TCS,

1549

Can u make a synonym for deptno=10 only from emp table.

TCS,

1 2608

what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

Arrow Electronics,

1 2638

how to do daily transactions with out sql* loader control file regesterd in apps?

Arrow Electronics,

1636

1) Does oracle have any table which contain all the exceptions and it's code internally?

CTS,

1700

what is reindexing?

Tata Technologies,

1614

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

IBM,

1623

how to retrieve data from different tables ,place this data in different excel worksheets.

Gap Inc,

1 2695

how to handle exceptions in post production

1362

How to get maxsal , minsal, ename department wise in single query

1502

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?

1328

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.

1374

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

FIS,

1374

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.

Infosys,

1291

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to check your oracle database 10g xe installation?

930

Is rowid unique in oracle?

943

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2311

Explain a segment?

1029

What is define in oracle?

1009

What is a named program unit?

1025

How to use fetch statement in a loop?

977

How to retrieve data from an cursor to a record?

1023

How to insert a record into a table?

1024

What is a subquery?

1060

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1941

What is blob data type in oracle?

1052

What is blob datatype?

1061

How to manage transaction isolation level?

951

what are steps for interface? where is exchange rate defined in which table?

2062

For More Un-Answered { Oracle General } Questions Click Here