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,

1639

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

TCS,

1603

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

TCS,

1 2694

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

Arrow Electronics,

1 2717

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

Arrow Electronics,

1687

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

CTS,

1749

what is reindexing?

Tata Technologies,

1677

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,

1690

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

Gap Inc,

1 2790

how to handle exceptions in post production

1426

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

1549

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?

1383

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.

1424

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

FIS,

1446

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,

1349

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is meant by raw datatype?

1060

What happens if you set the sga too low in oracle?

1150

What are the execution control statements in oracle?

1095

How to grant create session privilege to a user in oracle?

1001

How to convert dates to characters in oracle?

1041

Difference between cartesian join and cross join?

1040

How to define an oracle cursor variable?

1027

how do u setup a replication site?

1986

How to get execution path reports on query statements?

987

What are ddl statements in oracle?

1075

How to use fetch statement in a loop?

1019

In which language oracle has been developed?

1074

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2116

What is the maximum number of triggers that can be applied to a single table?

1024

How to commit the current transaction in oracle?

1120

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