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,

1681

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

TCS,

1651

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

TCS,

1 2773

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

Arrow Electronics,

1 2800

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

Arrow Electronics,

1729

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

CTS,

1801

what is reindexing?

Tata Technologies,

1729

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,

1746

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

Gap Inc,

1 2870

how to handle exceptions in post production

1484

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

1601

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?

1436

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.

1471

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

FIS,

1515

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,

1395

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Why do you use stored procedures and state some of its disadvantages?

1071

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1991

How many anonymous blocks can be defined?

1251

Can we use bind variables in oracle stored procedure?

985

What is an external table?

1080

What is a snapshot in oracle database?

1070

WHAT IS ecc 6.0

2201

Is oracle an open source?

1124

What is oracle rowcount?

1143

State some uses of redo log files?

1064

What is the difference between truncate & delete command?

1233

What is Virtual Private Database in Oracle?

1148

How many types of segments in Oracle?

1114

How many types of synonyms in Oracle?

1175

Explain the importance of .pll extension in oracle?

1057

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